Debian Codegraph @

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

raw
1 --source include/galera_cluster.inc
2 --source include/have_innodb.inc
3
4 #
5 # Test a local transaction being aborted by a slave one while it is running a SLEEP()
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 INSERT INTO t1 VALUES (1);
14 --send SELECT SLEEP(1000);
15
16 --connection node_1
17 INSERT INTO t1 VALUES (1);
18
19 --connection node_2
20 --error ER_LOCK_DEADLOCK
21 --reap
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 # Check that wsrep_local_bf_aborts has been incremented by exactly 1
26 --disable_query_log
27 --eval SELECT $wsrep_local_bf_aborts_after - $wsrep_local_bf_aborts_before = 1 AS wsrep_local_aborts_increment;
28 --enable_query_log
29
30 DROP TABLE t1;