Debian Codegraph @

mysql-test/suite/galera_3nodes/r/galera_vote_majority_dml.result

raw
1 connection node_2;
2 connection node_1;
3 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY, f2 BLOB) ENGINE=InnoDB;
4 connect node_3, 127.0.0.1, root, , test, $NODE_MYPORT_3;
5 connection node_3;
6 SET GLOBAL wsrep_on=OFF;
7 ALTER TABLE t1 MODIFY f2 LONGTEXT;
8 SET GLOBAL wsrep_on=ON;
9 INSERT INTO t1 VALUES (3, 'a');
10 connection node_1;
11 SHOW STATUS LIKE 'wsrep_cluster_status';
12 Variable_name Value
13 wsrep_cluster_status Primary
14 connection node_2;
15 SHOW STATUS LIKE 'wsrep_cluster_status';
16 Variable_name Value
17 wsrep_cluster_status Primary
18 INSERT INTO t1 VALUES (2, 'a');
19 connection node_3;
20 SET SESSION wsrep_sync_wait=0;
21 SET SESSION wsrep_on=OFF;
22 # restart
23 SET SESSION wsrep_on=ON;
24 INSERT INTO t1 VALUES (3, 'a');
25 connection node_1;
26 SHOW CREATE TABLE t1;
27 Table Create Table
28 t1 CREATE TABLE `t1` (
29 `f1` int(11) NOT NULL,
30 `f2` blob DEFAULT NULL,
31 PRIMARY KEY (`f1`)
32 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
33 SELECT * FROM t1;
34 f1 f2
35 2 a
36 3 a
37 connection node_2;
38 SHOW CREATE TABLE t1;
39 Table Create Table
40 t1 CREATE TABLE `t1` (
41 `f1` int(11) NOT NULL,
42 `f2` blob DEFAULT NULL,
43 PRIMARY KEY (`f1`)
44 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
45 SELECT * FROM t1;
46 f1 f2
47 2 a
48 3 a
49 connection node_3;
50 SHOW CREATE TABLE t1;
51 Table Create Table
52 t1 CREATE TABLE `t1` (
53 `f1` int(11) NOT NULL,
54 `f2` blob DEFAULT NULL,
55 PRIMARY KEY (`f1`)
56 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
57 SELECT * FROM t1;
58 f1 f2
59 2 a
60 3 a
61 DROP TABLE t1;
62 connection node_1;
63 CALL mtr.add_suppression("Replica SQL: Column 1 of table 'test.t1' cannot be converted from type 'longblob' to type 'blob', Error_code: MY-013146");
64 CALL mtr.add_suppression("Event 3 Write_rows_v1 apply failed: 3, seqno");
65 connection node_2;
66 CALL mtr.add_suppression("Replica SQL: Column 1 of table 'test.t1' cannot be converted from type 'longblob' to type 'blob', Error_code: MY-013146");
67 CALL mtr.add_suppression("Event 3 Write_rows_v1 apply failed: 3, seqno");
68 connection node_3;
69 CALL mtr.add_suppression("Vote 0 \\(success\\) on (.*) is inconsistent with group. Leaving cluster.");
70 CALL mtr.add_suppression("Plugin 'InnoDB' will be forced to shutdown");