Debian Codegraph @

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

raw
1 --source include/galera_cluster.inc
2 --source include/have_innodb.inc
3
4 #
5 # A local transaction running FLUSH TABLES WITH READ LOCK will not be aborted by a slave transaction
6 #
7
8 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
9
10 --connection node_2
11 SET AUTOCOMMIT=OFF;
12 --let $wsrep_local_bf_aborts_before = `SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_bf_aborts'`
13 --send FLUSH TABLES WITH READ LOCK;
14
15 --connection node_1
16 INSERT INTO t1 VALUES (1);
17
18 --connection node_2
19 --reap
20
21 UNLOCK TABLES;
22
23 --let $wsrep_local_bf_aborts_after = `SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_bf_aborts'`
24
25 # No aborts should be registered on the counter
26 --disable_query_log
27 --eval SELECT $wsrep_local_bf_aborts_after - $wsrep_local_bf_aborts_before = 0 AS wsrep_local_aborts_increment;
28 --enable_query_log
29
30 DROP TABLE t1;