Debian Codegraph @

mysql-test/suite/galera/include/galera_concurrent_test.inc

raw
1 #
2 # Perform a quick concurrent test on two nodes using a set of predefined statements.
3 #
4 # Such tests are not deterministic, so we are hoping to catch assertions, slave apply errors
5 # and cases where the two nodes diverge
6 #
7 # Parameters:
8 # - $wsrep_trx_fragment_size
9 # - $count
10 # - $query_node_1
11 # - $query_node_1a (optional)
12 # - $query_node_2
13 #
14
15 if (!$count) {
16 --let $count = 50;
17 }
18
19 if (!$node_1a_connected) {
20 --connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1
21 --let $node_1a_connected = 1
22 }
23
24 --echo Running a concurrent test with the following queries:
25 --echo $query_node_1
26 --echo $query_node_1a
27 --echo $query_node_2
28
29 --connection node_1
30 --disable_warnings
31 DROP TABLE IF EXISTS t1;
32 --enable_warnings
33
34 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY AUTO_INCREMENT, f2 CHAR(255)) ENGINE=InnoDB;
35
36 SET SESSION wsrep_sync_wait = 0;
37 --eval SET SESSION wsrep_trx_fragment_size = $wsrep_trx_fragment_size;
38
39 --connection node_1a
40 SET SESSION wsrep_sync_wait = 0;
41 --eval SET SESSION wsrep_trx_fragment_size = $wsrep_trx_fragment_size;
42
43 --connection node_2
44 SET SESSION wsrep_sync_wait = 0;
45 --eval SET SESSION wsrep_trx_fragment_size = $wsrep_trx_fragment_size;
46
47 --disable_query_log
48 --let $i = `SELECT $count`
49 while ($i)
50 {
51 --connection node_1
52 --send_eval $query_node_1
53
54 --connection node_1a
55 if ($query_node_1a) {
56 --send_eval $query_node_1a
57 }
58
59 --connection node_2
60 --send_eval $query_node_2
61
62 --connection node_1
63 --error 0,ER_QUERY_INTERRUPTED,ER_LOCK_DEADLOCK,ER_DUP_ENTRY
64 --reap
65
66 --connection node_1a
67 if ($query_node_1a) {
68 --error 0,ER_QUERY_INTERRUPTED,ER_LOCK_DEADLOCK,ER_DUP_ENTRY
69 --reap
70 }
71
72 --connection node_2
73 --error 0,ER_QUERY_INTERRUPTED,ER_LOCK_DEADLOCK,ER_DUP_ENTRY
74 --reap
75 --dec $i
76 }
77
78 SET SESSION wsrep_sync_wait = 15;
79 --enable_query_log
80
81 --let $diff_servers = 1 2
82 --source include/diff_servers.inc
83
84 DROP TABLE t1;
85
86 --let $query_node_1 = ""
87 --let $query_node_1a = ""
88 --let $query_node_2 = ""
89
90 --echo Concurrent test end