Debian Codegraph @

mysql-test/suite/galera_sr/t/MDEV-23623.test

raw
1 #
2 # MDEV-23623 - trans_commit_stmt(THD*): Assertion
3 # `thd->in_active_multi_stmt_transaction() ||
4 # thd->m_transaction_psi == __null' failed
5 #
6
7 --source include/galera_cluster.inc
8 --source include/have_debug_sync.inc
9 --source include/galera_have_debug_sync.inc
10
11 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY AUTO_INCREMENT, f2 CHAR(255)) ENGINE=InnoDB;
12 INSERT INTO t1 (f2) VALUES ('a');
13 INSERT INTO t1 (f2) VALUES ('b');
14 INSERT INTO t1 (f2) VALUES ('c');
15
16 --connect node_2a, 127.0.0.1, root, , test, $NODE_MYPORT_2
17 --connection node_2a
18 SET SESSION wsrep_sync_wait = 0;
19 --let $galera_sync_point = after_certify_apply_monitor_enter
20 --source include/galera_set_sync_point.inc
21
22 --connection node_2
23 SET SESSION wsrep_retry_autocommit = 0;
24 SET SESSION wsrep_trx_fragment_size = 64;
25 --send DELETE FROM t1 ORDER BY f1 DESC LIMIT 2;
26
27 --connection node_2a
28 --source include/galera_wait_sync_point.inc
29
30 #
31 # This is going to cause a certification
32 # failure on node_2
33 #
34 --connection node_1
35 INSERT INTO t1 (f2) VALUES ('d'),('e');
36
37 --connection node_2a
38 --source include/galera_signal_sync_point.inc
39 --source include/galera_clear_sync_point.inc
40
41 --connection node_2
42 --error ER_LOCK_DEADLOCK
43 --reap
44
45 #
46 # Assertion would happen when the following
47 # DROP TABLE is applied on node_2
48 #
49 --connection node_1
50 DROP TABLE t1;