Debian Codegraph @

mysql-test/suite/galera/r/MW-388.result

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY, f2 CHAR(255)) Engine=InnoDB;
5 CREATE PROCEDURE insert_proc ()
6 BEGIN
7 DECLARE CONTINUE HANDLER FOR SQLEXCEPTION
8 BEGIN
9 GET DIAGNOSTICS CONDITION 1 @errno = MYSQL_ERRNO;
10 END;
11 INSERT INTO t1 VALUES (1, 'node 1'),(2, 'node 1');
12 INSERT INTO t1 VALUES (3, 'node 1');
13 END|
14 SET GLOBAL wsrep_slave_threads = 2;
15 SET GLOBAL DEBUG_DBUG = "d,sync.wsrep_apply_cb";
16 connection node_2;
17 INSERT INTO t1 VALUES (1, 'node 2');;
18 connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1;
19 connection node_1a;
20 SET SESSION DEBUG_SYNC = "now WAIT_FOR sync.wsrep_apply_cb_reached";
21 connection node_1;
22 SET SESSION wsrep_sync_wait = 0;
23 CALL insert_proc ();;
24 connection node_1a;
25 SET SESSION wsrep_sync_wait = 0;
26 SET GLOBAL DEBUG_DBUG = "";
27 SET DEBUG_SYNC = "now SIGNAL signal.wsrep_apply_cb";
28 connection node_2;
29 connection node_1;
30 SELECT @errno = 1213;
31 @errno = 1213
32 1
33 SELECT * FROM t1;
34 f1 f2
35 1 node 2
36 3 node 1
37 connection node_2;
38 SELECT * FROM t1;
39 f1 f2
40 1 node 2
41 3 node 1
42 connection node_1;
43 SET GLOBAL wsrep_slave_threads = DEFAULT;
44 DROP TABLE t1;
45 DROP PROCEDURE insert_proc;
46 SET GLOBAL debug_dbug = NULL;
47 SET debug_sync='RESET';
48 SELECT @@debug_sync;
49 @@debug_sync
50 ON - current signals: ''