| 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 |