Debian Codegraph @

mysql-test/suite/galera/t/galera_bf_abort_get_lock.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 GET_LOCK()
6 #
7
8 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
9
10 --let $galera_connection_name = node_2a
11 --let $galera_server_number = 2
12 --source include/galera_connect.inc
13 --connection node_2a
14 SELECT GET_LOCK("foo", 1000);
15
16 --connection node_2
17 SET AUTOCOMMIT=OFF;
18 --let $wsrep_local_bf_aborts_before = `SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_bf_aborts'`
19 INSERT INTO t1 VALUES (1);
20 --send SELECT GET_LOCK("foo", 1000);
21
22 --connection node_1
23 INSERT INTO t1 VALUES (1);
24
25 --connection node_2
26 --error ER_LOCK_DEADLOCK
27 --reap
28
29 --let $wsrep_local_bf_aborts_after = `SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_bf_aborts'`
30
31 # Check that wsrep_local_bf_aborts has been incremented by exactly 1
32 --disable_query_log
33 --eval SELECT $wsrep_local_bf_aborts_after - $wsrep_local_bf_aborts_before = 1 AS wsrep_local_aborts_increment;
34 --enable_query_log
35
36 DROP TABLE t1;