Debian Codegraph @

mysql-test/suite/galera_sr/t/galera_sr_ddl_slave.test

raw
1 --source include/galera_cluster.inc
2 --source include/have_innodb.inc
3
4 #
5 # Test the effect of DDL on a concurrent SR transaction
6 #
7
8 --connection node_1
9 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY, f2 INTEGER) ENGINE=InnoDB;
10 SET SESSION wsrep_trx_fragment_size = 1;
11
12 SET AUTOCOMMIT=OFF;
13 START TRANSACTION;
14
15 INSERT INTO t1 VALUES (1, 1);
16 INSERT INTO t1 VALUES (2, 2);
17 INSERT INTO t1 VALUES (3, 3);
18 INSERT INTO t1 VALUES (4, 4);
19 INSERT INTO t1 VALUES (5, 5);
20
21 --connection node_2
22 SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
23 --let $wait_condition = SELECT COUNT(*) > 0 FROM t1;
24 --source include/wait_condition.inc
25 SELECT COUNT(*) > 0 FROM mysql.wsrep_streaming_log;
26
27 ALTER TABLE t1 DROP COLUMN f2;
28
29 # SR applied before the DDL is no longer visible
30 SELECT COUNT(*) = 0 FROM t1;
31 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
32
33 --connection node_1
34 # Transaction can not continue due to DDL, implicit ROLLBACK
35 --error ER_LOCK_DEADLOCK
36 INSERT INTO t1 VALUES (6, 6);
37
38 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
39
40 # DDL is now in effect
41 --error ER_WRONG_VALUE_COUNT_ON_ROW
42 INSERT INTO t1 VALUES (6, 6);
43
44 # But it should be possible to reissue the transaction
45
46 START TRANSACTION;
47 INSERT INTO t1 VALUES (1);
48 INSERT INTO t1 VALUES (2);
49 INSERT INTO t1 VALUES (3);
50 INSERT INTO t1 VALUES (4);
51 INSERT INTO t1 VALUES (5);
52
53 --connection node_2
54 SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
55 --let $wait_condition = SELECT COUNT(*) > 0 FROM t1;
56 --source include/wait_condition.inc
57
58 --connection node_1
59 COMMIT;
60
61 --connection node_2
62 SELECT COUNT(*) = 5 FROM t1;
63 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
64
65 DROP TABLE t1;