| 1 |
--source include/have_innodb.inc |
| 2 |
--source include/count_sessions.inc |
| 3 |
source include/have_debug.inc; |
| 4 |
source include/have_debug_sync.inc; |
| 5 |
|
| 6 |
CREATE TABLE t (a int PRIMARY KEY, b int NOT NULL UNIQUE) engine = InnoDB, STATS_PERSISTENT=0; |
| 7 |
|
| 8 |
--source include/wait_all_purged.inc |
| 9 |
--connect(prevent_purge,localhost,root,,) |
| 10 |
start transaction with consistent snapshot; |
| 11 |
|
| 12 |
--connect(con_del_1,localhost,root,,) |
| 13 |
INSERT INTO t VALUES (20,20); |
| 14 |
SET DEBUG_SYNC = 'innodb_row_search_for_mysql_exit SIGNAL first_del_row_search_mvcc_finished WAIT_FOR first_del_cont'; |
| 15 |
--send DELETE FROM t WHERE b = 20 # trx_1 |
| 16 |
|
| 17 |
--connect(con_ins_1,localhost,root,,) |
| 18 |
SET DEBUG_SYNC = 'now WAIT_FOR first_del_row_search_mvcc_finished'; |
| 19 |
# It's supposed the following INSERT will be suspended just after |
| 20 |
# lock_wait_start syncpoint, and will be awaken |
| 21 |
# after trx_1 DELETE commits. ib_after_row_insert will be executed |
| 22 |
# after the trx_2 INSERT is woken up. The trx_1 DELETE will wait for |
| 23 |
# first_del_cont signal before commit, and this signal will be sent later. |
| 24 |
# So it's safe to use two signals in a row here, it's guaranted the first |
| 25 |
# signal will be received before the second signal is sent. |
| 26 |
SET DEBUG_SYNC = 'lock_wait_start SIGNAL first_ins_locked'; |
| 27 |
SET DEBUG_SYNC = 'ib_after_row_insert SIGNAL first_ins_row_inserted WAIT_FOR first_ins_cont'; |
| 28 |
--send INSERT INTO t VALUES(10, 20) # trx_2 |
| 29 |
|
| 30 |
--connect(con_del_2,localhost,root,,) |
| 31 |
# After MDEV-30225 is fixed, the following DELETE creates next-key lock for |
| 32 |
# unqique search for RR, and the above INSERT kills it as deadlock victim. |
| 33 |
# But it still requests not-gap lock for RC. |
| 34 |
SET TRANSACTION ISOLATION LEVEL READ COMMITTED; |
| 35 |
SET DEBUG_SYNC = 'now WAIT_FOR first_ins_locked'; |
| 36 |
SET DEBUG_SYNC = 'lock_wait_start SIGNAL second_del_locked'; |
| 37 |
############################################################################## |
| 38 |
# trx_3 DELETE is locked by trx_1 DELETE, after trx_1 DELETE is |
| 39 |
# committed, it will still be locked by trx_2 INSERT on delete-marked |
| 40 |
# heap_no 2 record. After trx_2 INSERT inserted the record with heap_no 3, |
| 41 |
# and after heap_no 2 record is purged, trx_3 DELETE will be unlocked and |
| 42 |
# must restore persistent cursor position at heap_no 3 record, as it has the |
| 43 |
# same secondary key value as former heap_no 2 record. Then it must be blocked |
| 44 |
# by trx_2 INSERT, and after trx_2 INSERT is committed, it must |
| 45 |
# delete the record, inserted by trx_2 INSERT, and trx_4 INSERT(see |
| 46 |
# below) must be finished without error. But instead this DELETE restores |
| 47 |
# persistent cursor position to supremum, as a result, it does not delete the |
| 48 |
# record, inserted by trx_2 INSERT, and trx_4 INSERT is finished with |
| 49 |
# duplicate key check error. |
| 50 |
############################################################################### |
| 51 |
--send DELETE FROM t WHERE b = 20 # trx_3 |
| 52 |
|
| 53 |
--connection default |
| 54 |
SET DEBUG_SYNC = 'now WAIT_FOR second_del_locked'; |
| 55 |
SET @saved_dbug = @@GLOBAL.debug_dbug; |
| 56 |
SET @@GLOBAL.debug_dbug="d,enable_row_purge_del_mark_exit_sync_point"; |
| 57 |
SET DEBUG_SYNC = 'now SIGNAL first_del_cont'; |
| 58 |
SET DEBUG_SYNC = 'now WAIT_FOR first_ins_row_inserted'; |
| 59 |
--connection con_del_1 |
| 60 |
--reap |
| 61 |
|
| 62 |
--connection default |
| 63 |
--disconnect prevent_purge |
| 64 |
SET DEBUG_SYNC = 'now WAIT_FOR row_purge_del_mark_finished'; |
| 65 |
SET @@GLOBAL.debug_dbug = @saved_dbug; |
| 66 |
SET DEBUG_SYNC = 'now SIGNAL first_ins_cont'; |
| 67 |
|
| 68 |
--connection con_del_2 |
| 69 |
--reap |
| 70 |
|
| 71 |
--connection con_ins_1 |
| 72 |
--reap |
| 73 |
|
| 74 |
--connection default |
| 75 |
############################################################################### |
| 76 |
# Duplicate key error is expected if the bug is not fixed. |
| 77 |
############################################################################### |
| 78 |
INSERT INTO t VALUES(30, 20); # trx_4 |
| 79 |
|
| 80 |
--disconnect con_ins_1 |
| 81 |
--disconnect con_del_1 |
| 82 |
--disconnect con_del_2 |
| 83 |
--connection default |
| 84 |
|
| 85 |
SET DEBUG_SYNC = 'RESET'; |
| 86 |
DROP TABLE t; |
| 87 |
--source include/wait_until_count_sessions.inc |