Debian Codegraph @

mysql-test/suite/galera_3nodes/r/GCF-363.result

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 connection node_2;
5 connection node_3;
6 connection node_1;
7 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY, f2 CHAR(1)) ENGINE=InnoDB;
8 SET GLOBAL wsrep_on=OFF;
9 INSERT INTO t1 VALUES (1, 'a');
10 SET GLOBAL wsrep_on=ON;
11 connection node_2;
12 SET GLOBAL wsrep_on=OFF;
13 INSERT INTO t1 VALUES (1, 'a');
14 SET GLOBAL wsrep_on=ON;
15 connection node_3;
16 INSERT INTO t1 VALUES (1, 'b');
17 SET SESSION wsrep_sync_wait = 0;
18 SHOW STATUS LIKE 'wsrep_cluster_status';
19 Variable_name Value
20 wsrep_cluster_status Disconnected
21 connection node_1;
22 connection node_3;
23 SET SESSION wsrep_on=OFF;
24 # restart
25 SET SESSION wsrep_on=ON;
26 connection node_1;
27 SELECT * FROM t1;
28 f1 f2
29 1 a
30 connection node_2;
31 SELECT * FROM t1;
32 f1 f2
33 1 a
34 connection node_3;
35 SELECT * FROM t1;
36 f1 f2
37 1 a
38 DROP TABLE t1;
39 connection node_1;
40 CALL mtr.add_suppression("Slave SQL: Could not execute Write_rows event on table test\\.t1; Duplicate entry '1' for key 'PRIMARY', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's master log FIRST, end_log_pos 155, Error_code: 1062");
41 CALL mtr.add_suppression("WSREP: Event 3 Write_rows_v1 apply failed: 121, seqno ");
42 connection node_2;
43 CALL mtr.add_suppression("Slave SQL: Could not execute Write_rows event on table test\\.t1; Duplicate entry '1' for key 'PRIMARY', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's master log FIRST, end_log_pos 155, Error_code: 1062");
44 CALL mtr.add_suppression("WSREP: Event 3 Write_rows_v1 apply failed: 121, seqno ");
45 connection node_3;
46 CALL mtr.add_suppression("WSREP: Vote 0 \\(success\\) on (.*) is inconsistent with group\\. Leaving cluster\\.");
47 CALL mtr.add_suppression("WSREP: Inconsistency detected: Inconsistent by consensus on ");
48 CALL mtr.add_suppression("Plugin 'InnoDB' will be forced to shutdown");
49 connection node_1;