Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.6
Description
When a large number of deadlocks are generated the deadlock messages are incomplete without query. Although innodb_print_all_deadlocks is set to ON
2024-06-29 12:37:58 1720967 [Note] InnoDB: *** WAITING FOR THIS LOCK TO BE GRANTED: |
2024-06-29 12:37:58 1720967 [Note] InnoDB: *** CONFLICTING WITH: |
2024-06-29 12:37:58 1720967 [Note] InnoDB: |
2024-06-29 12:37:58 1720967 [Note] InnoDB: *** WAITING FOR THIS LOCK TO BE GRANTED: |
2024-06-29 12:37:58 1720967 [Note] InnoDB: *** CONFLICTING WITH: |
2024-06-29 12:37:58 1720967 [Note] InnoDB: *** WE ROLL BACK TRANSACTION (1) |
2024-06-29 12:37:59 1721033 [Note] InnoDB: Transactions deadlock detected, dumping detailed information. |
2024-06-29 12:37:59 1721033 [Note] InnoDB: |
2024-06-29 12:37:59 1721033 [Note] InnoDB: *** WAITING FOR THIS LOCK TO BE GRANTED: |
2024-06-29 12:37:59 1721033 [Note] InnoDB: *** CONFLICTING WITH: |
2024-06-29 12:37:59 1721033 [Note] InnoDB: |
2024-06-29 12:37:59 1721033 [Note] InnoDB: *** WAITING FOR THIS LOCK TO BE GRANTED: |
2024-06-29 12:37:59 1721033 [Note] InnoDB: *** CONFLICTING WITH: |
2024-06-29 12:37:59 1721033 [Note] InnoDB: *** WE ROLL BACK TRANSACTION (2) |
2024-06-29 12:37:59 1719165 [Note] InnoDB: Transactions deadlock detected, dumping detailed information. |
2024-06-29 12:37:59 1719165 [Note] InnoDB: |
2024-06-29 12:37:59 1719165 [Note] InnoDB: *** WAITING FOR THIS LOCK TO BE GRANTED: |
2024-06-29 12:37:59 1719165 [Note] InnoDB: *** CONFLICTING WITH: |
2024-06-29 12:37:59 1719165 [Note] InnoDB: |
2024-06-29 12:37:59 1719165 [Note] InnoDB: *** WAITING FOR THIS LOCK TO BE GRANTED: |
2024-06-29 12:37:59 1719165 [Note] InnoDB: *** CONFLICTING WITH: |
2024-06-29 12:37:59 1719165 [Note] InnoDB: *** WE ROLL BACK TRANSACTION (1) |
2024-06-29 12:37:59 1719247 [Note] InnoDB: Transactions deadlock detected, dumping detailed information. |
2024-06-29 12:37:59 1719247 [Note] InnoDB: |
2024-06-29 12:37:59 1719247 [Note] InnoDB: *** WAITING FOR THIS LOCK TO BE GRANTED: |
2024-06-29 12:37:59 1719247 [Note] InnoDB: *** CONFLICTING WITH: |
2024-06-29 12:37:59 1719247 [Note] InnoDB: |
2024-06-29 12:37:59 1719247 [Note] InnoDB: *** WAITING FOR THIS LOCK TO BE GRANTED: |
2024-06-29 12:37:59 1719247 [Note] InnoDB: *** CONFLICTING WITH: |
2024-06-29 12:37:59 1719247 [Note] InnoDB: *** WE ROLL BACK TRANSACTION (2) |
2024-06-29 12:37:59 1720870 [Note] InnoDB: Transactions deadlock detected, dumping detailed information. |
2024-06-29 12:37:59 1720870 [Note] InnoDB: |
2024-06-29 12:37:59 1720870 [Note] InnoDB: *** WAITING FOR THIS LOCK TO BE GRANTED: |
2024-06-29 12:37:59 1720870 [Note] InnoDB: *** CONFLICTING WITH: |
2024-06-29 12:37:59 1720870 [Note] InnoDB: |
Attachments
Issue Links
- is duplicated by
-
MDEV-32576 InnoDB deadlock output does not always include the full SQL statement
-
- Open
-