Showing all 301 (Edit, Save, CSV, Feed) |
ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
---|---|---|---|---|---|---|---|---|---|
3659 | 2004-05-05 10:34 | 2004-07-19 13:39 | MySQL Cluster: Cluster (NDB) storage engine | Closed (7393 days) | S1 | mysql-4.1.2-alpha bk | FermiLinux LTS 3.01 | Any | >1 concurrent update causes deadlock |
4810 | 2004-07-29 17:41 | 2004-07-31 22:39 | MySQL Server | Closed (7381 days) | S2 | 3.23 | Any | deadlock with KILL when the victim was in a wait state | |
114 | 2003-03-02 9:30 | 2003-03-03 11:05 | MySQL Server | Closed (7897 days) | S3 | 3.23 and 4.0 | Any | Bug in LOCK TABLE followed by DROP TABLE | |
19416 | 2006-04-28 7:56 | 2006-06-02 17:22 | Connector / J | Closed (6710 days) | S2 | 5.0.0-beta | Any | Potential deadlock in JDBC driver | |
23655 | 2006-10-26 4:55 | 2007-01-24 20:52 | MySQL Server: General | Closed (6474 days) | S2 | 5.1.13 | Any | deadlock in query cache ndb_cache tests with --debug | |
23831 | 2006-11-01 10:25 | 2006-11-27 18:35 | MySQL Server: Row Based Replication ( RBR ) | Closed (6532 days) | S3 | 5.1.13 | Any | deadlock not noticed | |
3565 | 2004-04-26 11:46 | 2004-06-25 14:46 | MySQL Server | Closed (7417 days) | S2 | 4.0 | Any | HANDLER and FLUSH TABLE/TABLES deadlock | |
12588 | 2005-08-15 17:50 | 2005-09-13 15:50 | MySQL Server: InnoDB storage engine | Closed (6972 days) | S3 | Any | deadlock detector - out of stack | ||
12717 | 2005-08-22 9:55 | 2005-09-14 14:53 | MySQL Server: Compiling | Closed (6971 days) | S3 | Any | yassl: Crashes in "integer.cpp" when compiled with icc | ||
19244 | 2006-04-21 4:52 | 2006-04-23 1:18 | MySQL Cluster: Cluster (NDB) storage engine | Closed (6750 days) | S3 | 5.1 | Any | DD: Insert+Delete | |
69127 | 2013-05-02 18:49 | 2013-05-29 23:51 | MySQL Server: InnoDB storage engine | Closed (4157 days) | S2 | 5.5.31 | Any | Any | InnoDB: possible regression in 5.5.31, Bug#16004999 |
69969 | 2013-08-09 5:47 | 2014-03-27 13:43 | MySQL Server: Optimizer | Closed (3903 days) | S2 | 5.5.33 | Any | Any | Failing assertion: prebuilt->trx->conc_state == 1 from subselect |
56715 | 2010-09-10 14:32 | 2011-02-16 23:44 | MySQL Server: Locking | Closed (5078 days) | S3 | 5.5.6-m3 | Any | Any | Concurrent transactions + FLUSH result in sporadical unwarranted deadlock errors |
107574 | 2022-06-15 21:07 | 2022-12-28 16:00 | MySQL Server: Replication | Closed (657 days) | S2 | 5.7.38, 5.7.40 | Any | Any | MTR deadlocks when preserving commit order and changing read_only. |
35538 | 2008-03-24 22:11 | 2009-01-08 10:00 | MySQL Server: Falcon storage engine | Closed (5759 days) | S3 | 6.04 | Any | Any | Falcon three-way deadlock between scavenger, gopher and an insert |
46044 | 2009-07-08 15:38 | 2011-02-16 23:44 | MySQL Server: Locking | Closed (5336 days) | S3 | 5.4 | Any | Any | MDL deadlock on LOCK TABLE + CREATE TABLE HIGH_PRIORITY FOR UPDATE |
46654 | 2009-08-11 15:15 | 2011-02-16 23:44 | MySQL Server: Locking | Closed (5336 days) | S3 | 5.4.4-alpha | Any | Any | False deadlock on concurrent DML/DDL with partitions, inconsistent behavior |
110494 | 2023-03-24 13:04 | 2024-07-02 17:44 | MySQL Server: DML | Closed (516 days) | S2 | 8.0 | Any | Any | Deadlock between FLUSH STATUS, COM_CHANGE_USER and SELECT FROM I_S.PROCESSLIST |
16593 | 2006-01-18 3:14 | 2006-02-23 3:24 | MySQL Server | Closed (6809 days) | S1 | 5.0.17a-cert,5.0.18 | Any (ALL) | Any | Deadlock or crash in stress test for case where triggers starting trigger |
37183 | 2008-06-04 8:15 | 2011-02-16 23:43 | MySQL Server: DML | Closed (5331 days) | S3 | 4.1.22, 5.0.64, 5.1.26, 6.0.6 | Any | Any | insert ignore into .. select ... hangs after deadlock was encountered |
38804 | 2008-08-14 16:27 | 2008-10-17 18:16 | MySQL Server: Locking | Closed (5842 days) | S1 | 5.1-bzr | Any | Any | Query deadlock causes all tables to be inaccessible. |
49001 | 2009-11-23 20:29 | 2011-02-16 23:44 | MySQL Server: InnoDB storage engine | Closed (5194 days) | S3 | 5.0,5.1,5.1 with plugin | Any | Any | SHOW INNODB STATUS deadlock info incorrect when deadlock detection aborts |
51391 | 2010-02-22 15:06 | 2011-02-16 23:44 | MySQL Server: Locking | Closed (5274 days) | S2 | 5.5.3-m3 | Any | Any | Deadlock involving events during rqg_info_schema test |
57474 | 2010-10-15 7:46 | 2014-09-26 13:08 | MySQL Server: Locking | Closed (3675 days) | S3 | 5.5.7-bzr,5.6.2m5 | Any | Any | Deadlock when DDL under LOCK TABLES WRITE, READ + PREPARE. |
73666 | 2014-08-21 9:09 | 2014-08-21 19:12 | MySQL Server: Locking | Verified (3708 days) | S3 | 5.5.37-bzr, 5.6.21-bzr, 5.7.5-bzr | Any | Any | DEADLOCK WHEN DDL UNDER LOCK TABLES WRITE, READ LOCAL + PREPARE. |
73988 | 2014-09-20 20:26 | 2014-10-30 18:11 | MySQL Server: DML | Closed (3638 days) | S3 | 5.7.6 | Any | Any | find_all_keys spams server error log with deadlock/lock wait errors |
88693 | 2017-11-29 9:53 | 2018-05-21 11:40 | MySQL Server | Closed (2511 days) | S1 | 5.7.17 | Any | Any | Mutex deadlock causing mysqld to hang and cease to work |
89143 | 2018-01-08 22:10 | 2018-07-02 14:06 | MySQL Server: Replication | Closed (2364 days) | S2 | 5.7.20 | Any | Any | Commit order deadlock + retry logic is not considering trx error cases |
114973 | 2024-05-13 6:55 | 2024-05-14 10:14 | MySQL Server: Documentation | Closed (155 days) | S3 | ALL | Any | Any | deadlock happens in more than two transactions |
20442 | 2006-06-13 21:52 | 2007-02-02 4:07 | MySQL Cluster: NDB API | Closed (6465 days) | S3 | 5.0.22-max | Any (all) | Any | NDB API: scans with exclusive lock and update of one record cause a deadlock |
29206 | 2007-06-19 11:42 | 2007-07-02 4:50 | MySQL Server: Falcon storage engine | Closed (6315 days) | S3 | 6.0.1-alpha-debug | Any (SUSE 10 64-bit) | Any | Falcon: Two-way deadlock with unique index |
37080 | 2008-05-29 21:59 | 2009-01-08 10:32 | MySQL Server: Falcon storage engine | Closed (5759 days) | S3 | mysql-6.0-falcon-team | Any | Any | Falcon deadlock on concurrent insert and truncate |
40224 | 2008-10-21 23:44 | 2011-02-16 23:43 | MySQL Server: InnoDB storage engine | Closed (5233 days) | S2 | 5.1.22+ and plugin | Any | Any | New AUTOINC changes mask reporting of deadlock/timeout errors |
44312 | 2009-04-16 9:47 | 2011-02-16 23:43 | MySQL Server: Replication | Closed (5634 days) | S3 | 5.0 | Any | Any | deadlock between IO thread and SLAVE START |
48210 | 2009-10-21 17:32 | 2011-02-16 23:44 | MySQL Server: Locking | Closed (5336 days) | S3 | mysql-6.0-codebase-bugfixing | Any | Any | FLUSH TABLES WITH READ LOCK deadlocks against concurrent CREATE PROCEDURE |
49047 | 2009-11-24 17:55 | 2011-02-16 23:44 | MySQL Server: InnoDB storage engine | Closed (5123 days) | S5 | 5.0,5.1,plugin | Any | Any | InnoDB deadlock detection is CPU intensive with many locks on a single row |
50998 | 2010-02-08 15:00 | 2011-02-16 23:44 | MySQL Server: Locking | Closed (5336 days) | S2 | mysql-next-4284 | Any | Any | Deadlock in MDL code during test rqg_mdl_stability |
53421 | 2010-05-04 20:28 | 2011-02-16 23:44 | MySQL Server: Replication | Closed (5208 days) | S2 | 5.5.5-m3, 5.6.99-m4 | Any | Any | Part of transaction not written in binlog after deadlock, replication breaks |
57006 | 2010-09-24 14:31 | 2011-02-16 23:44 | MySQL Server: Locking | Closed (5053 days) | S2 | 5.1.52-bzr, 5.5.7 | Any | Any | Deadlock between HANDLER and FLUSH TABLES WITH READ LOCK |
57118 | 2010-09-30 0:51 | 2022-12-04 20:45 | MySQL Server: Locking | Verified (5129 days) | S3 | 5.1.49, 5.1.52-bzr | Any | Any | Undetected deadlock with select for update on a InnoDB + MyISAM join |
65692 | 2012-06-20 18:57 | 2012-11-16 15:06 | MySQL Server: Replication | Closed (4351 days) | S2 | 5.5.23, 5.5.26 | Any | Any | Deadlock between START SLAVE and setting a system variable |
67760 | 2012-11-29 20:02 | 2017-11-09 17:00 | Connector / J | Closed (3541 days) | S2 | 5.1.22 | Any (Observed on Debian 64bits and Windows 64 bits) | Any | Deadlock when concurrently executing prepared statements with Timestamp objects |
70307 | 2013-09-12 0:33 | 2015-02-12 12:37 | MySQL Server: Replication | Closed (3596 days) | S2 | 5.6.13 | Any | Any | Another deadlock on FLUSH TABLES WITH READ LOCK + SHOW SLAVE STATUS |
71127 | 2013-12-11 11:51 | 2013-12-19 11:32 | MySQL Fabric | Closed (3953 days) | S3 | 1.4.0 | Any | Any | Checkpoint routine can lead to deadlock |
75736 | 2015-02-03 2:07 | 2015-04-24 12:40 | MySQL Server: DML | Closed (3462 days) | S1 | 5.7.5-m15, 5.7.6 | Any | Any | DEADLOCK of threads detected! 5.7.5, 1 thread SQL testcase, sporadic, in ib_logf |
89229 | 2018-01-15 3:18 | 2022-09-16 14:02 | MySQL Server: Replication | Verified | S3 | 5.7 | Any | Any | FLUSH PRIVILEGES may cause MTS deadlock |
92108 | 2018-08-21 17:48 | 2023-11-29 11:20 | MySQL Server: Logging | Closed (2206 days) | S2 | 5.7.22 | Any | Any | Deadlock by concurrent show binlogs, pfs session_variables table & binlog purge |
95367 | 2019-05-14 9:00 | 2020-02-07 7:07 | MySQL Server: Locking | Closed (1712 days) | S2 | 5.7.26 | Any | Any | Bug 29772622 - LOCK_GRANT AND LOCK_OPEN CAN DEADLOCK ON A GTID SLAVE II |
96374 | 2019-07-30 6:53 | 2021-05-31 16:29 | MySQL Server: InnoDB storage engine | Closed (1233 days) | S3 | 8.0.16 8.0.17 5.7.25 | Any | Any | binlog rotation deadlock when innodb concurrency limit setted |
100752 | 2020-09-06 2:30 | 2024-10-14 3:54 | MySQL Server: InnoDB storage engine | Verified (1499 days) | S3 | 8.0.21 | Any | Any | Confusing latest deadlock information when victim holds no record locks |
110485 | 2023-03-24 5:00 | 2024-09-25 10:54 | MySQL Server: InnoDB storage engine | Verified (20 days) | S2 | 8.0.32, 8.0.39 | Any | Any | FLUSH TABLE FOR EXPORT will lead deadlock |
112201 | 2023-08-28 10:52 | 2023-08-28 13:47 | MySQL Server: InnoDB storage engine | Verified (414 days) | S3 | 8.0.34 | Any | Any | Deadlock with show fields, alter, and select |
114523 | 2024-04-01 9:48 | 2024-05-11 1:03 | Connector / J | Verified (159 days) | S2 | 8.3.0 | Any | Any | Deadlock when closing connection |
79 | 2003-02-16 10:44 | 2003-03-17 14:08 | MySQL Server: Replication | Closed (7883 days) | S3 | 4.0 | Any (all) | Any | relay_log_space_limit can cause deadlock if we have a big transaction |
106 | 2003-02-27 6:03 | 2019-04-05 13:30 | MySQL Server: InnoDB storage engine | Closed (7888 days) | S2 | 4.0 | Any | Any | Multi table UPDATE Deadlock with Foreign Keys |
5232 | 2004-08-26 15:41 | 2004-09-02 14:37 | MySQL Server | Closed (7348 days) | S3 | 4.0 | Any (Any) | Any | CREATE TABLE ... SELECT can deadlock itself |
9459 | 2005-03-29 16:55 | 2005-08-08 16:06 | MySQL Server | Closed (7008 days) | S3 | 4.1.10a | Any (*) | Any | deadlock with flush with lock, and lock table write |
13182 | 2005-09-14 14:26 | 2005-09-16 16:22 | MySQL Server: Documentation | Closed (6969 days) | S3 | All | Any (All) | Any | Deadlock or a lock wait timeout in InnoDB does not cancel the effect of 'BEGIN' |
23713 | 2006-10-27 12:25 | 2007-12-18 21:45 | MySQL Server: Stored Routines | Closed (6146 days) | S3 | 5.0.27-bk | Any | Any | LOCK TABLES + CREATE TRIGGER + FLUSH TABLES WITH READ LOCK = deadlock |
25494 | 2007-01-09 14:23 | 2011-02-16 23:43 | MySQL Server: InnoDB storage engine | Closed (5231 days) | S3 | 4.0, 4.1, 5.0, 5.1 | Any | Any | LATEST DEADLOCK INFORMATION is not always cleared |
26377 | 2007-02-14 18:46 | 2007-12-03 9:33 | MySQL Server: Merge storage engine | Closed (6161 days) | S1 | 4.0 4.1 5.0 5.1 | Any | Any | Deadlock with MERGE and FLUSH TABLE |
26380 | 2007-02-14 20:28 | 2007-06-23 8:31 | MySQL Server: Locking | Closed (6324 days) | S2 | 5.1.14-beta | Any (Windows XP) | Any | LOCK TABLES + FLUSH LOGS causes deadlock |
29129 | 2007-06-15 7:12 | 2007-08-02 17:20 | MySQL Server: Locking | Closed (6284 days) | S2 | 5.1 | Any | Any | Resetting general_log while the GLOBAL READ LOCK is set causes a deadlock |
31409 | 2007-10-04 20:32 | 2007-10-23 0:16 | MySQL Server | Closed (6202 days) | S3 | 5.0 BK | Any | Any | RENAME TABLE causes server crash or deadlock when used with HANDLER statements |
33480 | 2007-12-22 13:44 | 2008-05-02 23:06 | MySQL Server: Falcon storage engine | Closed (6010 days) | S3 | 6.0.4 | Any | Any | (Falcon) deadlock on inserts into a partitioned auto_increment table |
35632 | 2008-03-28 8:16 | 2016-10-16 20:45 | MySQL Server: Replication | Verified (6039 days) | S1 | 5.1 | Any | Any | server can deadlock with three parallel xa transactions |
36269 | 2008-04-22 23:32 | 2009-01-08 9:48 | MySQL Server: Falcon storage engine | Closed (5759 days) | S3 | 6.0 | Any | Any | Thread stalls during DBT2 run |
36499 | 2008-05-05 8:33 | 2008-08-26 12:34 | MySQL Server: Maria storage engine | Closed (5894 days) | S3 | 5.1-maria | Any | Any | Maria: potential deadlock |
36524 | 2008-05-06 9:46 | 2011-03-30 7:42 | MySQL Server: Replication | Closed (4948 days) | S3 | 5.0,5.1 | Any | Any | incident of deadlock on slave is overdramatized |
40981 | 2008-11-24 15:11 | 2009-01-09 15:13 | MySQL Server: Maria storage engine | Closed (5758 days) | S3 | 5.1-maria | Any | Any | Maria: deadlock between checkpoint and maria_close() when freeing state info |
41665 | 2008-12-21 17:58 | 2009-05-15 16:17 | MySQL Server: Falcon storage engine | Closed (5632 days) | S1 | 6.0-falcon-team | Any | Any | Falcon crash in Transaction::waitForTransaction |
45035 | 2009-05-22 12:27 | 2011-02-16 23:44 | MySQL Server: Locking | Closed (5336 days) | S3 | 6.0.12-bzr, 5.4 | Any | Any | Altering table under LOCK TABLES results in "Error 1213 Deadlock found..." |
45509 | 2009-06-15 20:27 | 2011-02-16 23:44 | MySQL Enterprise Monitor: Agent | Closed (5013 days) | S3 | 2.x | Any | Any | Better SHOW ENGINE INNODB STATUS parsing |
46272 | 2009-07-17 17:54 | 2011-02-16 23:44 | MySQL Server: Locking | Closed (5336 days) | S3 | 6.0-codebase | Any | Any | New MDL: unnecessary deadlock |
46673 | 2009-08-12 12:39 | 2011-02-16 23:44 | MySQL Server: Locking | Closed (5336 days) | S2 | 5.4, azalea | Any | Any | Deadlock between FLUSH TABLES WITH READ LOCK and DML |
48541 | 2009-11-04 18:43 | 2011-02-16 23:44 | MySQL Server: Locking | Closed (5336 days) | S1 | 6.0-codebase-bugfixing | Any | Any | Deadlock between LOCK_open and LOCK_mdl (was deadlock with LOCK_thread_count) |
48724 | 2009-11-12 12:33 | 2011-02-16 23:44 | MySQL Server: DML | Closed (5336 days) | S2 | 6.0.14-bzr, 6.0-codebase-bugfixing | Any | Any | Deadlock between INSERT DELAYED and FLUSH TABLES |
49103 | 2009-11-25 15:16 | 2013-01-11 13:50 | MySQL Server: Information schema | Closed (4295 days) | S2 | next-mr-bugfixing, mysql-5.1 | Any | Any | Deadlock between various INFORMATION_SCHEMA queries |
49536 | 2009-12-08 16:23 | 2011-02-16 23:44 | MySQL Cluster: Replication | Closed (5328 days) | S1 | Any | Any | Mutex deadlock when expire_logs_days is used | |
50821 | 2010-02-02 9:59 | 2011-02-16 23:44 | MySQL Server: Locking | Closed (5336 days) | S1 | mysql-next-4284 | Any | Any | Deadlock between LOCK TABLES and ALTER TABLE |
51591 | 2010-02-28 23:27 | 2011-02-16 23:44 | MySQL Server | Closed (5233 days) | S3 | 5.1 | Any | Any | deadlock in the plugins+status+variables |
52020 | 2010-03-12 21:49 | 2017-12-22 8:24 | MySQL Server: InnoDB storage engine | Closed (4668 days) | S3 | 5.0, 5.1.46 | Any | Any | InnoDB can still deadlock on just INSERT...ON DUPLICATE KEY |
53322 | 2010-04-30 16:58 | 2011-02-16 23:44 | MySQL Server: Locking | Closed (5017 days) | S2 | 5.1.35, 5.1, 5.6.99 bzr | Any | Any | deadlock with FLUSH TABLES WITH READ LOCK and DROP FUNCTION |
54200 | 2010-06-03 12:13 | 2011-02-16 23:44 | MySQL Server: Locking | Closed (5227 days) | S3 | 5.5.4 | Any | Any | Deadlock between FLUSH TABLES WITH READ LOCK and DML in 5.5.4 |
54332 | 2010-06-08 11:31 | 2011-02-16 23:44 | MySQL Server: Locking | Closed (5078 days) | S3 | 5.5.5-m3 | Any | Any | Deadlock with two connections doing LOCK TABLE+INSERT DELAYED |
54360 | 2010-06-09 9:26 | 2011-02-16 23:44 | MySQL Server: Locking | Closed (5114 days) | S2 | 5.1, 5.5 | Any | Any | Deadlock DROP/ALTER/CREATE DATABASE with open HANDLER |
54678 | 2010-06-21 19:43 | 2011-02-16 23:44 | MySQL Server: InnoDB Plugin storage engine | Closed (5061 days) | S2 | 5.1,5.5.5-m3 | Any | Any | InnoDB, TRUNCATE, ALTER, I_S SELECT, crash or deadlock |
56251 | 2010-08-25 13:21 | 2011-02-16 23:44 | MySQL Server: Locking | Closed (5078 days) | S3 | 5.5 | Any | Any | Deadlock with INSERT DELAYED and MERGE tables |
56292 | 2010-08-26 14:37 | 2011-02-16 23:44 | MySQL Server: Locking | Closed (5078 days) | S3 | 5.5 | Any | Any | Deadlock with ALTER TABLE and MERGE tables |
56299 | 2010-08-26 16:16 | 2011-11-07 17:24 | MySQL Server: Locking | Closed (4726 days) | S1 | 5.1.50,5.5.5 | Any | Any | mutex deadlock with COM_BINLOG_DUMP, binlog purge, and processlist/kill |
56844 | 2010-09-17 14:30 | 2011-02-16 23:44 | MySQL Cluster: Cluster (NDB) storage engine | Closed (5142 days) | S3 | mysql-5.1-telco-7.0 | Any | Any | Race condition with 2 ndb_mgmd starting simultanious with "--reload" |
59225 | 2010-12-30 0:43 | 2011-02-16 23:44 | MySQL Server: InnoDB storage engine | Closed (4996 days) | S2 | 5.6.1-m5 | Any | Any | Deadlock between DML and innodb_adaptive_hash_index=OFF |
59351 | 2011-01-07 14:02 | 2015-01-09 10:23 | MySQL Server: Tests | Closed (3567 days) | S3 | mysql-trunk | Any | Any | rqg_info_schema failure in PB2 actual test duration (603 seconds) is more than 2 |
59969 | 2011-02-05 21:41 | 2021-05-02 20:45 | Tests: Cluster | Verified | S3 | 7.1.10 | Any | Any | Test 'ndb_blob_big' times out in locking |
60682 | 2011-03-28 21:25 | 2014-12-23 17:54 | MySQL Server | Closed (4466 days) | S1 | 5.1.47, 5.1.57 | Any | Any | deadlock from thd_security_context |
61247 | 2011-05-20 16:59 | 2013-04-04 11:27 | Connector / J | Closed (4212 days) | S2 | 5.1.16 | Any | Any | Deadlock in case error occurred during StatementImpl#executeQuery call |
67545 | 2012-11-09 22:19 | 2013-04-03 10:32 | MySQL Server: Replication | Closed (4213 days) | S1 | 5.6.7 | Any | Any | 'stop slave' may cause deadlock |
68116 | 2013-01-18 9:32 | 2015-05-08 15:07 | MySQL Server: InnoDB storage engine | Closed (3597 days) | S3 | 5.1, 5.5, 5.6 | Any | Any | InnoDB monitor may hit an assertion error in buf_page_get_gen in debug builds |
68251 | 2013-02-02 1:09 | 2013-05-28 6:58 | MySQL Server: Replication | Closed (4158 days) | S3 | 5.6.9 | Any | Any | 3-way deadlock on semisync replication and binlog rotate |
68569 | 2013-03-05 4:31 | 2013-05-28 6:56 | MySQL Server: Replication | Closed (4158 days) | S1 | 5.6.10 | Any | Any | deadlock with group commit |
69668 | 2013-07-04 8:00 | 2013-09-06 16:42 | MySQL Server: Locking | Closed (4057 days) | S3 | 5.5.33-bzr | Any | Any | Transaction is not fully rolled back in case of InnoDB deadlock |
70704 | 2013-10-23 15:16 | 2017-04-19 0:52 | Connector / J | Closed (2736 days) | S2 | mysql-connector-java-5.1.23 | Any | Any | Deadlock using UpdatableResultSet |
71236 | 2013-12-27 10:18 | 2014-08-01 16:43 | MySQL Server: Locking | Closed (3728 days) | S2 | 5.1.73, 5.5.35, 5.6.15 | Any | Any | Deadlock between mysql_change_user(), SHOW VARIABLES and INSTALL PLUGIN |
71433 | 2014-01-20 19:10 | 2014-09-25 11:49 | MySQL Server: Locking | Closed (3673 days) | S2 | 5.6 | Any | Any | recreate+analyze OPTIMIZE TABLE T and online ALTER TABLE T may deadlock |
74177 | 2014-10-01 13:51 | 2015-06-26 16:01 | MySQL Server: Replication | Closed (3399 days) | S2 | 5.7.5, 5.7.6 | Any | Any | --slave-preserve-commit-order causes slave to deadlock and break for some querie |
77209 | 2015-06-01 11:31 | 2016-02-25 18:38 | MySQL Server: Optimizer | Closed (3155 days) | S3 | 5.6.24 | Any | Any | Update may use index merge without any reason (increasing chances for deadlock) |
80927 | 2016-03-31 15:24 | 2023-11-21 10:21 | MySQL Server: InnoDB storage engine | Closed (376 days) | S3 | 5.5, 5.5.48 | Any | Any | InnoDB Last Detected Deadlock Not showing full query |
86079 | 2017-04-25 19:28 | 2018-02-27 17:32 | MySQL Server: Replication | Closed (2422 days) | S2 | 8.0.1 | Any | Any | Deadlock with slave_preserve_commit_order=ON with Bug#86078. |
86812 | 2017-06-23 11:35 | 2017-06-23 12:24 | MySQL Server: InnoDB storage engine | Verified (2671 days) | S3 | 5.5, 5.6, 5.7, 8.0, 5.7.18, 8.0.2 | Any | Any | Unnecessary deadlock with UNIQUE key |
87225 | 2017-07-27 15:38 | 2017-10-23 18:07 | MySQL Server: InnoDB storage engine | Closed (2549 days) | S3 | 8.0.3 | Any | Any | assert failure: !sdi_insert_failed || trx_is_interrupted(trx) |
87620 | 2017-08-31 9:13 | 2018-10-30 7:57 | MySQL Server: Locking | Closed (2538 days) | S3 | 5.7.5+ | Any | Any | Deadlock on get_lock(..., 0) |
88600 | 2017-11-22 7:50 | 2017-11-23 13:32 | MySQL Server | Closed (2518 days) | S3 | 5.6.29-76.2-log | Any | Any | Update use index merge (unique and index)--deadlock |
88668 | 2017-11-27 17:30 | 2018-05-31 14:49 | MySQL Server: Group Replication | Closed (2427 days) | S3 | 8.0.4 | Any | Any | UNISTALL Group Replication can deadlock with GR Start on server start |
89214 | 2018-01-12 19:30 | 2018-10-03 13:07 | MySQL Server: Prepared statements | Closed (2204 days) | S2 | 5.7,5.7.17,5.7.20,5.7.21 | Any | Any | The SELECT will deadlock in the stored procedure, if the result set is empty. |
91548 | 2018-07-04 15:39 | 2019-05-14 9:05 | MySQL Server: Locking | Closed (2146 days) | S1 | 5.7.22 | Any | Any | LOCK_grant and LOCK_open can deadlock on a gtid slave |
95181 | 2019-04-29 10:02 | 2020-05-20 13:40 | MySQL Server: Logging | Closed (1609 days) | S3 | 5.7, 8.0 | Any | Any | The bugfix for Bug#28511326 seems incorrect |
97352 | 2019-10-24 6:18 | 2019-12-13 19:34 | MySQL Server: InnoDB storage engine | Closed (1768 days) | S1 | 8.0.17 | Any | Any | MySQL hangs with DROP UNDO TABLESPACE and ALTER INSTANCE ROTATE MASTER KEY |
97825 | 2019-11-28 9:27 | 2020-03-10 13:01 | MySQL Server: InnoDB storage engine | Closed (1681 days) | S3 | 8.0.18 | Any | Any | dd_mdl_acquire in dd_table_open with dict_sys->mutex hold may cause deadlock |
98133 | 2020-01-06 12:05 | 2020-01-21 12:59 | MySQL Server: Documentation | Verified (1742 days) | S3 | 5.7, 8.0 | Any | Any | Docs on InnoDB Error Handling incorrect |
98295 | 2020-01-20 11:00 | 2023-02-01 7:55 | MySQL Server: InnoDB storage engine | Closed (1714 days) | S3 | 5.7.23 | Any | Any | Innodb internal deadlock cause a long wait semaphore, and a mysqld crash |
98324 | 2020-01-22 9:57 | 2022-03-07 6:04 | MySQL Server: InnoDB storage engine | Verified (1658 days) | S2 | 5.7.26, 5.7.29, 8.0.20 | Any | Any | Deadlocks more frequent since version 5.7.26 |
99045 | 2020-03-24 3:30 | 2023-02-21 16:54 | MySQL Server: XA transactions | Verified (1664 days) | S2 | 5.7, 8.0, 5.7.29 | Any | Any | deadlock during XA cause slave SQL thread XAER_RMFAIL error |
105243 | 2021-10-16 9:09 | 2021-10-19 8:27 | MySQL Server: Replication | Verified (1092 days) | S3 | 8.0.25 | Any | Any | Execute "mysql.server stop" command deadlock after using "start slave" command |
110795 | 2023-04-25 5:45 | 2023-04-25 8:41 | MySQL Server: Locking | Verified (539 days) | S3 | 8.0.27, 8.0.33, 5.7.42 | Any | Any | mysql insert is deadlocked |
112850 | 2023-10-27 4:33 | 2023-10-30 12:22 | MySQL Server: Locking | Verified (354 days) | S3 | 8.0 | Any | Any | Deadlock happens in RC but not in higher RR isolation level |
115730 | 2024-07-31 4:32 | 2024-07-31 6:46 | MySQL Server: Replication | Verified (76 days) | S3 | 8.0.39 | Any | Any | Deadlock between OPTIMIZE TABLE and XA transaction in slave |
5898 | 2004-10-05 8:42 | 2004-10-30 8:49 | MySQL Server: InnoDB storage engine | Closed (7290 days) | S1 | 4.0, 4.1, 5.0 | Any (All) | Any | Intentional server crash in InnoDB code |
9749 | 2005-04-08 10:14 | 2005-04-25 11:04 | MySQL Cluster: Cluster (NDB) storage engine | Closed (7113 days) | S1 | 5.0.3 | Any (*) | Any | Transactions causes deadlock in ACC |
11290 | 2005-06-13 14:49 | 2005-06-14 12:47 | MySQL Cluster: Cluster (NDB) storage engine | Closed (7063 days) | S3 | 4.1-> | Any (any) | Any | TransactionInactiveTimeout = 0 does not result in infinite timeout |
12308 | 2005-08-02 0:11 | 2005-09-08 17:31 | MySQL Server: InnoDB storage engine | Closed (6977 days) | S1 | 4.0 and above (should be fixed in 5.0) | Any (All) | Any | InnoDB rollbacks whole transaction on lock timeouts |
15520 | 2005-12-06 14:26 | 2006-05-03 17:56 | MySQL Server: Documentation | Closed (6740 days) | S3 | all | Any (all) | Any | "Optimize table" wants INSERT privs? |
16581 | 2006-01-17 20:29 | 2006-08-18 11:38 | MySQL Server: Locking | Closed (6633 days) | S2 | 5.0.17a-cert | Any (any) | Any | deadlock: server and client both read from connection in 'conc_sys' test |
21833 | 2006-08-25 13:07 | 2006-09-25 0:14 | MySQL Server: InnoDB storage engine | Closed (6595 days) | S2 | 5.1 | Any (ALL) | Any | Prepare_commit_mutex is not locked and unlocked under the same condition |
30379 | 2007-08-13 1:55 | 2007-11-06 8:45 | MySQL Cluster: Cluster (NDB) storage engine | Closed (6188 days) | S3 | Any | Any | TC timeout check isn't very random | |
30990 | 2007-09-13 4:30 | 2012-09-13 8:35 | Connector / J | Closed (6178 days) | S3 | connectorJ 5.0.4 & 5.0.7 | Any | Any | JDBC connections do not properly free up resources when returned a pool |
32395 | 2007-11-14 20:04 | 2010-10-11 7:54 | MySQL Server: Locking | Closed (6146 days) | S2 | 5.1 | Any | Any | Alter table under a impending global read lock causes a server crash |
32430 | 2007-11-16 9:35 | 2011-02-16 23:43 | MySQL Server: Storage Engine API | Closed (5234 days) | S3 | 5.1.22, 5.1.23, 5.1.37, 5.1.40 | Any | Any | 'show innodb status' causes errors Invalid (old?) table or database name in logs |
32528 | 2007-11-20 14:41 | 2007-12-12 19:54 | MySQL Server: Locking | Closed (6152 days) | S3 | 5.0/5.1BK | Any | Any | Global read lock with a low priority write lock causes a server crash |
33191 | 2007-12-13 1:21 | 2008-05-02 23:30 | MySQL Server: Falcon storage engine | Closed (6010 days) | S2 | 6.0.4 | Any | Any | Threads 'serialize' when multy-query delete trans. w/trig are run againt Falcon |
34567 | 2008-02-14 20:59 | 2008-10-09 11:39 | MySQL Server: Falcon storage engine | Closed (5850 days) | S3 | 6.0-falcon-team | Any | Any | Falcon deadlock between ALTERs of temporary and non-temporary tables |
34627 | 2008-02-17 16:21 | 2008-05-21 14:10 | MySQL Server: Falcon storage engine | Closed (5991 days) | S3 | 6.0.4 | Any | Any | Falcon potential deadlock in Bdb::addRef |
35140 | 2008-03-07 10:11 | 2008-05-21 14:24 | MySQL Server: Falcon storage engine | Closed (5991 days) | S3 | 6.0.4 | Any | Any | Suspected Falcon deadlock in Table::insert |
35395 | 2008-03-18 13:14 | 2008-09-18 5:56 | MySQL Server: Locking | Closed (5871 days) | S3 | 6.0 source | Any | Any | Object services for enumerating view dependencies make server deadlock. |
35593 | 2008-03-27 9:52 | 2008-05-31 10:46 | MySQL Cluster: Cluster (NDB) storage engine | Closed (5981 days) | S3 | mysql-5.1, mysql-5.1-telco-*, mysql-6.0 | Any | Any | Memory leak in failed NDB execute() with blobs. |
37251 | 2008-06-06 19:26 | 2009-01-08 10:34 | MySQL Server: Falcon storage engine | Closed (5759 days) | S2 | 6.0-falcon-team | Any | Any | Livelock between UPDATE and DELETE threads |
37346 | 2008-06-11 14:35 | 2011-02-16 23:43 | MySQL Server: Locking | Closed (5336 days) | S3 | 5.0,5.1 | Any | Any | innodb does not detect deadlock between update and alter table |
37433 | 2008-06-16 18:58 | 2011-02-16 23:43 | MySQL Server: Locking | Closed (5451 days) | S1 | 6.0 | Any | Any | Deadlock between open_table, close_open_tables, get_table_share, drop_open_table |
37725 | 2008-06-29 11:15 | 2008-10-01 12:11 | MySQL Server: Falcon storage engine | Closed (5858 days) | S1 | 6.0-falcon | Any | Any | Falcon: assertion in waitForTransaction "waitingFor was not NULL" |
38043 | 2008-07-11 10:50 | 2008-09-30 20:36 | MySQL Server: Falcon storage engine | Closed (5859 days) | S1 | 6.0-falcon | Any | Any | Deadlock between server and falcon when executing concurrent ALTER + DML |
38129 | 2008-07-15 10:13 | 2011-02-16 23:43 | MySQL Enterprise Monitor: Agent | Closed (5591 days) | S2 | 1.3.x | Any (Vista 32) | Any | agent floods its log with "executing regex for innodb ... failed" |
38663 | 2008-08-08 10:05 | 2021-05-02 20:45 | Tests: Cluster | Verified | S3 | 6.0-BK | Any | Any | Sporadic timeout in NDB |
39180 | 2008-09-02 9:59 | 2008-11-14 14:13 | MySQL Cluster: Cluster (NDB) storage engine | Closed (5814 days) | S3 | 6.2 | Any | Any | Segfault in Logger::Log causes ndbd to hang indefinately - part2 |
39210 | 2008-09-03 11:19 | 2009-01-09 14:58 | MySQL Server: Maria storage engine | Closed (5758 days) | S1 | 5.1-maria, 6.0-maria | Any | Any | Maria deadlock in _ma_bitmap_wait_or_flush |
39321 | 2008-09-08 15:58 | 2009-01-09 14:13 | MySQL Server: Falcon storage engine | Closed (5758 days) | S1 | 6.0-falcon-team | Any | Any | Falcon deadlock between Table::retireRecords and Database::retireRecords |
39879 | 2008-10-06 11:57 | 2008-11-12 13:16 | MySQL Cluster: NDB API | Closed (5816 days) | S3 | 5.1-telco-6.2.15 | Any | Any | NDBAPI : Wrong error reported for SendBuffer overload |
40391 | 2008-10-29 10:35 | 2009-01-08 10:39 | MySQL Server: Maria storage engine | Closed (5759 days) | S1 | 6.0-bzr | Any | Any | Maria deadlock in trnman_get_min_trid , trnman_end_trn |
40892 | 2008-11-20 16:10 | 2009-01-08 10:38 | MySQL Server: Maria storage engine | Closed (5759 days) | S1 | 6.0.8-release | Any | Any | maria: Livelock in sysbench OLTP_RW test |
41159 | 2008-12-01 21:01 | 2009-01-09 15:00 | MySQL Server: Maria storage engine | Closed (5758 days) | S3 | 5.1-maria | Any | Any | Maria: deadlock between checkpoint and maria_write() when extending data file |
42201 | 2009-01-19 14:22 | 2009-05-07 8:30 | MySQL Server: Maria storage engine | Closed (5640 days) | S3 | 5.1-maria | Any | Any | Maria: after a deadlock, table is marked as corrupted |
43630 | 2009-03-13 11:31 | 2009-10-22 10:35 | MySQL Server: Falcon storage engine | Closed (5472 days) | S2 | falcon-team | Any | Any | A SELECT using ORDER BY and LIMIT sometimes returns no rows |
43867 | 2009-03-25 22:10 | 2011-02-16 23:43 | MySQL Server: Partitions | Closed (5336 days) | S2 | 6.0-runtime, azalea | Any | Any | ALTER TABLE on a partitioned table causes unnecessary deadlocks |
44058 | 2009-04-02 23:28 | 2011-02-16 23:43 | MySQL Server: Replication | Closed (5451 days) | S3 | 6.0 | Any | Any | Possible semi-sync replication bugs |
44099 | 2009-04-05 20:55 | 2011-02-16 23:43 | MySQL Cluster: Cluster (NDB) storage engine | Closed (5662 days) | S3 | * | Any | Any | Scan can timeout incorrectly if low selectivity |
45066 | 2009-05-25 12:21 | 2011-02-16 23:44 | MySQL Server: Locking | Closed (5336 days) | S3 | 5.1 | Any | Any | FLUSH TABLES WITH READ LOCK deadlocks against LOCK TABLE |
46224 | 2009-07-16 14:08 | 2011-02-16 23:44 | MySQL Server: Locking | Closed (5336 days) | S2 | 5.4+ | Any | Any | HANDLER statements within a transaction might lead to deadlocks |
47245 | 2009-09-10 10:41 | 2021-05-02 20:45 | Tests: Cluster | Verified | S3 | 5.1 | Any | Any | rpl_ndb.rpl_ndb_2other fails on PB2. |
48842 | 2009-11-17 16:14 | 2012-05-18 20:19 | MySQL Server: Backup | Verified (5293 days) | S3 | 6.0-backup | Any | Any | MySQL Backup: RESTORE of compressed MyISAM table throws unwanted warnings |
49675 | 2009-12-14 14:39 | 2012-05-18 20:19 | Tools: Random Query Generator | Verified | S3 | 2 | Any | Any | Metadata caching is not optimal |
50038 | 2010-01-04 2:43 | 2011-02-16 23:44 | MySQL Server: Row Based Replication ( RBR ) | Closed (5336 days) | S2 | mysql-5.1-rep+3 | Any | Any | Deadlock on flush logs with concurrent DML and RBR |
50913 | 2010-02-04 13:30 | 2011-02-16 23:44 | MySQL Server: Locking | Closed (5336 days) | S2 | mysql-next-4284 | Any | Any | Deadlock between open_and_lock_tables_derived and MDL |
51160 | 2010-02-13 10:13 | 2011-02-16 23:44 | MySQL Server | Closed (5284 days) | S2 | mysql-next-mr, 5.1 | Any | Any | Deadlock around SET GLOBAL EVENT_SCHEDULER = ON|OFF |
51193 | 2010-02-15 16:45 | 2015-02-04 22:35 | MySQL Server: Documentation | Closed (3541 days) | S3 | 5.1 | Any | Any | Update 1.8.5.2 Transactions and Atomic Operations in the reference manual |
51263 | 2010-02-18 1:10 | 2011-02-16 23:44 | MySQL Server: Locking | Closed (5200 days) | S2 | mysql-next-4284,5.5-m3 | Any | Any | Deadlock between transactional SELECT and ALTER TABLE ... REBUILD PARTITION |
51557 | 2010-02-26 15:41 | 2011-02-16 23:44 | MySQL Server: Locking | Closed (5213 days) | S2 | 5.0.84 | Any | Any | LOCK_open and kernel_mutex are not happy together |
51691 | 2010-03-03 12:06 | 2011-02-16 23:44 | Tools: Random Query Generator | Closed (5338 days) | S2 | Any (non-windows) | Any | RQG backtraces from corefiles no longer working on unix | |
52367 | 2010-03-25 15:27 | 2011-02-16 23:44 | MySQL Server: Locking | Closed (5270 days) | S2 | 5.5.4-m3 | Any | Any | Deadlock involving SET GLOBAL EVENT_SCHEDULER = OFF during rqg_mdl_deadlock test |
54724 | 2010-06-23 8:34 | 2011-02-16 23:44 | MySQL Cluster: NDB API | Closed (5174 days) | S3 | mysql-5.1-telco-6.3 | Any | Any | NdbTransaction::refresh() does not reset TransactionInactiveTimeout timer? |
54747 | 2010-06-23 16:06 | 2011-02-16 23:44 | MySQL Server: Locking | Closed (5149 days) | S3 | 5.5.3-m3, 5.5.5-m3 | Any | Any | Deadlock between REORGANIZE PARTITION and SELECT is not detected |
55798 | 2010-08-06 10:17 | 2011-05-13 10:28 | MySQL Server: Replication | Closed (4904 days) | S3 | 5.1.50-bzr | Any | Any | Slave SQL retry on transaction inserts extra data into non-transaction table |
57232 | 2010-10-04 22:44 | 2011-02-16 23:44 | MySQL Server: InnoDB storage engine | Closed (5068 days) | S1 | All | Any | Any | Possible corruption during UNDO phase at startup after crash recovery |
58212 | 2010-11-15 21:20 | 2011-02-16 23:44 | MySQL Server: InnoDB storage engine | Closed (5011 days) | S3 | 5.5+ | Any | Any | Possible deadlock in change buffer in debug builds |
59683 | 2011-01-23 21:58 | 2012-02-13 3:40 | MySQL Server: InnoDB storage engine | Closed (4628 days) | S3 | 5.5+ | Any | Any | InnoDB latch deadlock detector/violation debug code is very slow |
59733 | 2011-01-26 7:32 | 2011-10-07 20:59 | MySQL Server: InnoDB storage engine | Closed (4757 days) | S2 | 3.23.53,4.0,4.1,5.0,5.1,5.5 | Any | Any | Possible deadlock when buffered changes are to be discarded in buf_page_create() |
59986 | 2011-02-07 14:29 | 2011-04-06 1:45 | MySQL Server: Locking | Closed (4941 days) | S3 | 5.5, trunk | Any | Any | Assert in Diagnostics_area::set_ok_status() for XA COMMIT |
61105 | 2011-05-09 19:55 | 2013-06-25 21:38 | Connector / J | Closed (4130 days) | S3 | 5.1.16 | Any | Any | Avoid Java bottleneck by using explicit Charset for byte[]<->String conversions |
63122 | 2011-11-06 22:51 | 2020-06-18 9:14 | MySQL Server: InnoDB storage engine | Verified (4725 days) | S3 | 5.0+ | Any | Any | "Searched SQL update" seems to release lock got by "select for update" |
63203 | 2011-11-11 10:20 | 2013-12-30 4:41 | MySQL Server: Locking | Closed (3942 days) | S2 | 5.1.61, 5.5 | Any | Any | Possible deadlock due to lock order violation |
67879 | 2012-12-11 22:59 | 2014-12-19 4:59 | MySQL Server: Replication | Closed (4255 days) | S2 | 5.1, 5.5, 5.6 | Any | Any | Slave deadlock caused by stop slave, show slave status and global read lock |
69954 | 2013-08-07 15:31 | 2017-06-05 8:33 | MySQL Server: Replication | Closed (3767 days) | S1 | 5.5.34 | Any | Any | 4-way deadlock: zombies, purging binlogs, show processlist, show binlogs |
70216 | 2013-09-02 12:42 | 2015-08-06 9:12 | MySQL Server: InnoDB storage engine | Closed (3654 days) | S3 | 5.1, 5.5, 5.6 | Any | Any | Unnecessary overhead from persistent adaptive hash index latches |
71060 | 2013-12-03 14:08 | 2013-12-05 13:31 | MySQL Server: Locking | Verified (3969 days) | S2 | 5.6.15, 5.6.16, 5.5.35, 5.1.74 | Any | Any | INSERT-SELECT statement takes shared locks in trigger and causes deadlock |
72870 | 2014-06-04 12:01 | 2014-07-21 15:40 | MySQL Server: Locking | Closed (3760 days) | S2 | 5.5 | Any | Any | Backport bug#18008907 to 5.5+ versions. |
73475 | 2014-08-05 16:05 | 2014-09-19 14:29 | MySQL Server: Locking | Closed (3679 days) | S3 | 7.2 | Any | Any | PORT FIX FOR BUG 17283409 TO MYSQL CLUSTER 7.2 |
73531 | 2014-08-11 12:20 | 2014-12-09 19:54 | MySQL Server: Replication | Verified (3717 days) | S1 | 5.5, 5.5.39 | Any | Any | Not all the 4-way deadlocks of bug 69954 have been fixed |
74117 | 2014-09-27 15:42 | 2014-12-01 10:48 | MySQL for Windows: Installer | Closed (3641 days) | S1 | 5.7.5, 5.6.21 | Any | Any | string not recognized as a valid datetime |
74209 | 2014-10-03 8:38 | 2014-10-22 21:46 | MySQL Server: InnoDB storage engine | Closed (3654 days) | S2 | 5.7.5 | Any | Any | btr_cur_search_to_nth_level() should check modify intention also for leaf pages |
74308 | 2014-10-10 4:32 | 2014-10-22 21:44 | MySQL Server: InnoDB storage engine | Closed (3658 days) | S3 | 5.7.5 | Any | Any | dict_index_node_ptr_max_size() returns wrong small value for SYS_TABLES |
77100 | 2015-05-20 4:31 | 2015-05-25 14:27 | MySQL Server: InnoDB storage engine | Closed (3431 days) | S3 | 5.7.7 | Any | Any | ib_open_table_by_id() gives wrong argument for dict_table_open_on_id() |
77390 | 2015-06-17 12:54 | 2017-04-12 16:27 | MySQL Server: Documentation | Closed (2743 days) | S3 | 5.6 | Any | Any | Manual does not explain a "deadlock" case of online ALTER |
77399 | 2015-06-18 8:22 | 2020-01-13 14:59 | MySQL Server: InnoDB storage engine | Closed (1737 days) | S3 | 5.6.25,5.7.7, 5.6.26, 5.7.8, 8.0.1 | Any | Any | Deadlocks missed by INFORMATION_SCHEMA.INNODB_METRICS lock_deadlocks counter |
79545 | 2015-12-07 12:17 | 2018-08-24 13:23 | MySQL Server: InnoDB storage engine | Closed (2244 days) | S3 | 5.6 | Any | Any | When no free cell found, sync_array_reserve_cell should call sync_array_exit. |
79665 | 2015-12-16 10:50 | 2017-05-31 20:02 | MySQL Server: Documentation | Closed (2694 days) | S3 | any | Any | Any | Manual does NOT explain locks set by INSERT ... ON DUPLICATE KEY UPDATE properly |
80898 | 2016-03-30 5:00 | 2016-11-16 6:49 | MySQL Server: InnoDB storage engine | Closed (3119 days) | S3 | 5.7 | Any | Any | Replication stops after transaction is rolled back asynchronously in master |
82127 | 2016-07-06 13:55 | 2019-06-13 12:45 | MySQL Server: InnoDB storage engine | Closed (1952 days) | S3 | 5.7.13 | Any | Any | Deadlock with 3 concurrent DELETEs by UNIQUE key |
82143 | 2016-07-07 10:29 | 2016-11-29 1:59 | MySQL Server: DDL | Closed (2975 days) | S3 | 8.0 | Any | Any | While processing SELECT of CREATE TABLE |
82204 | 2016-07-12 19:46 | 2016-07-13 7:12 | MySQL Server: Locking | Verified (3016 days) | S2 | 5.5.50, 5.6.31, 5.7.13 | Any | Any | Metadata lock does not protect transaction if LOCK TABLE and ALTER involved |
83588 | 2016-10-27 22:57 | 2017-06-02 15:26 | MySQL Server: XA transactions | Closed (2861 days) | S2 | 5.7.13 | Any | Any | Slave retries (slave_transaction_retries) does not work with XA transactions |
83640 | 2016-11-01 14:46 | 2017-01-10 17:02 | MySQL Server: InnoDB storage engine | Verified (2835 days) | S3 | any, 5.6.34 | Any | Any | Locks set by DELETE statement on already deleted record |
84295 | 2016-12-21 8:25 | 2017-02-06 18:45 | MySQL Server: Documentation | Closed (2808 days) | S3 | 5.6.11,5.7.12 | Any | Any | The behavior is different when innodb_rollback_on_timeout=on |
87326 | 2017-08-05 3:21 | 2017-08-23 17:58 | MySQL Server: Replication | Verified (2610 days) | S2 | 5.6.27 - 5.6.35 | Any | Any | deadlock in binary log. |
87984 | 2017-10-05 4:20 | 2017-10-05 6:24 | MySQL Server: MyISAM storage engine | Verified (2567 days) | S3 | 5.7.19 | Any | Any | deadlock with --log-isam=myisam.log --myisam_use_mmap=1 --initialize-insecure |
88944 | 2017-12-15 21:31 | 2018-05-31 14:57 | MySQL Server: Group Replication | Closed (2423 days) | S2 | 8.0.4 | Any | Any | Server freeze on failed auto-rejoin |
89175 | 2018-01-10 19:46 | 2018-01-23 13:19 | MySQL Server: Documentation | Closed (2457 days) | S3 | 5.6, 5.7 | Any | Any | Document name of generated hidden cluster index |
91671 | 2018-07-17 2:08 | 2018-11-27 12:05 | MySQL Server: Group Replication | Closed (2149 days) | S3 | 5.7.22 | Any | Any | stop slave sql_thread for channel 'group_replication_applier' could not return |
93649 | 2018-12-18 3:23 | 2022-09-16 7:22 | MySQL Server: Replication | Closed (2013 days) | S3 | 8.0.13 | Any | Any | STOP SLAVE SQL_THREAD deadlocks if done while holding LOCK INSTANCE FOR BACKUP |
95079 | 2019-04-23 2:32 | 2019-04-25 9:21 | MySQL Server: InnoDB storage engine | Verified (2002 days) | S3 | 5.7, 5.7.25 | Any | Any | False duplicate key check |
95223 | 2019-05-02 12:57 | 2019-07-17 12:23 | MySQL Server: Locking | Closed (1918 days) | S3 | 8.0.15 | Any | Any | Locking loop between LOCK_event_queue and event MDL lock |
95863 | 2019-06-18 14:59 | 2022-11-03 17:50 | MySQL Server: Replication | Verified (1545 days) | S3 | 5.7.26,8.0.16, 5.7.27 | Any | Any | MTS ordered commit may cause deadlock |
99751 | 2020-06-01 10:17 | 2020-08-24 12:09 | MySQL Server: Documentation | Closed (1516 days) | S3 | 8.0 | Any | Any | Statements after a deadlock |
102967 | 2021-03-15 2:39 | 2021-03-16 11:46 | MySQL Server: InnoDB storage engine | Verified (1309 days) | S3 | 5.7.18 | Any | Any | deadlock transaction hang up when connection is broken |
103275 | 2021-04-12 5:41 | 2024-03-06 14:56 | MySQL Server: Memcached | Verified (1273 days) | S2 | 8.0.23, 8.0.24 | Any | Any | MySQL starup hangs when used with memcached |
108891 | 2022-10-26 20:22 | 2022-10-27 6:07 | MySQL Server: InnoDB storage engine | Verified (719 days) | S3 | 8.0 | Any | Any | innodb_print_all_deadlocks missing information. |
110584 | 2023-04-03 2:51 | 2023-04-03 4:10 | MySQL Server: InnoDB storage engine | Verified (561 days) | S3 | Ver 8.0 | Any | Any | add missing timestamp and headers information innodb_print_all_deadlocks |
114272 | 2024-03-08 0:02 | 2024-07-02 19:38 | Connector / NET | Closed (217 days) | S3 | 8.0 | Any | Any | Contribution: Fix deadlock in mysql poolmanager attempt #2 |
65890 | 2012-07-13 9:17 | 2015-12-12 23:23 | MySQL Server: Documentation | Closed (3230 days) | S2 | 5.5.X | Linux (CentOS 6.X) | Any | Deadlock that is not a deadlock with transaction and lock tables |
45694 | 2009-06-24 7:04 | 2011-02-16 23:44 | MySQL Server: Replication | Closed (5508 days) | S2 | 5.0.77, 5.0 5.1, azalea bzr | Linux | Any | Deadlock in replicated statement is not retried |
29452 | 2007-06-29 21:13 | 2007-12-03 13:14 | MySQL Server: Falcon storage engine | Closed (6161 days) | S3 | 6.0.1-alpha-debug | Linux (SUSE 10 64-bit) | Any | Falcon: two-way deadlock with unique index and trigger |
8325 | 2005-02-04 19:35 | 2005-03-23 19:20 | MySQL Server: Replication | Closed (7146 days) | S2 | 4.0.22 | Linux (Linux) | Any | Deadlock in replication thread stops replication |
12739 | 2005-08-23 0:15 | 2005-10-20 18:09 | MySQL Server | Closed (6935 days) | S2 | the latest 5.0.12pre | Linux (Linux) | Any | Deadlock in multithread env during creating/droping trigger on innodb table |
16986 | 2006-01-31 21:43 | 2006-06-27 7:00 | MySQL Server: MyISAM storage engine | Closed (6685 days) | S2 | 5.0.18 | Linux (Linux) | Any | Deadlock condition with MyISAM tables |
41233 | 2008-12-04 15:43 | 2021-05-02 20:45 | MySQL Cluster: Disk Data | Verified (5653 days) | S3 | mysql-5.1-telco-6.3 | Linux | Any | Using few large TS data files can cause tmp deadlock error under load |
56405 | 2010-08-31 13:26 | 2011-02-16 23:44 | MySQL Server: Locking | Closed (5078 days) | S1 | 5.5 | Linux (Ubuntu 64 bit) | Any | Deadlock in the MDL deadlock detector |
91633 | 2018-07-13 21:14 | 2021-05-28 7:35 | MySQL Server: Replication | Closed (1236 days) | S2 | 5.7.22, 5.7.33 | Linux | x86 | Replication failure (errno 1399) on update in XA tx after deadlock |
7823 | 2005-01-12 2:49 | 2005-04-28 16:07 | MySQL Server | Closed (7110 days) | S3 | 4.0.23 | Linux (Red Hat Enterprise Linux) | Any | FLUSH TABLES WITH READ LOCK + INSERT DELAYED = deadlock |
7975 | 2005-01-17 22:56 | 2005-04-18 10:22 | MySQL Server: InnoDB storage engine | Closed (7120 days) | S3 | 4.1.9, official 686 binary | Linux (debian amd64 pure64) | Any | deadlock without any locking, simple select and update |
10942 | 2005-05-29 12:42 | 2005-12-09 18:52 | MySQL Server: Replication | Closed (6885 days) | S3 | 4.1 | Linux (linux) | Any | deadlock with FLUSH TABLES WITH READ LOCK + STOP SLAVE |
11726 | 2005-07-04 16:21 | 2005-09-01 19:31 | MySQL Cluster: Cluster (NDB) storage engine | Closed (6984 days) | S3 | 5.1.0-wl2325-wl1354-new | Linux (Linux) | Any | Error Message does not give cause: Slave SQL thread retried transaction 10 time |
12423 | 2005-08-07 22:04 | 2005-09-04 2:55 | MySQL Server | Closed (6981 days) | S2 | the latest 5.0.12pre | Linux (Linux) | Any | Deadlock in multithread environment (stress test) |
18116 | 2006-03-09 20:49 | 2006-04-06 0:17 | MySQL Server: Replication | Closed (6767 days) | S2 | 5.0.18 | Linux (linux) | Any | MySQL 5.0 deadlocks while writing binary log |
20048 | 2006-05-24 14:17 | 2006-05-26 16:20 | MySQL Server: Locking | Closed (6717 days) | S3 | 5.0 | Linux (SuSE 10.0) | Any | FLUSH TABLES WITH READ LOCK causes a deadlock |
21483 | 2006-08-07 15:37 | 2007-05-27 9:34 | MySQL Server: Locking | Closed (6351 days) | S2 | 5.0.24, 5.1 | Linux (FC3) | Any | Server abort or deadlock on INSERT DELAYED with another implicit insert |
22876 | 2006-10-01 20:10 | 2011-02-16 23:43 | MySQL Server: Locking | Closed (5337 days) | S3 | 5.1.12-beta-debug | Linux (SUSE 10.0 / 64-bit) | Any | Four-way deadlock |
26503 | 2007-02-20 17:06 | 2007-03-31 23:03 | MySQL Server: Parser | Closed (6408 days) | S1 | 5.0.24-20070220bk, 5.1.15, 5.1.16BK, 5.2.3 | Linux (Linux 2.6.19.1+glibc 2.4, Windows) | Any | Illegal SQL exception handler code causes the server to crash |
39602 | 2008-09-23 15:28 | 2008-11-15 1:31 | MySQL Server: Backup | Closed (5813 days) | S3 | mysql-6.0-backup | Linux (Ubuntu x86/64) | Any | Backup: deadlock between backup and myisam |
39665 | 2008-09-26 12:02 | 2009-01-08 11:09 | MySQL Server: Maria storage engine | Closed (5759 days) | S3 | 5.1-maria | Linux | Any | Maria: assertion in block format during table scan |
43210 | 2009-02-26 7:08 | 2011-02-16 23:43 | MySQL Server: Documentation | Closed (5648 days) | S2 | 5.0.51a-community-log, 5.0.74 | Linux | Any | Deadlock detected on concurrent insert into same table (InnoDB) |
67409 | 2012-10-29 11:47 | 2012-12-29 0:25 | MySQL Server: Documentation | Closed (4308 days) | S2 | 5.5 | Linux | Any | Inconsistent Documentation & use of nouns |
68634 | 2013-03-11 10:59 | 2018-02-09 19:24 | MySQL Cluster: Cluster (NDB) storage engine | Verified (4233 days) | S3 | 5.5.22-ndb-7.2.6-log | Linux | Any | DROP/CREATE TABLE running into timeouts on certain api nodes, but not all |
87796 | 2017-09-19 5:11 | 2021-09-01 13:10 | MySQL Server: Replication | Closed (1415 days) | S1 | 5.7.19 | Linux (Linux localhost 3.10.0-327.28.2.el7.x86_64 #1 SMP Wed Aug 3 11:11:39 UTC 2016 x) | Any | Commit_order_manager can't terminate MTS worker properly when deadlock happens |
106953 | 2022-04-08 6:42 | 2022-06-14 8:27 | MySQL Server: Locking | Verified (854 days) | S3 | 5.7 | Linux | Any | LOCK_grant and LOCK_open can deadlock on a gtid slave |
4162 | 2004-06-16 11:44 | 2004-08-20 9:55 | MySQL Cluster: Cluster (NDB) storage engine | Closed (7361 days) | S2 | mysqlcluster-4.1.2-3.4.9-alpha-pc-linux- | Linux (Redhat AS) | Any | Node crashes when two instanses updates the same table and one of them aborts. |
11050 | 2005-06-02 18:07 | 2005-06-13 17:25 | MySQL Cluster: Cluster (NDB) storage engine | Closed (7064 days) | S3 | 5.1.0, 4.1, 5.0 | Linux (Linux) | Any | ndb_mgm "show" prints incorrectly after master data node fails |
18469 | 2006-03-23 19:14 | 2006-04-07 14:44 | MySQL Server | Closed (6766 days) | S3 | 5.0.19 | Linux (Linux 2.6.8-2-68) | Any | make test fails on information_schema |
19206 | 2006-04-19 22:02 | 2006-05-02 21:59 | MySQL Server: Documentation | Closed (6741 days) | S2 | 5.1 | Linux (Linux) | Any | Engine hangs trying to read from table that was locked for writing |
19815 | 2006-05-15 13:17 | 2006-06-10 15:44 | MySQL Server: Locking | Closed (6702 days) | S1 | 5.0.21 | Linux (Linux) | Any | CREATE/RENAME/DROP DATABASE can deadlock on a global read lock |
20857 | 2006-07-05 1:22 | 2007-05-15 16:42 | MySQL Server: InnoDB storage engine | Closed (6363 days) | S5 | 5.0.32-BK, 5.0.25-BK, 4.1.15 and 5.0.22 | Linux (Linux 2.6.15, Linux 2.6.12) | Any | Deadlocks detected by timeout (S L O W) |
23200 | 2006-10-12 8:18 | 2006-11-02 10:00 | MySQL Cluster: Cluster (NDB) storage engine | Closed (6557 days) | S2 | 4.1, 5.0, 5.1 | Linux (FC 5 / Suse 10.1) | Any | Cluster INSERT INTO .. ON DUPLICATE KEY UPDATE locks and memory leaks |
24148 | 2006-11-09 18:46 | 2007-01-31 19:31 | MySQL Server | Closed (6467 days) | S3 | 5.0.27 | Linux (Fedora Core 5) | Any | regression tests hang with SSL enabled |
25164 | 2006-12-19 8:04 | 2007-10-09 17:24 | MySQL Server: Locking | Closed (6216 days) | S3 | 4.1.21, 4.1BK | Linux (suse 9.3 x86) | Any | create table `a` as select * from `A` hangs |
31479 | 2007-10-09 13:10 | 2007-12-18 21:17 | MySQL Server: Locking | Closed (6146 days) | S2 | 5.0.38, 4.1, 5.0 BK | Linux | Any | Bad lock interaction if CREATE TABLE LIKE is killed |
33819 | 2008-01-11 13:00 | 2021-05-02 20:45 | MySQL Cluster: Cluster (NDB) storage engine | Verified (3925 days) | S3 | mysql-5.0 | Linux | Any | single PK-only query transactiosn fail with deadlock timeout on BLOB tables |
40661 | 2008-11-12 9:08 | 2009-01-09 15:15 | MySQL Server: Maria storage engine | Closed (5758 days) | S3 | 5.1-maria, 6.0-maria | Linux | Any | Maria: crash in embedded server (when detecting deadlock?) |
41399 | 2008-12-11 15:11 | 2009-11-13 16:01 | MySQL Server: Maria storage engine | Closed (5450 days) | S3 | 6.0-maria | Linux | Any | Maria: mutex deadlock detection warning LOCK_audit_mask LOCK_plugin |
48918 | 2009-11-19 18:26 | 2011-02-16 23:44 | Tools: MTR / mysql-test-run | Closed (5234 days) | S3 | 5.5.0-beta | Linux (SLES 9 RPM) | Any | MTR uses an un-initialized value in comparison |
59354 | 2011-01-07 15:07 | 2013-01-29 19:33 | MySQL Server: InnoDB storage engine | Closed (4277 days) | S3 | 5.5,mysql-trunk | Linux | Any | Assert !other_lock at lock_rec_add_to_queue during a delete operation |
110486 | 2023-03-24 5:25 | 2024-06-20 21:37 | MySQL Operator | Verified (560 days) | S1 | mysql/mysql-operator:8.0.32-2.0.8 | Linux | Any | MySQL operator not able to connect to k8s API server |
51105 | 2010-02-11 14:59 | 2011-02-16 23:44 | MySQL Server: Locking | Closed (5336 days) | S2 | mysql-next-4284 | Windows | Any | MDL deadlock in rqg_mdl_stability test on Windows |
53187 | 2010-04-27 8:01 | 2015-01-09 16:21 | Tools: Random Query Generator | Closed (3567 days) | S2 | Windows | Any | RQG sometimes reports false deadlocks on windows | |
7819 | 2005-01-11 20:07 | 2005-08-12 20:08 | MySQL Server: InnoDB storage engine | Closed (7004 days) | S3 | 4.0.22 | Windows (Windows, Linux) | Any | Please show full query in InnoDB status Last Deadlock |
18719 | 2006-04-02 22:02 | 2014-03-31 11:35 | Connector / J | Closed (3851 days) | S1 | 3.1.12 | Windows (Windows XP Pro) | Any | Deadlock |
78710 | 2015-10-05 22:53 | 2015-12-02 0:10 | Connector / J | Closed (3240 days) | S1 | 5.1.36 | Windows (7) | Any | Deadlock on ReplicationConnection and ReplicationConnectionGroup when failover. |
79617 | 2015-12-12 15:16 | 2019-12-12 20:36 | MySQL Server: Locking | Closed (1769 days) | S3 | 8.0.18 | Windows (10) | Any | Foreign key causing deadlock for UPDATE together with simple transaction |
5917 | 2004-10-06 9:11 | 2004-11-25 15:27 | MySQL Query Browser | Closed (7264 days) | S3 | 1.0.8 beta | Windows (WinNT 4) | Any | Edit mode deadlock after discarding changes |
33899 | 2008-01-17 16:28 | 2011-02-16 23:43 | MySQL Server: C API (client library) | Closed (5634 days) | S2 | 5.0.x/5.1 | Windows | Any | Deadlock in mysql_real_query with shared memory connections |
40044 | 2008-10-15 12:27 | 2009-01-08 10:42 | MySQL Server: Maria storage engine | Closed (5759 days) | S3 | 5.1-maria | Windows | Any | Maria: maria.test fails under Windows (lock wait timeout) |
40250 | 2008-10-22 13:56 | 2011-02-16 23:43 | Connector / NET | Closed (5723 days) | S2 | 5.2.3 | Windows | Any | Apparent deadlock in pooled connection |
43678 | 2009-03-16 15:08 | 2011-02-16 23:43 | Connector / NET | Closed (5544 days) | S1 | 5.2.5 | Windows | Any | Reading from a CompressedStream may result in deadlock |
46308 | 2009-07-20 13:36 | 2011-02-16 23:44 | Connector / NET | Closed (5550 days) | S2 | 6.0.4 | Windows (XP) | Any | LoadPacket stuck in loop |
106537 | 2022-02-22 13:56 | 2022-10-18 11:44 | MySQL Server: Group Replication | Closed (728 days) | S1 | 5.7.40 | Windows | Any | mysql innodb deadlock memory leak |
20512 | 2006-06-16 17:13 | 2006-10-24 17:35 | Connector / J | Closed (6566 days) | S1 | 3.1.12 | Solaris (Solaris 10 SPARC and x86) | Any | Using Hibernate, there's is a deadlock condition that's easily repeatable |
38748 | 2008-08-12 11:26 | 2009-01-09 13:58 | MySQL Server: Falcon storage engine | Closed (5758 days) | S3 | 6.0.6 | Solaris (Solaris 10 on x64) | Any | Deadlock in Falcon when running simple SELECT queries |
61577 | 2011-06-21 11:04 | 2011-06-30 14:09 | MySQL Server | Closed (4856 days) | S1 | 5.1 | Solaris | Any | APPARENT DEADLOCK!!! |
12526 | 2005-08-11 13:49 | 2005-09-30 8:38 | MySQL Server | Closed (6955 days) | S1 | 5.0.11 | Solaris (Solaris 9 (64 bit)) | Any | yassl: Crashes in "integer.cpp" |
40990 | 2008-11-24 18:52 | 2009-03-10 13:52 | MySQL Server: Maria storage engine | Closed (5698 days) | S3 | 5.1-maria,6.0-maria | Solaris (sparc64) | Any | Maria: failure of maria.test & maria_notemebedded in deadlock detection |
6665 | 2004-11-16 13:01 | 2013-05-30 12:14 | Connector / ODBC | Closed (4156 days) | S2 | 3.51.06 | Solaris (solaris 8) | Any | deadlock between odbc functions and transaction handling |
43958 | 2009-03-30 13:07 | 2009-05-15 16:10 | MySQL Server: Falcon storage engine | Closed (5632 days) | S1 | 6.0.11-bzr | Solaris (Solaris 10 x64) | Any | Assertion (transState != NULL) failed in Transaction::waitForTransaction |
95115 | 2019-04-24 17:16 | 2019-07-18 13:18 | MySQL Server: Replication | Closed (1916 days) | S1 | 5.7.24 | CentOS (CentOS Linux release 7.6.1810 (Core)) | x86 (x86_64, ELF 64-bit LSB shared object, x86-64, version 1 (SYSV), dynamically linked (uses shared libs) | mysqld deadlock of all client threads originating from 3-way deadlock |
78761 | 2015-10-08 15:36 | 2016-09-26 21:56 | MySQL Server: Locking | Closed (3116 days) | S2 | 5.6/5.7 | CentOS | Any | Unexpected deadlock with innodb_autoinc_lock_mode=0 |
98050 | 2019-12-23 8:13 | 2020-12-01 6:52 | MySQL Server: Clone Plugin | Verified (1470 days) | S2 | 8.0.18 | CentOS (7) | x86 | Deadlock on LOCK_global_system_variables, LOCK_plugin, LOCK_system_variables_has |
96224 | 2019-07-17 3:12 | 2022-06-16 3:01 | MySQL Server: InnoDB storage engine | Closed (1821 days) | S1 | 8.0.16 | CentOS | x86 | The MTR case innodb.innodb_corrupt_bit get a randomly coredump |
102556 | 2021-02-10 15:48 | 2021-04-06 12:18 | MySQL Server: Group Replication | Verified (1288 days) | S2 | 8.0.21 | CentOS (Release: 7.7.1908) | x86 (Intel(R) Xeon(R) CPU E5-2620 v4 @ 2.10GHz) | Apparent deadlock involving group replication applier threads |
89331 | 2018-01-20 0:36 | 2018-02-14 17:02 | MySQL Server: Replication | Closed (2435 days) | S2 | 8.0.3 | Red Hat | Any | Changing lock/release order in group commit causes a deadlock |
93761 | 2018-12-29 2:45 | 2019-03-20 7:38 | MySQL Server: Replication | Verified (2047 days) | S2 | 5.7.22 | Red Hat (6.5) | Any | optimize table cause the slave MTS deadlock! |
87855 | 2017-09-25 13:37 | 2018-04-11 13:58 | MySQL Server: InnoDB storage engine | Closed (2379 days) | S1 | 5.7.19,5.7.16 | SUSE (suse11sp3) | Any | INNODB PARTITION TABLE DEAD LOCK |
94699 | 2019-03-19 11:01 | 2019-05-09 13:03 | MySQL Server: InnoDB storage engine | Closed (2028 days) | S1 | 5.7 | Ubuntu | ARM | Mysql deadlock and bugcheck on aarch64 under stress test |
80814 | 2016-03-21 20:20 | 2016-03-28 7:56 | MySQL Server | Closed (3123 days) | S3 | 5.6.28-0ubuntu0.15.10.1 | Ubuntu | Any | internal deadlock occurs |
102502 | 2021-02-06 18:15 | 2021-10-11 13:22 | MySQL Cluster: Cluster (NDB) storage engine | Closed (1100 days) | S3 | 8.0.23 | Ubuntu | x86 | Deadlock timeout due to problem in REDO log queue handling |
114624 | 2024-04-11 13:37 | 2024-10-14 13:16 | MySQL Server: Group Replication | Verified (1 day) | S2 | 8.0.39 | Ubuntu (22.04) | x86 | Deadlock on primary replica when adding instance to replica cluster with writes |
91941 | 2018-08-09 4:27 | 2020-05-20 13:42 | MySQL Server: Logging | Closed (2212 days) | S2 | 5.7.23 | Ubuntu (16.04) | Any | Deadlock during purge_logs_before_date |
108881 | 2022-10-26 8:46 | 2022-10-28 11:04 | MySQL Server: Locking | Verified (718 days) | S3 | 8.0.31 | Ubuntu (22.04) | x86 (x86_64) | FLUSH TABLES deadlock |
3521 | 2004-04-21 1:00 | 2004-06-11 20:42 | MySQL Server | Closed (7431 days) | S3 | 4.1.1-alpha | Other (tru64unix 5.1A, native compiler) | Any | "make test" status |
Showing all 301 (Edit, Save, CSV, Feed) |