0007543: Error Generating Login Response

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) BillBlight (developer) 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) BillBlight (developer) 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) BillBlight (developer) 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	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

Relationships