Debian Codegraph @

mysql-test/suite/galera/t/galera_parallel_autoinc_largetrx.test

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