Debian Codegraph @

mysql-test/suite/galera_sr/t/galera_sr_bf_abort_idle.test

raw
1 #
2 # Test BF abort for idle SR transactions
3 #
4
5 --source include/galera_cluster.inc
6
7 --connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1
8
9 #
10 # Case 1: BF abort idle SR transaction that has not yet replicated any fragments
11 #
12 --connection node_1
13 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY, f2 INTEGER);
14 INSERT INTO t1 VALUES (1,1),(2,1),(3,1),(4,1),(5,1),(6,1),(7,1),(8,1);
15
16 --let $bf_count = `SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.global_status WHERE VARIABLE_NAME = 'wsrep_local_bf_aborts'`
17
18 SET SESSION wsrep_trx_fragment_size=10;
19 SET SESSION wsrep_trx_fragment_unit='rows';
20 START TRANSACTION;
21 UPDATE t1 SET f2 = f2 + 10;
22
23 --connection node_2
24 INSERT INTO t1 VALUES (10,2);
25
26 # Wait for SR transaction to be BF aborted
27 --connection node_1a
28 --let $wait_condition = SELECT VARIABLE_VALUE = $bf_count + 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_bf_aborts'
29 --source include/wait_condition.inc
30
31
32 --connection node_1
33 --error ER_LOCK_DEADLOCK
34 INSERT INTO t1 VALUES (9,1);
35 ROLLBACK;
36
37 DROP TABLE t1;
38
39
40 #
41 # Case 2: BF abort idle SR transaction that has already replicated a fragment
42 #
43 --connection node_1
44 CREATE TABLE t1(f1 INTEGER PRIMARY KEY, f2 INTEGER);
45 INSERT INTO t1 VALUES (1,1),(2,1),(3,1),(4,1),(5,1),(6,1),(7,1),(8,1);
46
47 --let $bf_count = `SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.global_status WHERE VARIABLE_NAME = 'wsrep_local_bf_aborts'`
48
49
50 SET SESSION wsrep_trx_fragment_size=5;
51 SET SESSION wsrep_trx_fragment_unit='rows';
52 START TRANSACTION;
53 UPDATE t1 SET f2 = f2 + 10;
54
55 --connection node_2
56 INSERT INTO t1 VALUES (10,2);
57
58 # Wait for SR transaction to be BF aborted
59 --connection node_1a
60 --let $wait_condition = SELECT VARIABLE_VALUE = $bf_count + 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_bf_aborts'
61 --source include/wait_condition.inc
62
63 --connection node_1
64 --error ER_LOCK_DEADLOCK
65 INSERT INTO t1 VALUES (9,1);
66 ROLLBACK;
67
68 DROP TABLE t1;