Debian Codegraph @

mysql-test/suite/galera_sr/t/mysql-wsrep-features#96.test

raw
1 # mysql-wsrep-features#96 - "Sanity check failed" with SR and statement rolled back due to error
2
3 --source include/galera_cluster.inc
4 --source include/have_innodb.inc
5
6
7 --connection node_1
8
9 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY);
10 CREATE TABLE t2 (f2 VARCHAR(32));
11
12 SET SESSION wsrep_trx_fragment_size=1;
13 SET AUTOCOMMIT=OFF;
14 START TRANSACTION;
15 INSERT INTO t1 VALUES (1);
16
17 # This statement causes full transaction rollback
18 # rather than just statement rollback, as it is run under SR
19
20 --error ER_LOCK_DEADLOCK
21 INSERT INTO t1 VALUES (2),(1);
22 INSERT INTO t2 VALUES ('abc');
23
24 --connection node_2
25 SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
26
27 SELECT COUNT(*) = 0 FROM t1;
28 SELECT COUNT(*) = 1 FROM t2;
29
30 --connection node_1
31 ROLLBACK;
32
33 --connection node_2
34 SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
35
36 SELECT COUNT(*) = 0 FROM t1;
37 SELECT COUNT(*) = 0 FROM t2;
38
39 --connection node_1
40 DROP TABLE t1;
41 DROP TABLE t2;