Debian Codegraph @

mysql-test/suite/galera_sr/t/GCF-561.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(*) = 5 FROM t1;
24 --source include/wait_condition.inc
25
26 --let $wait_condition = SELECT COUNT(*) = 5 FROM mysql.wsrep_streaming_log;
27 --source include/wait_condition.inc
28 SELECT COUNT(*) AS EXPECT_5 FROM mysql.wsrep_streaming_log;
29
30 ALTER TABLE t1 DROP COLUMN f2;
31
32 # SR applied before the DDL is no longer visible
33 SELECT COUNT(*) AS EXPECT_0 FROM t1;
34 SELECT COUNT(*) AS EXPECT_0 FROM mysql.wsrep_streaming_log;
35
36 --connection node_1
37 # Transaction can not continue due to DDL, implicit ROLLBACK
38 --error ER_LOCK_DEADLOCK
39 INSERT INTO t1 VALUES (6, 6);
40
41 --let $wait_condition = SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
42 --source include/wait_condition.inc
43 SELECT COUNT(*) AS EXPECT_0 FROM mysql.wsrep_streaming_log;
44
45 # DDL is now in effect
46 --error ER_WRONG_VALUE_COUNT_ON_ROW
47 INSERT INTO t1 VALUES (6, 6);
48
49 # But it should be possible to reissue the transaction
50
51 START TRANSACTION;
52 INSERT INTO t1 VALUES (1);
53 INSERT INTO t1 VALUES (2);
54 INSERT INTO t1 VALUES (3);
55 INSERT INTO t1 VALUES (4);
56 INSERT INTO t1 VALUES (5);
57
58 --connection node_2
59 SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
60 --let $wait_condition = SELECT COUNT(*) = 5 FROM t1;
61 --source include/wait_condition.inc
62
63 --connection node_1
64 COMMIT;
65
66 --connection node_2
67 set global wsrep_sync_wait=15;
68 SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;
69 SELECT COUNT(*) AS EXPECT_5 FROM t1;
70 SELECT COUNT(*) AS EXPECT_0 FROM mysql.wsrep_streaming_log;
71
72 DROP TABLE t1;