Debian Codegraph @

mysql-test/suite/galera_sr/t/mysql-wsrep-features#35.test

raw
1 --source include/have_debug_sync.inc
2 --source include/galera_cluster.inc
3
4 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
5
6 # Block node #2's applier so that it is able to issue a conflicting INSERT before
7 # node #1 INSERTs have been applied on it.
8
9 --connect node_2a, 127.0.0.1, root, , test, $NODE_MYPORT_2
10 SELECT COUNT(*) = 0 FROM t1;
11 SET SESSION wsrep_sync_wait = 0;
12 SET GLOBAL debug_dbug = '+d,sync.wsrep_apply_cb';
13
14 --connection node_1
15 SET SESSION wsrep_trx_fragment_size = 1;
16 SET AUTOCOMMIT=OFF;
17 START TRANSACTION;
18
19 INSERT INTO t1 VALUES (1);
20 INSERT INTO t1 VALUES (2);
21 INSERT INTO t1 VALUES (3);
22 INSERT INTO t1 VALUES (4);
23 INSERT INTO t1 VALUES (5);
24
25 --connection node_2a
26 SET SESSION debug_sync = "now WAIT_FOR sync.wsrep_apply_cb_reached";
27
28 --connection node_2
29 SET SESSION wsrep_sync_wait = 0;
30 SELECT COUNT(*) = 0 FROM t1;
31 --send INSERT INTO t1 VALUES (1);
32
33 --connection node_1
34 COMMIT;
35
36 --connection node_2a
37 SET GLOBAL debug_dbug = '';
38 SET DEBUG_SYNC = "now SIGNAL signal.wsrep_apply_cb";
39
40 --connection node_2
41 --error ER_DUP_ENTRY,ER_LOCK_DEADLOCK
42 --reap
43 ROLLBACK;
44
45 DROP TABLE t1;
46
47 --connection node_2a
48 SET DEBUG_SYNC = "RESET";