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

Ursula MATOVA ursula.matova at klintcentral.net
Fri Dec 26 10:10:15 UTC 2008 

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-dev/attachments/20081226/211c8c3f/attachment-0001.html>

More information about the Opensim-dev mailing list