Debian Codegraph @

mysql-test/suite/galera/t/galera_bf_abort_ps.test

raw
1 #
2 # MDEV-24255
3 # Test BF abort of a transaction that has ps-protocol enabled
4 #
5
6 --source include/galera_cluster.inc
7
8 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY, f2 CHAR(6)) ENGINE=InnoDB;
9 --connect node_2a, 127.0.0.1, root, , test, $NODE_MYPORT_2
10
11 --connection node_2
12 --let $wsrep_local_bf_aborts_before = `SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_bf_aborts'`
13
14 START TRANSACTION;
15 INSERT INTO t1 VALUES (1,'node_2');
16
17 --connection node_1
18 INSERT INTO t1 VALUES (1,'node_1');
19
20 --connection node_2a
21 --let $wait_condition = SELECT COUNT(*) = 1 FROM t1 WHERE f2 = 'node_1'
22 --source include/wait_condition.inc
23
24 --connection node_2
25 --error ER_LOCK_DEADLOCK
26 INSERT INTO t1 VALUES (2, 'node_2');
27
28 --let $wsrep_local_bf_aborts_after = `SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_bf_aborts'`
29
30 --disable_query_log
31 --eval SELECT $wsrep_local_bf_aborts_after - $wsrep_local_bf_aborts_before = 1 AS wsrep_local_aborts_increment;
32 --enable_query_log
33
34 DROP TABLE t1;