MySQL Triggers Deadlock Wait Exceeded Timeout When Server Time Syncs
Posted by:
Paul Wade
Date: July 16, 2015 03:05PM
Hi,
We have a recurring issue with an application which is triggered when the server time (Windows Server 2008 R2) automatically updates. We’re running MySQL 5.6 in a replicated environment. We have 10 dedicated clients which automatically poll the database for records to process every 10 seconds at staggered intervals. Within the client we already handle normal deadlock issues, however, we have had several instances where 8-10 of the clients will all generate a “Lock wait timeout exceeded; try restarting transaction” SQL exception all at the same time. After researching several of these events we discovered via Event Viewer that this events occurred at the precise time that the Window server performed an automatic time update (synchronization with external time source). These events have occured different times of the day and there are no schedule tasks or anything of that nature running when the events occur that might be explicitly locking the tables.
It appears to me that something else is locking the database when a server time sync event occurs and holding it. I can’t figure out how or why this is happening so any advice would be greatly appreciated.
Thanks,
Paul
Subject
Written By
Posted
MySQL Triggers Deadlock Wait Exceeded Timeout When Server Time Syncs
July 16, 2015 03:05PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.