Debian Codegraph @

mysql-test/suite/galera_sr/t/galera-features#56.test

raw
1 ##
2 ## This test tests parallel application of multiple auto-increment insert transactions
3 ##
4
5 --source include/galera_cluster.inc
6
7 # Create a second connection to node1 so that we can run transactions concurrently
8 --let $galera_connection_name = node_1a
9 --let $galera_server_number = 1
10 --source include/galera_connect.inc
11 SET SESSION wsrep_trx_fragment_size = 1;
12
13 --connection node_1
14 CREATE TABLE ten (f1 INTEGER NOT NULL PRIMARY KEY) Engine=InnoDB;
15 INSERT INTO ten VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);
16
17 CREATE TABLE t1 (f1 INTEGER AUTO_INCREMENT PRIMARY KEY, f2 INTEGER) Engine=InnoDB;
18 SET SESSION wsrep_trx_fragment_size = 1;
19
20 --connection node_2
21 set session wsrep_sync_wait=15;
22 SELECT COUNT(*) from ten;
23 SELECT COUNT(*) from t1;
24 set session wsrep_sync_wait=0;
25
26 --let $wsrep_slave_threads_orig = `SELECT @@wsrep_slave_threads`
27 SET GLOBAL wsrep_slave_threads = 4;
28
29 --let $wait_condition = SELECT COUNT(*) >= 3 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'system user' AND STATE = 'wsrep applier idle';
30 --source include/wait_condition.inc
31
32 SET SESSION wsrep_trx_fragment_size = 1;
33
34 --connection node_1
35 --send INSERT INTO t1 (f2) SELECT 1 FROM ten AS a1, ten AS a2;
36
37 --connection node_1a
38 --send INSERT INTO t1 (f2) SELECT 1 FROM ten AS a1, ten AS a2;
39
40 --connection node_2
41 --send INSERT INTO t1 (f2) SELECT 1 FROM ten AS a1, ten AS a2;
42
43 --connection node_1
44 --reap
45
46 --connection node_1a
47 --reap
48
49 --connection node_2
50 --reap
51
52 set session wsrep_sync_wait=15;
53 SELECT COUNT(*) FROM t1;
54 SELECT COUNT(DISTINCT f1) FROM t1;
55
56 --disable_query_log
57 --eval SET GLOBAL wsrep_slave_threads = $wsrep_slave_threads_orig;
58 --enable_query_log
59
60 --connection default
61 DROP TABLE t1;
62 DROP TABLE ten;