Debian Codegraph @

mysql-test/suite/galera_sr/t/GCF-571.test

raw
1 #
2 # GCF-571 ROLLBACK TO SAVEPOINT causes all SR records to be deleted
3 #
4
5 --source include/galera_cluster.inc
6
7 SET AUTOCOMMIT=OFF;
8 CREATE TABLE t1 (f1 VARCHAR(10)) ENGINE=InnoDB;
9
10 SET SESSION wsrep_trx_fragment_size = 1;
11 START TRANSACTION;
12 INSERT INTO t1 VALUES ('%abcdef%');
13 INSERT INTO t1 VALUES ('%abcdef%');
14 INSERT INTO t1 VALUES ('%abcdef%');
15 INSERT INTO t1 VALUES ('%abcdef%');
16 SAVEPOINT A;
17 INSERT INTO t1 VALUES ('xyzxyz');
18 INSERT INTO t1 VALUES ('xyzxyz');
19 INSERT INTO t1 VALUES ('xyzxyz');
20 INSERT INTO t1 VALUES ('xyzxyz');
21 INSERT INTO t1 VALUES ('xyzxyz');
22
23 --connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1
24 --connection node_1a
25 SELECT COUNT(*) > 0 FROM mysql.wsrep_streaming_log WHERE frag LIKE '%abcdef%';
26 SELECT COUNT(*) > 0 FROM mysql.wsrep_streaming_log WHERE frag LIKE '%xyz%';
27 SELECT COUNT(*) = 1 FROM mysql.wsrep_streaming_log WHERE frag LIKE '%SAVEPOINT `A`%';
28
29 --connection node_1
30 ROLLBACK TO SAVEPOINT A;
31
32 --connection node_1a
33 SELECT COUNT(*) > 0 FROM mysql.wsrep_streaming_log WHERE frag LIKE '%abcdef%';
34 SELECT COUNT(*) > 0 FROM mysql.wsrep_streaming_log WHERE frag LIKE '%xyz%';
35 SELECT COUNT(*) = 1 FROM mysql.wsrep_streaming_log WHERE frag LIKE '%SAVEPOINT `A`%';
36 SELECT COUNT(*) = 1 FROM mysql.wsrep_streaming_log WHERE frag LIKE '%ROLLBACK TO `A`%';
37
38 --connection node_2
39 SELECT COUNT(*) > 0 FROM mysql.wsrep_streaming_log WHERE frag LIKE '%abcdef%';
40 SELECT COUNT(*) > 0 FROM mysql.wsrep_streaming_log WHERE frag LIKE '%xyz%';
41 SELECT COUNT(*) = 1 FROM mysql.wsrep_streaming_log WHERE frag LIKE '%SAVEPOINT `A`%';
42 SELECT COUNT(*) = 1 FROM mysql.wsrep_streaming_log WHERE frag LIKE '%ROLLBACK TO `A`%';
43
44 --connection node_1
45 ROLLBACK;
46
47 --connection node_1a
48 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
49
50 --connection node_2
51 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
52
53 --connection node_1
54 DROP TABLE t1;