Debian Codegraph @

mysql-test/suite/galera/r/galera_ftwrl_drain.result

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 CREATE TABLE t1 (id INT PRIMARY KEY) ENGINE=InnoDB;
5 connection node_2;
6 SET GLOBAL wsrep_provider_options = 'dbug=d,apply_monitor_slave_enter_sync';
7 connection node_1;
8 INSERT INTO t1 VALUES (1);
9 connection node_2;
10 SET SESSION wsrep_sync_wait = 0;
11 SET SESSION wsrep_on = 0;
12 SET SESSION wsrep_on = 1;
13 SELECT COUNT(*) AS EXPECT_0 FROM t1;
14 EXPECT_0
15 0
16 connect node_2a, 127.0.0.1, root, , test, $NODE_MYPORT_2;
17 connection node_2a;
18 FLUSH TABLES WITH READ LOCK;;
19 connection node_2;
20 SET GLOBAL wsrep_provider_options = 'dbug=';
21 SET GLOBAL wsrep_provider_options = 'signal=apply_monitor_slave_enter_sync';
22 connection node_2a;
23 connection node_2;
24 SET SESSION lock_wait_timeout = 1;
25 SET SESSION innodb_lock_wait_timeout=1;
26 SET SESSION wait_timeout=1;
27 INSERT INTO t1 VALUES (2);
28 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
29 connection node_2a;
30 UNLOCK TABLES;
31 connection node_2;
32 SELECT COUNT(*) AS EXPECT_1 FROM t1;
33 EXPECT_1
34 1
35 INSERT INTO t1 VALUES (3);
36 connection node_1;
37 SELECT COUNT(*) AS EXPECT_2 FROM t1;
38 EXPECT_2
39 2
40 DROP TABLE t1;