Getting mysql error on console after some hours
Cam_C
投稿数: 20

Hi, I first thought this might be a problem associated with the use of php5.3 but I have now changed to php5.2 and still getting the same error.
Overnight the server is running with no activity, in the morning the MoneyServer console has gone red starting with these lines............
MySql.Data.MySqlClient.MySqlException: Fatal error encountered during command execution. ---> MySql.Data.MySqlClient.MySqlException: Fatal error encountered attempting to read the resultset. ---> MySql.Data.MySqlClient.MySqlException: Reading from the stream has failed. ---> System.IO.EndOfStreamException: Failed to read past end of stream.
....etc... for about 12 lines then ends with .....
at OpenSim.Grid.MoneyServer.MoneyDBService.TryAddUserInfo (OpenSim.Data.MySQL.MySQLMoneyDataWrapper.UserInfo user) [0x00000] in <filename unknown>:0
01:32:45 - [MONEY RPC]: handleClientLogin: Unable to refresh information for user "Lily Blossom" in DB
................
This error only seems to happen after extended periods of inactivity, I have already changed "global wait-timeout" and set it for about a week so thats not the problem.
Also buy land is still not working and I thought it would start working when I downgraded to php5.2 there is no error in log except on startup of apache (mcrypt.so not found, I dont know if thats related, have just spent hours researching problems loading mcrypt on newer linux with older pinned php versions, some say to remove references of mcrypt from .ini)
Any help is always appreciated
Thank you
Cam
Overnight the server is running with no activity, in the morning the MoneyServer console has gone red starting with these lines............
MySql.Data.MySqlClient.MySqlException: Fatal error encountered during command execution. ---> MySql.Data.MySqlClient.MySqlException: Fatal error encountered attempting to read the resultset. ---> MySql.Data.MySqlClient.MySqlException: Reading from the stream has failed. ---> System.IO.EndOfStreamException: Failed to read past end of stream.
....etc... for about 12 lines then ends with .....
at OpenSim.Grid.MoneyServer.MoneyDBService.TryAddUserInfo (OpenSim.Data.MySQL.MySQLMoneyDataWrapper.UserInfo user) [0x00000] in <filename unknown>:0
01:32:45 - [MONEY RPC]: handleClientLogin: Unable to refresh information for user "Lily Blossom" in DB
................
This error only seems to happen after extended periods of inactivity, I have already changed "global wait-timeout" and set it for about a week so thats not the problem.
Also buy land is still not working and I thought it would start working when I downgraded to php5.2 there is no error in log except on startup of apache (mcrypt.so not found, I dont know if thats related, have just spent hours researching problems loading mcrypt on newer linux with older pinned php versions, some say to remove references of mcrypt from .ini)
Any help is always appreciated
Thank you
Cam
投票数:289
平均点:3.81
投稿ツリー
-
Getting mysql error on console after some hours (Cam_C, 2012-4-21 10:17)
-
Re: Getting mysql error on console after some hours (Cam_C, 2012-4-22 12:02)
-
Re: Getting mysql error on console after some hours (iseki, 2012-4-22 18:10)
-
Re: Getting mysql error on console after some hours (Cam_C, 2012-4-22 20:47)
-
-
-
Re: Getting mysql error on console after some hours (SilverDay, 2012-6-19 3:46)
-
Re: Getting mysql error on console after some hours (iseki, 2012-6-19 11:22)
-
-
Re: Getting mysql error on console after some hours (SilverDay, 2012-6-19 16:41)
-
Re: Getting mysql error on console after some hours (SilverDay, 2012-6-19 16:42)
-
Re: Getting mysql error on console after some hours (SilverDay, 2012-6-19 16:44)
-
Re: Getting mysql error on console after some hours (iseki, 2012-6-19 23:44)
-
Re: Re: Getting mysql error on console after some hours (SilverDay, 2012-6-19 23:52)
-
-
-