Mantis Bug Tracker

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0007543opensim[GRID] Robust Serverpublic2015-04-25 18:102017-06-19 19:07
ReporterAlphaManx 
Assigned To 
PriorityimmediateSeveritymajorReproducibilityalways
StatusnewResolutionopen 
PlatformOSOS Version
Product Versionmaster (dev code) 
Target VersionFixed in Version 
Summary0007543: Error Generating Login Response
DescriptionEvery time a user that tries to login that have a inventory over 1000, I get this mysql timeout error.

 Exception processing login for Alpha Manx: MySql.Data.MySqlClient.MySqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.TimeoutException: Timeout in IO operation
  at MySql.Data.MySqlClient.TimedStream.StopTimer () [0x00000] in <filename unknown>:0
  at MySql.Data.MySqlClient.TimedStream.Read (System.Byte[] buffer, Int32 offset, Int32 count) [0x00000] in <filename unknown>:0
  --- End of inner exception stack trace ---
  at MySql.Data.MySqlClient.MySqlConnection.HandleTimeoutOrThreadAbort (System.Exception ex) [0x00000] in <filename unknown>:0
  at (wrapper remoting-invoke-with-check) MySql.Data.MySqlClient.MySqlConnection:HandleTimeoutOrThreadAbort (System.Exception)
  at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader (CommandBehavior behavior) [0x00000] in <filename unknown>:0
  at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader () [0x00000] in <filename unknown>:0
  at (wrapper remoting-invoke-with-check) MySql.Data.MySqlClient.MySqlCommand:ExecuteReader ()
  at OpenSim.Data.MySQL.MySQLGenericTableHandler`1[OpenSim.Data.XInventoryItem].DoQuery (MySql.Data.MySqlClient.MySqlCommand cmd) [0x00000] in <filename unknown>:0
  at OpenSim.Data.MySQL.MySqlItemHandler.GetActiveGestures (UUID principalID) [0x00000] in <filename unknown>:0
  at OpenSim.Data.MySQL.MySQLXInventoryData.GetActiveGestures (UUID principalID) [0x00000] in <filename unknown>:0
  at OpenSim.Services.InventoryService.XInventoryService.GetActiveGestures (UUID principalID) [0x00000] in <filename unknown>:0
  at OpenSim.Services.LLLoginService.LLLoginService.Login (System.String firstName, System.String lastName, System.String passwd, System.String startLocation, UUID scopeID, System.String clientVersion, System.String channel, System.String mac, System.String id0, System.Net.IPEndPoint clientIP) [0x00000] in <filename unknown>:0 at MySql.Data.MySqlClient.MySqlConnection.HandleTimeoutOrThreadAbort (System.Exception ex) [0x00000] in <filename unknown>:0
  at (wrapper remoting-invoke-with-check) MySql.Data.MySqlClient.MySqlConnection:HandleTimeoutOrThreadAbort (System.Exception)
  at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader (CommandBehavior behavior) [0x00000] in <filename unknown>:0
  at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader () [0x00000] in <filename unknown>:0
  at (wrapper remoting-invoke-with-check) MySql.Data.MySqlClient.MySqlCommand:ExecuteReader ()
  at OpenSim.Data.MySQL.MySQLGenericTableHandler`1[OpenSim.Data.XInventoryItem].DoQuery (MySql.Data.MySqlClient.MySqlCommand cmd) [0x00000] in <filename unknown>:0
  at OpenSim.Data.MySQL.MySqlItemHandler.GetActiveGestures (UUID principalID) [0x00000] in <filename unknown>:0
  at OpenSim.Data.MySQL.MySQLXInventoryData.GetActiveGestures (UUID principalID) [0x00000] in <filename unknown>:0
  at OpenSim.Services.InventoryService.XInventoryService.GetActiveGestures (UUID principalID) [0x00000] in <filename unknown>:0
  at OpenSim.Services.LLLoginService.LLLoginService.Login (System.String firstName, System.String lastName, System.String passwd, System.String startLocation, UUID scopeID, System.String clientVersion, System.String channel, System.String mac, System.String id0, System.Net.IPEndPoint clientIP) [0x00000] in <filename unknown>:0
TagsNo tags attached.
Git Revision or version number
Run Mode Grid (Multiple Regions per Sim)
Physics EngineBulletSim
EnvironmentMono / Linux32
Mono VersionOther
Viewer
Attached Files

- Relationships

-  Notes
(0028087)
Garmin Kawaguichi (reporter)
2015-04-26 11:58

Please look at your MySql configuration file (my.ini) and verify the value of max_allowed_packet under [mysqld]; it must be > = 32M (don't sure it's the solution, but it could help!)
MML
(0028088)
AlphaManx (reporter)
2015-04-26 14:18

My max_allowed_packet is set to 64M
(0032032)
miltont1 (reporter)
2017-06-17 14:30

Hi everyone, I have this same problem today and I added max_allowed_packet = 128M anyway it does not solve, someone has an idea of what this is, could help me Please, thank you for your time.
Milton
See date.

