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