Debian Codegraph @

mysql-test/suite/galera_sr/t/galera_sr_conflict_on_commit2.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 #1 begins a transaction that is SR replicated
8 # 2. Node #2 begins a conflicting transaction, hangs
9 # 3. Node #1 comits
10 # 4. Node #2 gets a dup key error
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_1
22 INSERT INTO t1 VALUES (1);
23 INSERT INTO t1 VALUES (2);
24 INSERT INTO t1 VALUES (3);
25 INSERT INTO t1 VALUES (4);
26 INSERT INTO t1 VALUES (5);
27
28 --connection node_2
29 --send INSERT INTO t1 VALUES (5);
30
31 --sleep 1
32
33 --connection node_1
34 COMMIT;
35
36 --connection node_2
37 --error ER_DUP_ENTRY
38 --reap
39
40 SELECT COUNT(*) = 5 FROM t1;
41
42 --connection node_2
43 SELECT COUNT(*) = 5 FROM t1;
44
45 --connection node_1
46 DROP TABLE t1;