While running the following pt-online-schema-change to replace a table with a newer version of itself we encounter a number of deadlocks that severely impacted query latency, in this case I believe inserts into the source table slowed drastically setting off all our alarms. I am trying to piece tog…

Hello DBA_Donny, That particular error message of deadlock is not technically a deadlock, but something that InnoDB treats as one so it can kill it internally. You can see the message at the top telling you the search depth in the waits-for graph is too deep. Basically, you’ve got too many locks try…

pt-online-schema-change Deadlock found when trying to get lock (lock mode AUTO-INC wait)

MySQL & MariaDB Other MySQL® Questions

DBA_Donny August 12, 2020, 7:37pm 3

Thank you for the explanation MatthewB. This clarifies things. Correct no foreign keys referencing at the database level.

Topic		Replies	Views
pt-online-schema-change causing transactions wait for AUTO-INC lock and crash server Percona Toolkit	0	857	August 4, 2016
Deadlock Encountered when using pt-online-schema-change Percona Toolkit	1	1347	February 2, 2016
Deadlocks when running pt-online-schema-change on XtraDB cluster Percona XtraDB Cluster 5.x	3	1566	February 27, 2014
pt-online-schema-change locking replication - troubleshoot Percona Toolkit	0	942	July 2, 2019
pt-online-schema-change issues around securing a table lock when creating or dropping triggers Other MySQL® Questions	1	2000	August 26, 2020

pt-online-schema-change Deadlock found when trying to get lock (lock mode AUTO-INC wait)

Related topics