Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 CREATE TABLE t1 (f1 INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT,B INTEGER) ENGINE=InnoDB;
4 INSERT INTO t1 VALUES (1,1);
5 connection node_2;
6 SELECT COUNT(*) FROM t1;
7 COUNT(*)
8 1
9 SET GLOBAL wsrep_provider_options = 'gcs.fc_limit=1';
10 LOCK TABLE t1 WRITE;
11 connection node_1;
12 FLUSH STATUS;
13 INSERT INTO t1 VALUES (2,2);
14 INSERT INTO t1 VALUES (3,3);
15 INSERT INTO t1 VALUES (4,4);
16 INSERT INTO t1(B) SELECT B FROM t1;
17 connection node_1a;
18 # In node_1 either insert or commit should be stuck
19 connection node_2;
20 UNLOCK TABLES;
21 connection node_1;
22 INSERT INTO t1 VALUES (NULL,6);
23 connection node_2;
24 SELECT COUNT(*) FROM t1;
25 COUNT(*)
26 9
27 DROP TABLE t1;