Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 CREATE TABLE t1 (id INT PRIMARY KEY) ENGINE=InnoDB;
4 connection node_2;
5 SET GLOBAL wsrep_provider_options = "repl.causal_read_timeout=PT1S";
6 FLUSH TABLES WITH READ LOCK;
7 connection node_1;
8 INSERT INTO t1 VALUES (1);
9 connection node_2;
10 SHOW TABLES;
11 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
12 SELECT * FROM t1;
13 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
14 UNLOCK TABLES;
15 SHOW TABLES;
16 Tables_in_test
17 t1
18 SELECT COUNT(*) = 1 FROM t1;
19 COUNT(*) = 1
20 1
21 DROP TABLE t1;