Question : Even with reading the Bart Duncan blog about reading deadlocks I still struggle with this. I have included […]
Tag: deadlock
How to Resolve deadlock on concurrent MERGE on two tables
Question : Recently I have been encountering deadlocks occasionally when I try to insert data concurrently on two tables. Following […]
Understanding INSERT … ON DUPLICATE KEY UPDATE deadlock scenario
Question : I’m trying to understand a scenario where an INSERT … ON DUPLICATE KEY UPDATE statement is causing deadlocks […]
Select query on an index column with gap locking
Question : I am trying to understand in which cases will a select query make a gap locking on an […]
Is this surprising deadlock reasonable or a MariaDB bug?
Question : I recently had to diagnose a deadlock in an application that seemed impossible to me. Even after I […]
Sporadic Gap-lock related Deadlocks under high concurrency in MySQL 5.7
Question : Under high concurrency when running a daily process overnight we see deadlocks occur on a particular table, which […]
MySQL InnoDB locking on combined UPDATE-JOIN statements
Question : on querying statements which contain an UPDATE combined with JOIN, we are getting the following errors: Statements writing […]
mysql replication deadlock slave stopped
Question : I’ve a master and slave and got the slave stopped with the following error log in slave. I […]
Why am I getting a deadlock for a single UPDATE query?
Question : I have two processes which execute code like this in parallel: begin; update foos set unread=false where owner_id=123 […]
How to capture the exact SQL text involved in deadlock (locks) using extended events?
Question : I have setup extended event session with the following event: xml_deadlock_report When I look at the deadlock graph, […]