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

Fri Dec 26 12:43:18 UTC 2008

I've been fearlessly tilting at the windmill that is mono 2.3 for some time
with little issue. I certainly have not seen anything so fearsome looking as
what you describe Ursula :D

However Sacha does bring up a solid point: Mono SVN is a relative unknown,
and if you are chasing trunk over there, you could be in for some nasty
surprises.

My mono 2.3 is literally months old, and somewhat stable. Mileage will
certainly vary for others :)

Cheers
James

On Fri, Dec 26, 2008 at 5:10 AM, Lc <lcc1967 at gmail.com> wrote:

> Mono 2.3 is in development. Mono issue one new release every day... Stick
> on the "stable" mono release unless you really want fighting the WindMill ;)
>
> SM
>
>
> On Fri, Dec 26, 2008 at 12:04 PM, Ursula MATOVA <
> ursula.matova at klintcentral.net> wrote:
>
>> 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
>>
>>
>>
>> _______________________________________________
>> 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
>
>

-- 
===================================
"They give birth astride of a grave, the light gleams an instant, then it's
night once more."
- 'Waiting for Godot', by Samuel Beckett
http://osgrid.org
http://del.icio.us/SPQR
http://twitter.com/jstallings2
http://www.linkedin.com/pub/5/770/a49
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-dev/attachments/20081226/713efb72/attachment-0001.html>