Debian Codegraph @

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

raw
1 --source include/galera_cluster.inc
2 --source include/have_innodb.inc
3
4 #
5 # Test the following sequence of events:
6 #
7 # 1. Node #2 begins a transaction
8 # 2. Node #1 begins conflicting transaction that is SR replicated
9 # 3. Node #1 rolls back
10 # 4. Node #2 can not commit because it was BF-aborted even though the SR transaction was rolled back
11 #
12
13 --connection node_1
14 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY AUTO_INCREMENT) ENGINE=InnoDB;
15
16 SET SESSION wsrep_trx_fragment_size = 1;
17
18 SET AUTOCOMMIT=OFF;
19 START TRANSACTION;
20
21 --connection node_2
22 SET AUTOCOMMIT=OFF;
23 START TRANSACTION;
24
25 INSERT INTO t1 VALUES (1);
26
27 --connection node_1
28 INSERT INTO t1 VALUES (1);
29 INSERT INTO t1 VALUES (2);
30 INSERT INTO t1 VALUES (3);
31 INSERT INTO t1 VALUES (4);
32 INSERT INTO t1 VALUES (5);
33 ROLLBACK;
34
35 --connection node_2
36 --error ER_LOCK_DEADLOCK
37 COMMIT;
38
39 SELECT COUNT(*) = 0 FROM t1;
40
41 --connection node_1
42 SELECT COUNT(*) = 0 FROM t1;
43
44 DROP TABLE t1;