Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 CREATE TABLE t1 (id INT PRIMARY KEY AUTO_INCREMENT) ENGINE=InnoDB;
4 INSERT INTO t1 VALUES (1);
5 connection node_2;
6 SET GLOBAL wsrep_provider_options = "repl.causal_read_timeout=PT1S";
7 SET GLOBAL debug_dbug = "d,sync.wsrep_apply_cb";
8 SELECT MAX(id) FROM t1;
9 MAX(id)
10 1
11 connection node_1;
12 INSERT INTO t1 VALUES (2);
13 connection node_2;
14 SELECT MAX(id) FROM t1;
15 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
16 SET GLOBAL debug_dbug = "";
17 SET DEBUG_SYNC = "now SIGNAL signal.wsrep_apply_cb";
18 FLUSH QUERY CACHE;
19 SET GLOBAL debug_dbug = "d,sync.wsrep_apply_cb";
20 SET DEBUG_SYNC = "RESET";
21 connection node_1;
22 INSERT INTO t1 VALUES (3);
23 connection node_2;
24 SELECT MAX(id) FROM t1;
25 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
26 SET GLOBAL debug_dbug = "";
27 SET DEBUG_SYNC = "now SIGNAL signal.wsrep_apply_cb";
28 connection node_1;
29 INSERT INTO t1 VALUES (4);
30 connection node_2;
31 SELECT MAX(id) FROM t1;
32 MAX(id)
33 4
34 FLUSH STATUS;
35 SELECT MAX(id) FROM t1;
36 MAX(id)
37 4
38 SELECT VARIABLE_VALUE = 1 FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME = 'Qcache_hits';
39 VARIABLE_VALUE = 1
40 1
41 SET GLOBAL debug_dbug = "d,sync.wsrep_apply_cb";
42 connection node_1;
43 INSERT INTO t1 VALUES (5);
44 connection node_2;
45 SELECT MAX(id) FROM t1 ;
46 connect node_2a, 127.0.0.1, root, , test, $NODE_MYPORT_2;
47 connection node_2a;
48 SET GLOBAL debug_dbug = "";
49 SET DEBUG_SYNC = "now SIGNAL signal.wsrep_apply_cb";
50 connection node_2;
51 MAX(id)
52 5
53 SELECT VARIABLE_VALUE = 1 FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME = 'Qcache_hits';
54 VARIABLE_VALUE = 1
55 1