Debian Codegraph @

mysql-test/suite/galera_3nodes_sr/t/GCF-609.test

raw
1 #
2 # GCF-609 SR: Assertion wsrep_apply_cb on slave after master causes a duplicate key error
3 #
4
5 --source include/galera_cluster.inc
6
7 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
8
9 --connection node_1
10 SET SESSION wsrep_trx_fragment_size=1;
11 SET AUTOCOMMIT=OFF;
12 START TRANSACTION;
13 INSERT INTO t1 VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);
14
15 --connection node_2
16 SET SESSION wsrep_trx_fragment_size=1;
17 SET AUTOCOMMIT=OFF;
18 START TRANSACTION;
19 INSERT INTO t1 VALUES (11),(12),(13),(14),(15),(16),(17),(18),(19),(20);
20 --error ER_DUP_ENTRY
21 INSERT INTO t1 VALUES (11),(12),(13),(14),(15),(16),(17),(18),(19),(20);
22 INSERT INTO t1 VALUES (31),(32),(33);
23
24 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
25
26 --connection node_1
27 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
28 COMMIT;
29
30 --connection node_2
31 COMMIT;
32 SELECT * FROM t1;
33
34 --connection node_1
35 SELECT * FROM t1;
36
37 DROP TABLE t1;