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.