Debian Codegraph @

mysql-test/suite/galera_3nodes/r/galera_parallel_apply_3nodes.result

raw
1 connection node_2;
2 connection node_1;
3 connect node_3, 127.0.0.1, root, , test, $NODE_MYPORT_3;
4 connect node_1_ctrl, 127.0.0.1, root, , test, $NODE_MYPORT_1;
5 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
6 INSERT INTO t1 VALUES (1);
7 connection node_3;
8 SET GLOBAL wsrep_slave_threads = 2;
9 connection node_1_ctrl;
10 SET SESSION wsrep_sync_wait=0;
11 connection node_1;
12 SET DEBUG_SYNC = 'wsrep_before_certification SIGNAL before_cert WAIT_FOR continue';
13 UPDATE t1 SET f1 = f1 + 10;;
14 connection node_1_ctrl;
15 SET DEBUG_SYNC = 'now WAIT_FOR before_cert';
16 SET GLOBAL debug_dbug = '+d,sync.wsrep_retry_autocommit';
17 connection node_2;
18 UPDATE t1 SET f1 = f1 + 100;;
19 connection node_1_ctrl;
20 SET DEBUG_SYNC = 'now WAIT_FOR wsrep_retry_autocommit_reached';
21 SET GLOBAL debug_dbug = NULL;
22 SET DEBUG_SYNC = 'now SIGNAL wsrep_retry_autocommit_continue';
23 connection node_1;
24 connection node_2;
25 connection node_3;
26 SELECT f1 = 111 FROM t1;
27 f1 = 111
28 1
29 SELECT COUNT(*) IN (1, 2) FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'system user' AND (STATE LIKE '%committed%' OR STATE LIKE 'Waiting for certification');
30 COUNT(*) IN (1, 2)
31 1
32 SET GLOBAL wsrep_slave_threads = DEFAULT;
33 DROP TABLE t1;
34 connection node_1;
35 SET DEBUG_SYNC= 'RESET';