Debian Codegraph @

mysql-test/suite/innodb/t/high_prio_trx_rpl.test

raw
1 # Scenario: High prio setup with replication.
2 # T1 and T2 run on master.
3 # T1= ({R(B), W(B)}, )
4 # T2= ({R(B), W(B), C}, HIGH PRIORITY)
5 #
6 # Outcome: T2 completes and T1 abort.T2 is replicated to slave.
7
8 --source include/master-slave.inc
9 --source include/count_sessions.inc
10
11 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
12 INSERT INTO t1 VALUES (0);
13
14 --connect(con1, localhost,root,,test,$MASTER_MYPORT)
15
16 --echo
17 --echo # On connection master
18 --connection master
19 START TRANSACTION;
20 UPDATE t1 SET c1=1 WHERE c1=0;
21
22 --echo
23 --echo # On connection con1
24 --connection con1
25 --source include/start_transaction_high_prio.inc
26 UPDATE t1 SET c1=2 WHERE c1=0;
27 COMMIT;
28
29 --echo
30 --echo # On connection master
31 --connection master
32 --error ER_ERROR_DURING_COMMIT
33 COMMIT;
34
35 --echo # Row with value 2 is expected on master.
36 SELECT * FROM t1;
37
38 --source include/sync_slave_sql_with_master.inc
39 -- connection slave
40 --echo # Row with value 2 is expected on slave.
41 SELECT * FROM t1;
42
43 --echo #
44 --echo # Bug#23021168 REPLICATION STOPS AFTER TRANSACTION IS ROLLED BACK
45 --echo # ASYNCHRONOUSLY IN MASTER
46 --echo #
47
48 --echo
49 --echo # On connection master
50 --connection master
51 START TRANSACTION;
52 INSERT INTO t1 VALUES (1);
53
54 --echo
55 --echo # On connection con1
56 --connection con1
57 --source include/start_transaction_high_prio.inc
58 INSERT INTO t1 VALUES (1);
59 COMMIT;
60 SELECT * FROM t1 ORDER BY c1;
61
62 --echo
63 --echo # On connection master
64 --connection master
65 --error ER_LOCK_DEADLOCK
66 INSERT INTO t1 VALUES (3); ## This will hit ER_LOCK_DEADLOCK
67 INSERT INTO t1 VALUES (4); ## This will succeed.
68 COMMIT;
69
70 --source include/sync_slave_sql_with_master.inc
71 -- connection slave
72 --echo # Rows 1, 2, 3 & 4 is expected on slave.
73 SELECT * FROM t1 ORDER BY c1;
74
75 --disconnect con1
76 --echo
77 --echo # On connection master
78 -- connection master
79 DROP TABLE t1;
80 --source include/wait_until_count_sessions.inc
81 --source include/sync_slave_sql_with_master.inc
82 --source include/rpl_end.inc