Debian Codegraph @

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

raw
1 --source include/galera_cluster.inc
2 --source include/have_innodb.inc
3
4 #
5 # Test that a local LOCK TABLE will NOT be broken by an incoming remote transaction against that table
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 LOCK TABLE t1 WRITE;
14
15 --connection node_1
16 INSERT INTO t1 VALUES (2);
17
18 --connection node_2
19 SET SESSION wsrep_sync_wait = 0;
20 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'system user' AND (STATE LIKE 'Waiting for table metadata lock%' OR STATE LIKE 'Waiting to execute in isolation%');
21 --let $wait_condition_on_error_output = SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST
22 --source include/wait_condition_with_debug.inc
23
24 UNLOCK TABLES;
25
26 --let $wait_condition = SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'system user' AND (STATE LIKE 'Waiting for table metadata lock%' OR STATE LIKE 'Waiting to execute in isolation%');
27 --let $wait_condition_on_error_output = SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST
28 --source include/wait_condition_with_debug.inc
29
30 COMMIT;
31 SELECT COUNT(*) = 1 FROM t1;
32
33 --let $wsrep_local_bf_aborts_after = `SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_bf_aborts'`
34
35 --disable_query_log
36 --eval SELECT $wsrep_local_bf_aborts_after - $wsrep_local_bf_aborts_before = 0 AS wsrep_local_aborts_increment;
37 --enable_query_log
38
39 DROP TABLE t1;