MantisBT - opensim |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0007543 | opensim | [GRID] Robust Server | public | 2015-04-25 18:10 | 2017-06-19 19:07 |
|
| Reporter | AlphaManx | |
| Assigned To | | |
| Priority | immediate | Severity | major | Reproducibility | always |
| Status | new | Resolution | open | |
| Platform | | Operating System | | Operating System Version | |
| Product Version | master (dev code) | |
| Target Version | | Fixed in Version | | |
| Git Revision or version number | |
| Run Mode | Grid (Multiple Regions per Sim) |
| Physics Engine | BulletSim |
| Script Engine | |
| Environment | Mono / Linux32 |
| Mono Version | Other |
| Viewer | |
|
| Summary | 0007543: Error Generating Login Response |
| Description | Every 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
|
| Steps To Reproduce | |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | |
| Attached Files | |
|
| 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 | BillBlight | Note Added: 0032033 | |
| 2017-06-17 15:47 | miltont1 | Note Added: 0032034 | |
| 2017-06-17 15:50 | BillBlight | Note Added: 0032035 | |
| 2017-06-17 15:54 | BillBlight | Note Added: 0032036 | |
| 2017-06-17 16:31 | miltont1 | Note Added: 0032037 | |
| 2017-06-19 19:07 | miltont1 | Note Added: 0032039 | |
|
Notes |
|
|
|
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 |
|
|
|
|
|
My max_allowed_packet is set to 64M |
|
|
|
|
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 |
|
|
|
|
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 .. |
|
|
|
|
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 |
|
|
|
|
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 . |
|
|
|
|
|
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 . |
|
|
|
|
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. |
|
|
|
|
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... |
|