Debian Codegraph @

mysql-test/suite/galera_sr/t/mysql-wsrep#215.test

raw
1 --source include/galera_cluster.inc
2 --source include/have_innodb.inc
3 --source include/have_debug_sync.inc
4
5 #
6 # Test the following sequence of events:
7 #
8 # 1. Node #1 begins a transaction
9 # 2. Node #2 performs a conflicting insert
10 # 3. Node #1 attempts to SR-replicate a conflicting transaction
11 #
12
13 # to sync node_1 appliers
14 --connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1
15
16 --connection node_1
17 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY AUTO_INCREMENT) ENGINE=InnoDB;
18 SET SESSION wsrep_trx_fragment_size = 2;
19 SET SESSION wsrep_trx_fragment_unit = 'statements';
20 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
21 --let $expected_cert_failures = `SELECT VARIABLE_VALUE + 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_cert_failures'`
22
23 SET AUTOCOMMIT=OFF;
24 START TRANSACTION;
25
26 --connection node_1a
27 SET GLOBAL DEBUG_DBUG = 'd,sync.wsrep_apply_cb';
28 SET SESSION wsrep_sync_wait = 0;
29
30 --connection node_2
31 INSERT INTO t1 VALUES (1);
32
33 --connection node_1a
34 SET SESSION debug_sync = "now WAIT_FOR sync.wsrep_apply_cb_reached";
35 SELECT COUNT(*) = 0 FROM t1;
36
37 --connection node_1
38 SELECT COUNT(*) = 0 FROM t1;
39 --send INSERT INTO t1 VALUES (1);
40
41 --connection node_1a
42 # Wait for the above INSERT to fail certification
43 --connection node_1a
44 --let $wait_condition = SELECT VARIABLE_VALUE = $expected_cert_failures FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_cert_failures'
45 --source include/wait_condition.inc
46
47 SET GLOBAL DEBUG_DBUG = '';
48 SET DEBUG_SYNC='now SIGNAL signal.wsrep_apply_cb';
49
50 --connection node_1
51 --error ER_LOCK_DEADLOCK
52 --reap
53
54 COMMIT;
55
56 SELECT COUNT(*) = 1 FROM t1;
57 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
58
59 --connection node_2
60 SELECT COUNT(*) = 1 FROM t1;
61 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
62
63 --connection node_1a
64 SET DEBUG_SYNC = 'RESET';
65
66 #
67 # Similar test with BYTES unit
68 #
69 --connection node_1
70 TRUNCATE TABLE t1;
71
72 SET SESSION wsrep_trx_fragment_size = 10;
73 SET SESSION wsrep_trx_fragment_unit = 'bytes';
74 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
75 --let $expected_cert_failures = `SELECT VARIABLE_VALUE + 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_cert_failures'`
76
77 SET AUTOCOMMIT=OFF;
78 START TRANSACTION;
79
80 --connection node_1a
81 SET GLOBAL DEBUG_DBUG = 'd,sync.wsrep_apply_cb';
82 SET SESSION wsrep_sync_wait = 0;
83
84 --connection node_2
85 INSERT INTO t1 VALUES (1);
86
87 --connection node_1a
88 SET SESSION debug_sync = "now WAIT_FOR sync.wsrep_apply_cb_reached";
89 SELECT COUNT(*) = 0 FROM t1;
90
91 --connection node_1
92 SELECT COUNT(*) = 0 FROM t1;
93 --send INSERT INTO t1 VALUES (1)
94
95 # Wait for the above INSERT to fail certification
96 --connection node_1a
97 --let $wait_condition = SELECT VARIABLE_VALUE = $expected_cert_failures FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_cert_failures'
98 --source include/wait_condition.inc
99
100 SET GLOBAL DEBUG_DBUG = '';
101 SET DEBUG_SYNC='now SIGNAL signal.wsrep_apply_cb';
102
103 --connection node_1
104 --error ER_LOCK_DEADLOCK
105 --reap
106 ROLLBACK;
107
108 SELECT * FROM t1;
109 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
110
111 --connection node_2
112 SELECT * FROM t1;
113 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
114
115 --connection node_1a
116 SET DEBUG_SYNC = 'RESET';
117
118 #
119 # One more test with BYTES unit, but now fragment size is adjusted so
120 # that second insert should trigger fragment replication.
121 # Currently 200 bytes is good choice here, but this may change with
122 # future MySQL versions.
123 # => If this test fails after some MySQL merge, check if frgament size
124 # needs to be tuned to spot at second insert statement.
125 #
126 --connection node_1
127 TRUNCATE TABLE t1;
128
129 SET SESSION wsrep_trx_fragment_size = 200;
130 SET SESSION wsrep_trx_fragment_unit = 'bytes';
131 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
132 --let $expected_cert_failures = `SELECT VARIABLE_VALUE + 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_cert_failures'`
133
134 SET AUTOCOMMIT=OFF;
135 START TRANSACTION;
136
137 --connection node_1a
138 SET GLOBAL DEBUG_DBUG = 'd,sync.wsrep_apply_cb';
139 SET SESSION wsrep_sync_wait = 0;
140
141 --connection node_2
142 INSERT INTO t1 VALUES (1);
143
144 --connection node_1a
145 SET SESSION debug_sync = "now WAIT_FOR sync.wsrep_apply_cb_reached";
146 SELECT COUNT(*) = 0 FROM t1;
147
148 --connection node_1
149 INSERT INTO t1 VALUES (1);
150 --send INSERT INTO t1 VALUES (2)
151
152 # Wait for the above INSERT to fail certification
153 --connection node_1a
154 --let $wait_condition = SELECT VARIABLE_VALUE = $expected_cert_failures FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_cert_failures'
155 --source include/wait_condition.inc
156
157 SET GLOBAL DEBUG_DBUG = '';
158 SET DEBUG_SYNC='now SIGNAL signal.wsrep_apply_cb';
159
160 --connection node_1
161 --error ER_LOCK_DEADLOCK
162 --reap
163 COMMIT;
164
165 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
166
167 --connection node_2
168 SELECT COUNT(*) = 1 FROM t1;
169 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
170
171 --connection node_1a
172 DROP TABLE t1;
173 SET DEBUG_SYNC = 'RESET';
174
175 --connection node_2
176 CALL mtr.add_suppression("WSREP: Could not find applier context for");