Debian Codegraph @

mysql-test/suite/binlog/r/innodb_rc_insert_before_delete.result

raw
1 RESET MASTER;
2 connect pause_purge,localhost,root;
3 START TRANSACTION WITH CONSISTENT SNAPSHOT;
4 connection default;
5 CREATE TABLE t (pk int PRIMARY KEY, sk INT UNIQUE) ENGINE=InnoDB;
6 INSERT INTO t VALUES (10, 100);
7 connect con1,localhost,root;
8 BEGIN;
9 SELECT * FROM t WHERE sk = 100 FOR UPDATE;
10 pk sk
11 10 100
12 connect con2,localhost,root;
13 SET DEBUG_SYNC="lock_wait_start SIGNAL insert_wait_started";
14 INSERT INTO t VALUES (5, 100) # trx 1;
15 connect con3,localhost,root;
16 SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
17 SET DEBUG_SYNC="now WAIT_FOR insert_wait_started";
18 SET DEBUG_SYNC="lock_wait_start SIGNAL delete_started_waiting";
19 BEGIN;
20 UPDATE t SET sk = 200 WHERE sk = 100; # trx 2;
21 connection con1;
22 SET DEBUG_SYNC="now WAIT_FOR delete_started_waiting";
23 DELETE FROM t WHERE sk=100;
24 COMMIT;
25 disconnect con1;
26 connection con2;
27 disconnect con2;
28 connection con3;
29 must be logged in ROW format as the only event of trx 2 (con3)
30 INSERT INTO t VALUES (11, 101);
31 COMMIT;
32 include/show_binlog_events.inc
33 Log_name Pos Event_type Server_id End_log_pos Info
34 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
35 master-bin.000001 # Query # # use `test`; DELETE FROM t WHERE sk=100
36 master-bin.000001 # Xid # # COMMIT /* XID */
37 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
38 master-bin.000001 # Query # # use `test`; INSERT INTO t VALUES (5, 100) # trx 1
39 master-bin.000001 # Xid # # COMMIT /* XID */
40 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
41 master-bin.000001 # Annotate_rows # # INSERT INTO t VALUES (11, 101)
42 master-bin.000001 # Table_map # # table_id: # (test.t)
43 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
44 master-bin.000001 # Xid # # COMMIT /* XID */
45 disconnect con3;
46 connection default;
47 SELECT * FROM t;
48 pk sk
49 5 100
50 11 101
51 disconnect pause_purge;
52 SET DEBUG_SYNC="RESET";
53 DROP TABLE t;