Debian Codegraph @

mysql-test/suite/galera_sr/t/mysql-wsrep-features#165.test

raw
1 --source include/galera_cluster.inc
2 --source include/have_debug_sync.inc
3
4 #
5 # This test attempts to catch a race condition between autocommit
6 # transaction and transaction which is rolling back due to
7 # deadlock.
8 #
9 # Since it is trying to catch a race condition which may not reliably
10 # occur, several runs are necessary for certainty. Hence the body of
11 # the test was placed into the .inc file and sourced several times below
12 #
13 # Test outline:
14 # * Trx 1a makes updates
15 # * SR trx 1b writes a row 3, then makes updates
16 # * AC trx 1c will attempt to write row 3 and will wait for lock
17 # held by 1b
18 # * Sync point is set for 1b to delay SR rollback
19 # * SR trx 1b makes an update which makes it conflict with trx 1a
20 # * Slave shows BF - BF conflict and fails in applying write event
21
22 --connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1
23 --connect node_1b, 127.0.0.1, root, , test, $NODE_MYPORT_1
24 --connect node_1c, 127.0.0.1, root, , test, $NODE_MYPORT_1
25
26 --source mysql-wsrep-features#165.inc
27 --source mysql-wsrep-features#165.inc
28 --source mysql-wsrep-features#165.inc
29 --source mysql-wsrep-features#165.inc
30 --source mysql-wsrep-features#165.inc
31 --source mysql-wsrep-features#165.inc
32 --source mysql-wsrep-features#165.inc
33 --source mysql-wsrep-features#165.inc
34 --source mysql-wsrep-features#165.inc
35 --source mysql-wsrep-features#165.inc
36 --source mysql-wsrep-features#165.inc
37 --source mysql-wsrep-features#165.inc
38 --source mysql-wsrep-features#165.inc
39 --source mysql-wsrep-features#165.inc
40 --source mysql-wsrep-features#165.inc
41 --source mysql-wsrep-features#165.inc