Debian Codegraph @

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

raw
1 --source include/galera_cluster.inc
2 --source include/have_innodb.inc
3
4 #
5 # Test two concurrent SR-replicated transactions
6 #
7
8 --connection node_1
9 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
10 CREATE TABLE t2 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
11
12 --let $wsrep_trx_fragment_size_orig = `SELECT @@wsrep_trx_fragment_size`
13 SET SESSION wsrep_trx_fragment_size = 1;
14 SET AUTOCOMMIT=OFF;
15 START TRANSACTION;
16 INSERT INTO t1 VALUES (1);
17 INSERT INTO t1 VALUES (2);
18 INSERT INTO t1 VALUES (3);
19 INSERT INTO t1 VALUES (4);
20 INSERT INTO t1 VALUES (5);
21
22 --connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1
23 SET SESSION wsrep_trx_fragment_size = 1;
24 SET AUTOCOMMIT=OFF;
25 START TRANSACTION;
26 INSERT INTO t2 VALUES (1);
27 INSERT INTO t2 VALUES (2);
28 INSERT INTO t2 VALUES (3);
29 INSERT INTO t2 VALUES (4);
30 INSERT INTO t2 VALUES (5);
31
32 --connection node_1
33 COMMIT;
34
35 --connection node_1a
36 COMMIT;
37
38 --connection node_2
39 SELECT COUNT(*) = 5 FROM t1;
40 SELECT COUNT(*) = 5 FROM t2;
41
42 --connection node_1
43
44 DROP TABLE t1;
45 DROP TABLE t2;