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

Fri Dec 26 11:04:55 UTC 2008

Well,

Reverting to mono 2.0.1 ==>

NO more error messages on any server consoles ...

Thanks again sasha,

Regards
Ursula.

Le 26 déc. 08 à 11:39, Ursula MATOVA a écrit :

> Well, O know Mono 2.3 is not the official release ...
>
> I'll make the test with mono 2.0.1 as you suggest.
>
> BUT : Everything was ok since I upgrade from SVN.7804 to 7873
> ( Mono 2.3 & all def strings )
>
> Regards,
> Ursula.
>
> Le 26 déc. 08 à 11:16, Lc a écrit :
>
>> 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
>>
>>
>> _______________________________________________
>> Opensim-dev mailing list
>> Opensim-dev at lists.berlios.de
>> https://lists.berlios.de/mailman/listinfo/opensim-dev
>
> _______________________________________________
> 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/66f6d4ed/attachment-0001.html>