Debian Codegraph @

mysql-test/suite/galera_sr/t/galera_sr_conflict_on_commit.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 #2 attempts to commit, gets a deadlock error, even before #1 has committed
10 #
11
12 --connection node_1
13 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY AUTO_INCREMENT) ENGINE=InnoDB;
14 SET SESSION wsrep_trx_fragment_size = 1;
15
16 SET AUTOCOMMIT=OFF;
17 START TRANSACTION;
18
19 --connection node_2
20 SET AUTOCOMMIT=OFF;
21 START TRANSACTION;
22
23 INSERT INTO t1 VALUES (1);
24
25 --connection node_1
26 INSERT INTO t1 VALUES (1);
27 INSERT INTO t1 VALUES (2);
28 INSERT INTO t1 VALUES (3);
29 INSERT INTO t1 VALUES (4);
30 INSERT INTO t1 VALUES (5);
31
32 --connection node_2
33 --error ER_LOCK_DEADLOCK
34 COMMIT;
35
36 --connection node_1
37 COMMIT;
38
39 SELECT COUNT(*) = 5 FROM t1;
40
41 --connection node_2
42 SELECT COUNT(*) = 5 FROM t1;
43
44 --connection node_1
45 DROP TABLE t1;