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
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 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 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
2015-02-12 16:32:44 10298 [Warning] Slave SQL: Could not execute Update_rows event on table mygame.
2015-02-12 16:50:01 10298 [Warning] Slave SQL: Could not execute Update_rows event on table mygame.