thread2:
|
SELECT `k` FROM oltp3 WHERE `id` BETWEEN _smallint_unsigned AND _smallint_unsigned ;
|
thread2_connect:
|
;
|
thread2_init:
|
;
|
thread1:
|
UPDATE IGNORE oltp3 SET `k` = `k` + 1 WHERE `id` = _smallint_unsigned |
|
UPDATE IGNORE oltp3 SET `k` = `k` + 1 WHERE `id` = _smallint_unsigned |
|
FLUSH TABLE oltp3 FOR EXPORT |
|
LOCK TABLE t9 WRITE ;
|
thread1_connect:
|
;
|
thread1_init:
|
;
|
|
Only two sessions are required.
|
The table oltp3 exists (id is PK, k is indexed) and contains 1000 rows.
|
The table t9 does not exist at all.
|
|
After around 60 - 90 seconds the DB server aborts with
|
# 2020-01-29T14:25:19 [124160] | DEADLOCK of threads detected!
|
# 2020-01-29T14:25:19 [124160] | rw-lock 0x7f89c005b090 --Thread 140230162839296 has waited at row0sel.cc line 3511 for 0.00 seconds the semaphore:
|
# 2020-01-29T14:25:19 [124160] | X-lock on RW-latch at 0x7f89c005b090 created in file buf0buf.cc line 1534
|
# 2020-01-29T14:25:19 [124160] | a writer (thread id 140229155460864) has reserved it in mode exclusive
|
# 2020-01-29T14:25:19 [124160] | number of readers 0, waiters flag 1, lock_word: 0
|
# 2020-01-29T14:25:19 [124160] | Last time write locked in file row0row.cc line 1300
|
# 2020-01-29T14:25:19 [124160] | Locked: thread 140229155460864 file row0row.cc line 1300 X-LOCK
|
# 2020-01-29T14:25:19 [124160] | Locked: thread 140229155460864 file row0row.cc line 1300 X-LOCK
|
# 2020-01-29T14:25:19 [124160] | rw-lock 0x7f8978079418 --Thread 140230163142400 has waited at row0quiesce.cc line 675 for 0.00 seconds the semaphore:
|
# 2020-01-29T14:25:19 [124160] | X-lock (wait_ex) on RW-latch at 0x7f8978079418 created in file dict0dict.cc line 2072
|
# 2020-01-29T14:25:19 [124160] | a writer (thread id 140230163142400) has reserved it in mode wait exclusive
|
# 2020-01-29T14:25:19 [124160] | number of readers 1, waiters flag 0, lock_word: ffffffff
|
# 2020-01-29T14:25:19 [124160] | Last time write locked in file btr0cur.cc line 1474
|
# 2020-01-29T14:25:19 [124160] | Locked: thread 140230162839296 file btr0cur.cc line 1506 S-LOCK
|
# 2020-01-29T14:25:19 [124160] | Locked: thread 140230162839296 file btr0cur.cc line 1506 S-LOCK
|
# 2020-01-29T14:25:19 [124160] | rw-lock 0x7f8978089578 --Thread 140229155460864 has waited at btr0cur.cc line 1506 for 0.00 seconds the semaphore:
|
# 2020-01-29T14:25:19 [124160] | S-lock on RW-latch at 0x7f8978089578 created in file dict0dict.cc line 2072
|
# 2020-01-29T14:25:19 [124160] | a writer (thread id 140230163142400) has reserved it in mode exclusive
|
# 2020-01-29T14:25:19 [124160] | number of readers 0, waiters flag 1, lock_word: 0
|
# 2020-01-29T14:25:19 [124160] | Last time write locked in file row0quiesce.cc line 675
|
# 2020-01-29T14:25:19 [124160] | Locked: thread 140230163142400 file row0quiesce.cc line 675 X-LOCK
|
# 2020-01-29T14:25:19 [124160] | 2020-01-29 14:24:51 0 [ERROR] [FATAL] InnoDB: ######################################## Deadlock Detected!
|
# 2020-01-29T14:25:19 [124160] | 200129 14:24:51 [ERROR] mysqld got signal 6 ;
|
|
Replay on actual 10.5 (2020-01-27) compiles with debug.
|
No replay or other issue on actual 10.4. or 10.5 compiled without debug.
|