Debian Codegraph @

mysql-test/suite/group_replication/t/gr_high_prio_rollback.test

raw
1 # This test conflict cases between local and remote transactions.
2 # This test proves the rollback mechanisms are working as intended
3
4 --source include/have_group_replication_plugin.inc
5 --source include/group_replication.inc
6
7 --echo #
8 --echo # Create the test table on server 1
9 --echo #
10
11 --let $rpl_connection_name= server1
12 --source include/rpl_connection.inc
13
14 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
15
16 --source include/rpl_sync.inc
17
18 --echo #
19 --echo # Test case 1 - error on commit
20 --echo # Start a transaction on server 1
21 --echo # Execute a concurrent transaction on server 2.
22 --echo # Try to commit the transaction on server 1, it should fail.
23 --echo #
24
25 --let $rpl_connection_name= server1
26 --source include/rpl_connection.inc
27
28 BEGIN;
29 INSERT INTO t1 VALUES (1);
30
31 --let $rpl_connection_name= server2
32 --source include/rpl_connection.inc
33
34 INSERT INTO t1 VALUES (1);
35
36 --source include/rpl_sync.inc
37
38 --let $rpl_connection_name= server1
39 --source include/rpl_connection.inc
40
41 --error ER_TRANSACTION_ROLLBACK_DURING_COMMIT, ER_ERROR_DURING_COMMIT
42 COMMIT;
43
44 --echo #
45 --echo # Test case 1 - error on commit
46 --echo # Check all is fine
47 --echo #
48
49 --let $rpl_connection_name= server1
50 --source include/rpl_connection.inc
51
52 INSERT INTO t1 VALUES (2);
53
54 --source include/rpl_sync.inc
55
56 --let $rpl_connection_name= server2
57 --source include/rpl_connection.inc
58
59 INSERT INTO t1 VALUES (3);
60
61 --source include/rpl_sync.inc
62
63 --let $rpl_connection_name= server1
64 --source include/rpl_connection.inc
65
66 --let $assert_text= On member1, the table t1 should contain 3 rows
67 --let $assert_cond= [SELECT COUNT(*) FROM t1] = 3;
68 --source include/assert.inc
69
70 --let $rpl_connection_name= server2
71 --source include/rpl_connection.inc
72
73 --let $assert_text= On member2, the table t1 should contain 3 rows
74 --let $assert_cond= [SELECT COUNT(*) FROM t1] = 3;
75 --source include/assert.inc
76
77 --echo #
78 --echo # Test case 2 - error on second insert
79 --echo # Start a transaction on server 1
80 --echo # Execute a concurrent transaction on server 2.
81 --echo # Try to execute another insert on server 1 transaction, it should fail.
82 --echo #
83
84 --let $rpl_connection_name= server1
85 --source include/rpl_connection.inc
86
87 BEGIN;
88 INSERT INTO t1 VALUES (11);
89
90 --let $rpl_connection_name= server2
91 --source include/rpl_connection.inc
92
93 INSERT INTO t1 VALUES (11);
94
95 --source include/rpl_sync.inc
96
97 --let $rpl_connection_name= server1
98 --source include/rpl_connection.inc
99
100 --error ER_TRANSACTION_ROLLBACK_DURING_COMMIT, ER_LOCK_DEADLOCK
101 INSERT INTO t1 VALUES (12);
102
103 COMMIT;
104
105 --echo #
106 --echo # Test case 2 - error on second insert
107 --echo # Check all is fine
108 --echo #
109
110 --let $rpl_connection_name= server1
111 --source include/rpl_connection.inc
112
113 --let $assert_text= On member1, the rolled back transaction is not there
114 --let $assert_cond= [SELECT COUNT(*) FROM t1 WHERE c1=12] = 0;
115 --source include/assert.inc
116
117 --let $rpl_connection_name= server2
118 --source include/rpl_connection.inc
119
120 --let $assert_text= On member2, the rolled back transaction is not there
121 --let $assert_cond= [SELECT COUNT(*) FROM t1 WHERE c1=12] = 0;
122 --source include/assert.inc
123
124 --let $rpl_connection_name= server1
125 --source include/rpl_connection.inc
126
127 INSERT INTO t1 VALUES (12);
128
129 --source include/rpl_sync.inc
130
131 --let $rpl_connection_name= server2
132 --source include/rpl_connection.inc
133
134 INSERT INTO t1 VALUES (13);
135
136 --source include/rpl_sync.inc
137
138 --let $rpl_connection_name= server1
139 --source include/rpl_connection.inc
140
141 --let $assert_text= On member1, the table t1 should contain 6 rows
142 --let $assert_cond= [SELECT COUNT(*) FROM t1] = 6;
143 --source include/assert.inc
144
145 --let $rpl_connection_name= server2
146 --source include/rpl_connection.inc
147
148 --let $assert_text= On member2, the table t1 should contain 6 rows
149 --let $assert_cond= [SELECT COUNT(*) FROM t1] = 6;
150 --source include/assert.inc
151
152 --echo #
153 --echo # Cleanup
154 --echo #
155
156 --let $rpl_connection_name= server1
157 --source include/rpl_connection.inc
158
159 DROP TABLE t1;
160
161 --source include/group_replication_end.inc