Hi,
Some days ago, I got this repetitive problem and I've not found the solution for now.
I hope someone will be able to help me or redirect me in the right way.
I start the server, all is ok for some few hours.
After some minutes/hours, I got this exemples of repetitives errors in the DB syserr/syslog like 5-10 times per seconds:
I tryed to open all the syserr / syslog file I have on my differents cores but I've not found any error that can cause that until know.
If you have an idea from where this synchronisation error can come from..
Thank you in advance for your help.
Some days ago, I got this repetitive problem and I've not found the solution for now.
I hope someone will be able to help me or redirect me in the right way.
I start the server, all is ok for some few hours.
After some minutes/hours, I got this exemples of repetitives errors in the DB syserr/syslog like 5-10 times per seconds:
PHP Code:
SYSERR: Sep 4 11:02:43 :: ChildLoop: AsyncSQL: query failed: Commands out of sync; you can't run this command now (query: DELETE FROM affect WHERE dwPID=64686 AND bType=210 AND bApplyOn=0 errno: 2014)
SYSERR: Sep 4 11:02:44 :: ChildLoop: AsyncSQL: query failed: Commands out of sync; you can't run this command now (query: DELETE FROM item WHERE id=160183640 errno: 2014)
PHP Code:
SYSERR: Sep 3 09:46:56 :: ChildLoop: AsyncSQL: query failed: Commands out of sync; you can't run this command now (query: DELETE FROM item WHERE id=240184341 errno: 2014)
SYSERR: Sep 3 09:46:57 :: ChildLoop: AsyncSQL: query failed: Commands out of sync; you can't run this command now (query: REPLACE INTO affect (dwPID, bType, bApplyOn, lApplyValue, dwFlag, lDuration, lSPCost) VALUES(64564, 4, 95, 209, 16, 60, 0) errno: 2014)
SYSERR: Sep 3 09:46:58 :: ChildLoop: AsyncSQL: query failed: Commands out of sync; you can't run this command now (query: UPDATE monarch set money=3190265 where empire=1 errno: 2014)
PHP Code:
SYSERR: Sep 6 18:52:36 :: ChildLoop: AsyncSQL: query failed: Commands out of sync; you can't run this command now (query: DELETE FROM item WHERE id=60662832 errno: 2014)
SYSERR: Sep 6 18:52:38 :: ChildLoop: AsyncSQL: query failed: Commands out of sync; you can't run this command now (query: DELETE FROM affect WHERE dwPID=60516 AND bType=63 AND bApplyOn=100 errno: 2014)
SYSERR: Sep 6 18:52:43 :: ChildLoop: AsyncSQL: query failed: Commands out of sync; you can't run this command now (query: REPLACE INTO affect (dwPID, bType, bApplyOn, lApplyValue, dwFlag, lDuration, lSPCost) VALUES(59019, 94, 99, 45, 23, 310, 0) errno: 2014)
If you have an idea from where this synchronisation error can come from..
Thank you in advance for your help.