16:41:12 - [LLOGIN SERVICE]: Exception processing login for Jonny Carter: MySql.Data.MySqlClient.MySqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.TimeoutException: Timeout in IO operation
  at MySql.Data.MySqlClient.TimedStream.StopTimer () [0x00000] in <filename unknown>:0
  at MySql.Data.MySqlClient.TimedStream.Read (System.Byte[] buffer, Int32 offset, Int32 count) [0x00000] in <filename unknown>:0
  --- End of inner exception stack trace ---
  at MySql.Data.MySqlClient.MySqlConnection.HandleTimeoutOrThreadAbort (System.Exception ex) [0x00000] in <filename unknown>:0
  at (wrapper remoting-invoke-with-check) MySql.Data.MySqlClient.MySqlConnection:HandleTimeoutOrThreadAbort (System.Exception)
  at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader (CommandBehavior behavior) [0x00000] in <filename unknown>:0
  at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader () [0x00000] in <filename unknown>:0
  at (wrapper remoting-invoke-with-check) MySql.Data.MySqlClient.MySqlCommand:ExecuteReader ()
  at OpenSim.Data.MySQL.MySQLGenericTableHandler`1[OpenSim.Data.XInventoryItem].DoQuery (MySql.Data.MySqlClient.MySqlCommand cmd) [0x00000] in <filename unknown>:0
  at OpenSim.Data.MySQL.MySqlItemHandler.GetActiveGestures (UUID principalID) [0x00000] in <filename unknown>:0
  at OpenSim.Data.MySQL.MySQLXInventoryData.GetActiveGestures (UUID principalID) [0x00000] in <filename unknown>:0
  at OpenSim.Services.InventoryService.XInventoryService.GetActiveGestures (UUID principalID) [0x00000] in <filename unknown>:0
  at OpenSim.Services.LLLoginService.LLLoginService.Login (System.String firstName, System.String lastName, System.String passwd, System.String startLocation, UUID scopeID, System.String clientVersion, System.String channel, System.String mac, System.String id0, System.Net.IPEndPoint clientIP, Boolean LibOMVclient) [0x00000] in <filename unknown>:0 at MySql.Data.MySqlClient.MySqlConnection.HandleTimeoutOrThreadAbort (System.Exception ex) [0x00000] in <filename unknown>:0
  at (wrapper remoting-invoke-with-check) MySql.Data.MySqlClient.MySqlConnection:HandleTimeoutOrThreadAbort (System.Exception)
  at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader (CommandBehavior behavior) [0x00000] in <filename unknown>:0
  at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader () [0x00000] in <filename unknown>:0
  at (wrapper remoting-invoke-with-check) MySql.Data.MySqlClient.MySqlCommand:ExecuteReader ()
  at OpenSim.Data.MySQL.MySQLGenericTableHandler`1[OpenSim.Data.XInventoryItem].DoQuery (MySql.Data.MySqlClient.MySqlCommand cmd) [0x00000] in <filename unknown>:0
  at OpenSim.Data.MySQL.MySqlItemHandler.GetActiveGestures (UUID principalID) [0x00000] in <filename unknown>:0
  at OpenSim.Data.MySQL.MySQLXInventoryData.GetActiveGestures (UUID principalID) [0x00000] in <filename unknown>:0
  at OpenSim.Services.InventoryService.XInventoryService.GetActiveGestures (UUID principalID) [0x00000] in <filename unknown>:0
  at OpenSim.Services.LLLoginService.LLLoginService.Login (System.String firstName, System.String lastName, System.String passwd, System.String startLocation, UUID scopeID, System.String clientVersion, System.String channel, System.String mac, System.String id0, System.Net.IPEndPoint clientIP, Boolean LibOMVclient) [0x00000] in <filename unknown>:0
(0032033)
watcher64 (reporter)
2017-06-17 15:19

I have 100k in my inventory and do not have this issue .. Make sure your max connections are high enough as well as your max packet, I keep mine set to 1024M.

You can also add , ;default command timeout=300, to your connection string ..
(0032034)
miltont1 (reporter)
2017-06-17 15:47

Command timeout = 300 in my GridCommon.ini?
I do not have great system dreams, please if you can guide me where I put command timeout = 300
I can imagine that it is in my.cnf but I did not find anything in this place that helped me.
Thanks for your reply, I'm going to change 1024M paw but my max_allowed_packet = 16384M is with this value, too high, would it?
Thank's for your time.
Milton
(0032035)
watcher64 (reporter)
2017-06-17 15:50

with it too high it could eat too much ram and degrade performance ..


You just add the command timeout setting to your connection string like so.

     ConnectionString = "Data Source=localhost;Database=opensim;User ID=username;Password=password;default command timeout=300;Old Guids=true;"

With your own database settings of course .
(0032036)
watcher64 (reporter)
2017-06-17 15:54

It could also be other networking issues slowing down traffic, or a firewall not forwarding packets fast enough .. There are a lot of things that could be causing mysql timeouts that are not related to opensim at all .
(0032037)
miltont1 (reporter)
2017-06-17 16:31

OK,
Thank you very much.
I'll do this already, then put the one that has been solved, or if it is not that and I find fault I also put here to help other comrades.
I'm going to check Firewall too, this is a good idea.
(0032039)
miltont1 (reporter)
2017-06-19 19:07

Thank you friend watcher64 your opinion was accurate, now I have no more flaws.
I used the string as you reported with 300 seconds, and with that everything works fine now
See you...

- Issue History
Date Modified Username Field Change
2015-04-25 18:10 AlphaManx New Issue
2015-04-26 11:58 Garmin Kawaguichi Note Added: 0028087
2015-04-26 14:18 AlphaManx Note Added: 0028088
2017-06-17 14:30 miltont1 Note Added: 0032032
2017-06-17 15:19 watcher64 Note Added: 0032033
2017-06-17 15:47 miltont1 Note Added: 0032034
2017-06-17 15:50 watcher64 Note Added: 0032035
2017-06-17 15:54 watcher64 Note Added: 0032036
2017-06-17 16:31 miltont1 Note Added: 0032037
2017-06-19 19:07 miltont1 Note Added: 0032039


Copyright © 2000 - 2012 MantisBT Group
Powered by Mantis Bugtracker