Comment 2 for bug 1421282

Revision history for this message
Thomas Roog (thomas.roog) wrote :

The same queries weren't causing dead lock on MySQL 5.5, we started seeing that after migration to MySQL/Percona 5.6. What has changed?

Even now the same happens, but will fit into time, so replication thread won't be stopped (and then data in table corrupted as partially existing..).

Tailing /var/log/mysql.log... 2015-02-12 16:05:27 10298 [Warning] Slave SQL: Could not execute Update_rows event on table mygame.playeraccount; Deadlock found when trying to get lock; try restarting transaction, Error_code: 1213; handler error HA_ERR_LOCK_DEADLOCK; the event's master log binlog.000012, end_log_pos 187548409, Error_code: 1213
2015-02-12 16:32:44 10298 [Warning] Slave SQL: Could not execute Update_rows event on table mygame.playeraccount; Deadlock found when trying to get lock; try restarting transaction, Error_code: 1213; handler error HA_ERR_LOCK_DEADLOCK; the event's master log binlog.000012, end_log_pos 189937636, Error_code: 1213
2015-02-12 16:50:01 10298 [Warning] Slave SQL: Could not execute Update_rows event on table mygame.playeraccount; Deadlock found when trying to get lock; try restarting transaction, Error_code: 1213; handler error HA_ERR_LOCK_DEADLOCK; the event's master log binlog.000012, end_log_pos 191750248, Error_code: 1213