Re: MySQL Triggers Deadlock Wait Exceeded Timeout When Server Time Syncs
Posted by:
Rick James
Date: August 01, 2015 05:31PM
(The title is misleading -- it is neither about MySQL TRIGGERs, nor about deadlocks.)
Do you know how much the time is shifted when this happens? Is it longer than innodb_lock_wait_timeout, which defaults to 50 seconds? If so, fix the hardware.
Perhaps the clock is being pushed back, so the wait appears to be negative? Negative number _may_ be read as huge positive numbers, thereby causing the "timeout" erroneously. In this case please file a bug at bugs.mysql.com.
The general log, the slowlog and the binlog each _might_ provide enough evidence of large or negative clock changes, and tie it to the timeouts you are receiving.
Or you could instrument your clients to check the time before and after, then report them on timeouts. If you are using PHP, use microtime(true) to get price times.
Subject
Written By
Posted
Re: MySQL Triggers Deadlock Wait Exceeded Timeout When Server Time Syncs
August 01, 2015 05:31PM
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.