Debian Codegraph @

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

raw
1 #
2 # MDEV-24255
3 # Test BF abort of a transaction that has ps-protocol enabled
4 # This test stresses the case where wsrep_before_command()
5 # finds the transaction in state s_must_abort. This only
6 # possible when the server is using the thread pool.
7 #
8
9 --source include/galera_cluster.inc
10 --source include/have_debug_sync.inc
11
12 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY, f2 CHAR(6)) ENGINE=InnoDB;
13
14 --connect node_2a, 127.0.0.1, root, , test, $NODE_MYPORT_2
15
16 --connection node_2
17 --let $wsrep_local_bf_aborts_before = `SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_bf_aborts'`
18
19 START TRANSACTION;
20 INSERT INTO t1 VALUES (1,'node_2');
21
22 --connection node_2a
23 SET GLOBAL debug_dbug = "+d,sync.wsrep_apply_cb";
24
25 --connection node_1
26 INSERT INTO t1 VALUES (1,'node_1');
27
28 --connection node_2a
29 SET DEBUG_SYNC = "now WAIT_FOR sync.wsrep_apply_cb_reached";
30
31 --connection node_2
32 SET DEBUG_SYNC = "wsrep_before_before_command SIGNAL signal.wsrep_apply_cb WAIT_FOR bf_abort";
33
34 #
35 # The following INSERT is expected to enter
36 # wsrep_before_command() and find its transaction
37 # in state s_must_abort.
38 # Notice that the test appears more complicated
39 # than it needs to... however we cannot use
40 # --send for this INSERT, otherwise mysqltest
41 # will not use ps-protocol
42 #
43 --error ER_LOCK_DEADLOCK
44 INSERT INTO t1 VALUES (2, 'node_2');
45
46 --let $wsrep_local_bf_aborts_after = `SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_bf_aborts'`
47
48 --disable_query_log
49 --eval SELECT $wsrep_local_bf_aborts_after - $wsrep_local_bf_aborts_before = 1 AS wsrep_local_aborts_increment;
50 --enable_query_log
51
52 SET DEBUG_SYNC = 'RESET';
53 SET GLOBAL debug_dbug = DEFAULT;
54 DROP TABLE t1;