Questions tagged [deadlock]
A situation caused by two or more processes being unable to proceed (and thus release their locks) because they are blocked by locks on resources held by the other process.
618 questions
0 votes
0 answers
35 views
Table is freeze, not able to do any change in Innodb table in MySQL
I am using MySQL 8.0. I have a sales table with only 30,000 rows. I had a problem where the table was frozen and I couldn't alter the values in any of the columns. I attempted to duplicate the data ...
- 1
2 votes
2 answers
91 views
MariaDB deadlock with transactional outbox pattern
I have a deadlock in 10.6.21-MariaDB-ubu2004. Here's my schema: CREATE TABLE INT_CHANNEL_MESSAGE ( MESSAGE_ID CHAR(36) NOT NULL, GROUP_KEY CHAR(36) NOT NULL, ...
1 vote
0 answers
88 views
How can I mitigate or minimise this MariaDB deadlock?
I'm struggling with a deadlock in my booking web application when there are many concurrent users. Here are the relevant tables: mariadb> explain bookings; +-----------------------+--------------+--...
- 161
2 votes
1 answer
521 views
Does PostgreSQL have lock promotion or escalation?
We having this strange behaviour with ExclusiveLock in one of our database running PostgreSQL 13. I am not able to dig what leads to this lock as lock info is from a monitoring tool. From what I see ...
- 700
0 votes
1 answer
91 views
Completely avoid deadlocks with concurrent transactions inserting identical data in MySQL
I have two concurrent transactions inserting identical but differently ordered data into a table with unique keys, thus causing frequent deadlocks. How can I avoid these deadlocks in this setup? I'm ...
- 1
3 votes
1 answer
451 views
sp_blitzlock returns blank data in SQL Managed instance
I have a SQL Managed Instance in Azure with some blocking/deadlocking going on. This DB was on-premise and had all the scripts installed, so I uninstalled them and then installed the Azure specific ...
0 votes
0 answers
23 views
Understanding MySQL's Deadlock for un-related tables
I see the following Deadlock in my show engine innodb status's output: ------------------------ LATEST DETECTED DEADLOCK ------------------------ 2024-08-22 09:35:46 0x7f70f2d2d700 *** (1) TRANSACTION:...
- 21
3 votes
1 answer
324 views
Locking for update inside CTEs
If I make a query using CTEs that looks like that: WITH cte_a AS ( SELECT a.id, a.something FROM a WHERE a.something IS NOT NULL ), -- [...] some other CTEs cte_d AS ( SELECT ...
- 167