Debian Codegraph @

mysql-test/suite/galera_sr/t/GCF-867.test

raw
1 #
2 # Test many ongoing SR transactions
3 #
4
5 --source include/galera_cluster.inc
6 --source include/have_innodb.inc
7
8 CREATE TABLE t1 (f1 INTEGER) Engine=InnoDB;
9 --disable_query_log
10
11 --let $connections = 62
12
13 --let $count = $connections
14 while ($count)
15 {
16 --connect $count, 127.0.0.1, root, , test, $NODE_MYPORT_1
17 SET SESSION wsrep_trx_fragment_size = 1;
18 SET SESSION wsrep_sync_wait = 0;
19 --dec $count
20 }
21
22
23 --let $count = $connections
24 while ($count)
25 {
26 --connection $count
27 START TRANSACTION;
28 --send_eval INSERT INTO t1 VALUES ($count)
29 --dec $count
30 }
31
32 --let $count = $connections
33 while ($count)
34 {
35 --connection $count
36 --reap
37 COMMIT;
38 --dec $count
39 }
40
41 --enable_query_log
42 DROP TABLE t1;