[Opensim-dev] Strange issues with MySQL / SVN.7869+

Fri Dec 26 10:16:41 UTC 2008

Well, first mono 2.3 is not an official release of Mono.
I suggest to run with mono 2.01 that is the official mono release for now.
 It will help us to track if it's an mono or opensim or mysql issue.

Eventually check your mysql connection's strings. Maybe it has beed edited
and a wrong caracteres was inserted.

thx
Sacha

On Fri, Dec 26, 2008 at 11:10 AM, Ursula MATOVA <
ursula.matova at klintcentral.net> wrote:

> Hi all,
>
> Well, before opening a Mantis, I'd like to know if people are experiencing
> issues my MySQL backend.
> This starts a few days ago.
>
> 1/ My System :
>
> Ubuntu 8.0.4/x86_64 running on a Xeon 2.66GHz / 8GB Ram.
> Mono 2.3
>
> 2/ My OpenSim server infos :
>
> OpenSim SVN.7873,
> Grid mode / 5x5 Regions,
> MySQL as storage backend,
> ODE ( libode.so used is the one provided )
> On the whole grid ( 25 Regions ) I have about 8200 prims.
>
> 3/ About the problem :
>
> As os SVN.7869, I have noted some errors on the different servers consoles
> :
>
> 3a/ Messages when you start OpenSim.exe :
>
> UserServer console :
>
> ( Repeated 25 times - once per Region )
>
> User# :
> 10:41:46 - [REGION DB]: Reconnecting database
> 10:41:46 - System.FormatException: Input string was not in the correct
> format
>  at System.Int16.Parse (System.String s) [0x00014] in
> /root/MONO/MONO23/mcs/class/corlib/System/Int16.cs:212
>  at System.Convert.ToInt16 (System.String value) [0x00008] in
> /root/MONO/MONO23/mcs/class/corlib/System/Convert.cs:1102
>  at OpenSim.Data.MySQL.MySQLManager.readAgentRow (IDataReader reader)
> [0x000a5] in /OPENSIM/opensim.7873/OpenSim/Data/MySQL/MySQLManager.cs:503
>  at OpenSim.Data.MySQL.MySQLUserData.GetAgentByUUID (UUID uuid) [0x0004d]
> in /OPENSIM/opensim.7873/OpenSim/Data/MySQL/MySQLUserData.cs:606
> 10:41:47 - [MSGCONNECTOR]: Sending region down notice to registered message
> servers
> 10:41:47 - [REGION UPDOWN]: Notified : http://88.191.89.70:8006 about
> region state change
>
> GridServer console :
>
> NONE
>
> AssetServer console :
>
> ( Repeated 11 times - 11 differents assetID )
>
> 10:41:47 - [REGION DB]: Reconnecting database
> 10:41:47 - [REST]: GET:/asset found 18817fc3-23ab-4e44-b3d5-b92eb842f8b5
> with name bedPillow, size 16432 bytes
> 10:41:47 - [ASSETS DB]: MySql failure fetching asset
> a0100000-0000-0808-2008-210000000001
> System.InvalidCastException: Cannot cast from source type to destination
> type.
>  at OpenSim.Data.MySQL.MySQLAssetData.FetchAsset (UUID assetID) [0x000c1]
> in /OPENSIM/opensim.7873/OpenSim/Data/MySQL/MySQLAssetData.cs:147
> Reconnecting
>
> InventoryServer console :
>
> NONE
>
> MessagingServer console :
>
> NONE
>
> RegionServer console :
>
> NONE
>
> 3b / Avatar 1rst Login :
>
> UserServer console :
>
> User# :
> 10:57:04 - [LOGIN BEGIN]: XMLRPC Received login request message from user
> 'Ursula' 'Matova'
> 10:57:04 - [LOGIN]: XMLRPC Client is Second Life Release 1.21.6.99587,
> start location is last
> 10:57:04 - [REGION DB]: Reconnecting database
> 10:57:04 - System.FormatException: Input string was not in the correct
> format
>  at System.Int16.Parse (System.String s) [0x00014] in
> /root/MONO/MONO23/mcs/class/corlib/System/Int16.cs:212
>  at System.Convert.ToInt16 (System.String value) [0x00008] in
> /root/MONO/MONO23/mcs/class/corlib/System/Convert.cs:1102
>  at OpenSim.Data.MySQL.MySQLManager.readAgentRow (IDataReader reader)
> [0x000a5] in /OPENSIM/opensim.7873/OpenSim/Data/MySQL/MySQLManager.cs:503
>  at OpenSim.Data.MySQL.MySQLUserData.GetAgentByUUID (UUID uuid) [0x0004d]
> in /OPENSIM/opensim.7873/OpenSim/Data/MySQL/MySQLUserData.cs:606
> 10:57:04 - [LOGIN]: Contacting inventory service at
> http://88.191.89.70:8004/ for inventory skeleton of user
> 3ca50cc4-6137-4a89-906e-cba40f514184
> 10:57:04 - [LOGIN]: AddActiveGestures, found 0
> 10:57:04 - [LOGIN]: Telling Pharia @ 1000,1000 (http://88.191.89.70:9000/)
> to prepare for client connection
> 10:57:04 - [REGION DB]: Reconnecting database
> 10:57:04 - System.FormatException: Input string was not in the correct
> format
>  at System.Int16.Parse (System.String s) [0x00014] in
> /root/MONO/MONO23/mcs/class/corlib/System/Int16.cs:212
>  at System.Convert.ToInt16 (System.String value) [0x00008] in
> /root/MONO/MONO23/mcs/class/corlib/System/Convert.cs:1102
>  at OpenSim.Data.MySQL.MySQLManager.readAgentRow (IDataReader reader)
> [0x000a5] in /OPENSIM/opensim.7873/OpenSim/Data/MySQL/MySQLManager.cs:503
>  at OpenSim.Data.MySQL.MySQLUserData.GetAgentByUUID (UUID uuid) [0x0004d]
> in /OPENSIM/opensim.7873/OpenSim/Data/MySQL/MySQLUserData.cs:606
> 10:57:04 - [MSGCONNECTOR]: Sending login notice to registered message
> servers
> 10:57:04 - [LOGIN END]:  XMLRPC Authentication of user Ursula Matova
> successful.  Sending response to client.
> 10:57:04 - [LOGIN]: Notified : http://88.191.89.70:8006 about user login
> 10:57:12 - [REGION DB]: Reconnecting database
> 10:57:12 - System.FormatException: Input string was not in the correct
> format
>  at System.Int16.Parse (System.String s) [0x00014] in
> /root/MONO/MONO23/mcs/class/corlib/System/Int16.cs:212
>  at System.Convert.ToInt16 (System.String value) [0x00008] in
> /root/MONO/MONO23/mcs/class/corlib/System/Convert.cs:1102
>  at OpenSim.Data.MySQL.MySQLManager.readAgentRow (IDataReader reader)
> [0x000a5] in /OPENSIM/opensim.7873/OpenSim/Data/MySQL/MySQLManager.cs:503
>  at OpenSim.Data.MySQL.MySQLUserData.GetAgentByUUID (UUID uuid) [0x0004d]
> in /OPENSIM/opensim.7873/OpenSim/Data/MySQL/MySQLUserData.cs:606
>
> GridServer console :
>
> NONE
>
> AssetServer console :
>
> Asset# :
> 10:57:17 - [ASSETS DB]: MySql failure fetching asset
> dc4b9f0b-d008-45c6-96a4-01dd947ac621
> System.InvalidCastException: Cannot cast from source type to destination
> type.
>  at OpenSim.Data.MySQL.MySQLAssetData.FetchAsset (UUID assetID) [0x000c1]
> in /OPENSIM/opensim.7873/OpenSim/Data/MySQL/MySQLAssetData.cs:147
> Reconnecting
> 10:57:17 - [REGION DB]: Reconnecting database
> 10:57:17 - [REST]: GET:/asset found dc4b9f0b-d008-45c6-96a4-01dd947ac621
> with name Cloud, size 32864 bytes
> 10:57:17 - [ASSETS DB]: MySql failure fetching asset
> 8e961e12-a475-b112-bf6c-0de487e54156
> System.InvalidCastException: Cannot cast from source type to destination
> type.
>  at OpenSim.Data.MySQL.MySQLAssetData.FetchAsset (UUID assetID) [0x000c1]
> in /OPENSIM/opensim.7873/OpenSim/Data/MySQL/MySQLAssetData.cs:147
> Reconnecting
> 10:57:17 - [REGION DB]: Reconnecting database
> 10:57:17 - [REST]: GET:/asset found 8e961e12-a475-b112-bf6c-0de487e54156
> with name blank, size 262912 bytes
> 10:57:21 - [ASSETS DB]: MySql failure fetching asset
> 00000000-0000-2222-3333-100000001007
> System.InvalidCastException: Cannot cast from source type to destination
> type.
>  at OpenSim.Data.MySQL.MySQLAssetData.FetchAsset (UUID assetID) [0x000c1]
> in /OPENSIM/opensim.7873/OpenSim/Data/MySQL/MySQLAssetData.cs:147
> Reconnecting
> 10:57:21 - [REGION DB]: Reconnecting database
> 10:57:21 - [REST]: GET:/asset found 00000000-0000-2222-3333-100000001007
> with name clear, size 856 bytes
>
>
> InventoryServer console :
>
> NONE
>
> MessagingServer console :
>
> Messaging# :
> 10:56:38 - [SERVER]: Registered with http://88.191.89.70:8002/
> 10:57:04 - [LOGON]: User Ursula Matova logged into region 1099511628032000
> as root agent, building indexes for user
> 10:57:12 - [MYSQL]: Got exception on trying to find friends regions:
> System.InvalidCastException: Cannot cast from source type to destination
> type.
>  at OpenSim.Data.MySQL.MySQLUserData.GetFriendRegionInfos
> (System.Collections.Generic.List`1 uuids) [0x00079] in
> /OPENSIM/opensim.7873/OpenSim/Data/MySQL/MySQLUserData.cs:386
> 10:57:12 - [REGION DB]: Reconnecting database
>  at OpenSim.Data.MySQL.MySQLUserData.GetFriendRegionInfos
> (System.Collections.Generic.List`1 uuids) [0x00079]: in
> /OPENSIM/opensim.7873/OpenSim/Data/MySQL/MySQLUserData.cs:386
> 10:57:12 - [FRIEND]: Got 0 region entries back.
>
> RegionServer console :
>
> 10:57:12 - [PRESENCE]: Failed to notify message server of agent location
> for 3ca50cc4-6137-4a89-906e-cba40f514184
>
> 3c / Region Crossing :
>
> UserServer console :
>
> User# :
> 11:01:14 - [REGION DB]: Reconnecting database
> 11:01:14 - System.FormatException: Input string was not in the correct
> format
>  at System.Int16.Parse (System.String s) [0x00014] in
> /root/MONO/MONO23/mcs/class/corlib/System/Int16.cs:212
>  at System.Convert.ToInt16 (System.String value) [0x00008] in
> /root/MONO/MONO23/mcs/class/corlib/System/Convert.cs:1102
>  at OpenSim.Data.MySQL.MySQLManager.readAgentRow (IDataReader reader)
> [0x000a5] in /OPENSIM/opensim.7873/OpenSim/Data/MySQL/MySQLManager.cs:503
>  at OpenSim.Data.MySQL.MySQLUserData.GetAgentByUUID (UUID uuid) [0x0004d]
> in /OPENSIM/opensim.7873/OpenSim/Data/MySQL/MySQLUserData.cs:606
>
> GridServer console :
>
> NONE
>
> AssetServer console :
>
> Asset# :
> 11:00:57 - [REST]: GET:/asset failed to find
> 00000000-0000-0000-0000-000000000000
>
> InventoryServer console :
>
> NONE
>
> MessagingServer console :
>
> NONE
>
> RegionServer console :
>
> 11:01:14 - [PRESENCE]: Failed to notify message server of agent location
> for 3ca50cc4-6137-4a89-906e-cba40f514184
> 11:01:14 - [APPEARANCE]: Problem fetching appearance for avatar Ursula
> Matova, System.FormatException: Unknown char: .
>  at System.Double.Parse (System.String s, NumberStyles style,
> IFormatProvider provider) [0x00016] in
> /root/MONO/MONO23/mcs/class/corlib/System/Double.cs:212
>  at System.Double.Parse (System.String s) [0x00000] in
> /root/MONO/MONO23/mcs/class/corlib/System/Double.cs:180
>  at System.Convert.ToDouble (System.String value) [0x00010] in
> /root/MONO/MONO23/mcs/class/corlib/System/Convert.cs:971
>  at OpenSim.Framework.AvatarAppearance..ctor (System.Collections.Hashtable
> h) [0x00092] in
> /OPENSIM/opensim.7873/OpenSim/Framework/AvatarAppearance.cs:391
>  at
> OpenSim.Region.Communications.OGS1.OGS1UserServices.ConvertXMLRPCDataToAvatarAppearance
> (System.Collections.Hashtable data) [0x00059] in
> /OPENSIM/opensim.7873/OpenSim/Region/Communications/OGS1/OGS1UserServices.cs:177
>  at OpenSim.Region.Communications.OGS1.OGS1UserServices.GetUserAppearance
> (UUID user) [0x0005f] in
> /OPENSIM/opensim.7873/OpenSim/Region/Communications/OGS1/OGS1UserServices.cs:769
>  at
> OpenSim.Region.Environment.Modules.Avatar.AvatarFactory.AvatarFactoryModule.TryGetAvatarAppearance
> (UUID avatarId, OpenSim.Framework.AvatarAppearance& appearance) [0x0001d] in
> /OPENSIM/opensim.7873/OpenSim/Region/Environment/Modules/Avatar/AvatarFactory/AvatarFactoryModule.cs:56
>  at OpenSim.Region.Environment.Scenes.Scene.GetAvatarAppearance (IClientAPI
> client, OpenSim.Framework.AvatarAppearance& appearance) [0x00012] in
> /OPENSIM/opensim.7873/OpenSim/Region/Environment/Scenes/Scene.cs:2499
> 11:01:14 - [APPEARANCE]: Appearance not found, returning default
>
> 3c / Avatar Logoff :
>
> UserServer console :
>
> User# :
> 11:03:27 - [MSGCONNECTOR]: Sending logoff notice to registered message
> servers
> 11:03:27 - [REGION DB]: Reconnecting database
> 11:03:27 - System.FormatException: Input string was not in the correct
> format
>  at System.Int16.Parse (System.String s) [0x00014] in
> /root/MONO/MONO23/mcs/class/corlib/System/Int16.cs:212
>  at System.Convert.ToInt16 (System.String value) [0x00008] in
> /root/MONO/MONO23/mcs/class/corlib/System/Convert.cs:1102
>  at OpenSim.Data.MySQL.MySQLManager.readAgentRow (IDataReader reader)
> [0x000a5] in /OPENSIM/opensim.7873/OpenSim/Data/MySQL/MySQLManager.cs:503
>  at OpenSim.Data.MySQL.MySQLUserData.GetAgentByUUID (UUID uuid) [0x0004d]
> in /OPENSIM/opensim.7873/OpenSim/Data/MySQL/MySQLUserData.cs:606
> 11:03:27 - [LOGOUT]: Ursula Matova from
> 1100611139659776(6.791572,191.0966,35.91899)
> 11:03:27 - [LOGOUT]: didn't save logout position:
> 3ca50cc4-6137-4a89-906e-cba40f514184
> 11:03:27 - [LOGOUT]: Notified : http://88.191.89.70:8006 about user logout
> 11:03:31 - [REGION DB]: Reconnecting database
> 11:03:31 - System.FormatException: Input string was not in the correct
> format
>  at System.Int16.Parse (System.String s) [0x00014] in
> /root/MONO/MONO23/mcs/class/corlib/System/Int16.cs:212
>  at System.Convert.ToInt16 (System.String value) [0x00008] in
> /root/MONO/MONO23/mcs/class/corlib/System/Convert.cs:1102
>  at OpenSim.Data.MySQL.MySQLManager.readAgentRow (IDataReader reader)
> [0x000a5] in /OPENSIM/opensim.7873/OpenSim/Data/MySQL/MySQLManager.cs:503
>  at OpenSim.Data.MySQL.MySQLUserData.GetAgentByUUID (UUID uuid) [0x0004d]
> in /OPENSIM/opensim.7873/OpenSim/Data/MySQL/MySQLUserData.cs:606
>
> GridServer console :
>
> NONE
>
> AssetServer console :
>
> NONE
>
> InventoryServer console :
>
> NONE
>
> MessagingServer console :
>
> Messaging# :
> 11:03:27 - [USERLOGOFF]: User logged off called
> 11:03:27 - [LOGOFF]: Processing Logoff
> 11:03:31 - [MYSQL]: Got exception on trying to find friends regions:
> System.InvalidCastException: Cannot cast from source type to destination
> type.
>  at OpenSim.Data.MySQL.MySQLUserData.GetFriendRegionInfos
> (System.Collections.Generic.List`1 uuids) [0x00079] in
> /OPENSIM/opensim.7873/OpenSim/Data/MySQL/MySQLUserData.cs:386
> 11:03:31 - [REGION DB]: Reconnecting database
>  at OpenSim.Data.MySQL.MySQLUserData.GetFriendRegionInfos
> (System.Collections.Generic.List`1 uuids) [0x00079]: in
> /OPENSIM/opensim.7873/OpenSim/Data/MySQL/MySQLUserData.cs:386
> 11:03:31 - [FRIEND]: Got 0 region entries back.
>
> RegionServer console :
>
> 11:03:27 - [USER CACHE]: Tried to remove the profile of user
> 3ca50cc4-6137-4a89-906e-cba40f514184, but this was not in the scene
> .../...
> 11:03:31 - [PRESENCE]: Got OnLogout from Ursula Matova
> 11:03:31 - [PRESENCE]: Failed to notify message server of agent leaving for
> 3ca50cc4-6137-4a89-906e-cba40f514184
> 11:03:31 - [PACKETQUEUE]: Close called
> 11:03:31 - [PACKETQUEUE]: Wiping Packet Queues Clean
>
> 4/
>
> All of this seems to belong to MySQL and/or mono ...
> The grid is still playable, but when I logout, my "position" is not saved
> in MySQL, only my "Home" position.
>
> Is there somebody experiencing such problems ?
> Should I log a Mantis with all of that ?
>
> Regards,
> Ursula.
>
> _______________________________________________
> Opensim-dev mailing list
> Opensim-dev at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-dev
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-dev/attachments/20081226/2369f892/attachment-0001.html>