Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 connect node_6, 127.0.0.1, root, , test, $NODE_MYPORT_6;
4 connect node_5, 127.0.0.1, root, , test, $NODE_MYPORT_5;
5 connect node_4, 127.0.0.1, root, , test, $NODE_MYPORT_4;
6 connection node_4;
7 START SLAVE;
8 include/wait_for_slave_to_start.inc
9 connection node_1;
10 CREATE TABLE t1(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, c2 INTEGER);
11 INSERT INTO t1(c2) VALUES(1);
12 connect node_3, 127.0.0.1, root, , test, $NODE_MYPORT_3;
13 connection node_3;
14 SELECT COUNT(*) = 1 FROM t1;
15 COUNT(*) = 1
16 1
17 connection node_1;
18 include/save_master_gtid.inc
19 connection node_4;
20 include/sync_with_master_gtid.inc
21 SELECT COUNT(*) = 1 FROM t1;
22 COUNT(*) = 1
23 1
24 connection node_6;
25 SELECT COUNT(*) = 1 FROM t1;
26 COUNT(*) = 1
27 1
28 connection node_2;
29 ALTER TABLE t1 ADD COLUMN t3 INTEGER;
30 Node 2 column number AFTER ALTER
31 SELECT COUNT(*) = 3 FROM information_schema.columns WHERE table_name ='t1';
32 COUNT(*) = 3
33 1
34 connection node_3;
35 Node 3 column number AFTER ALTER
36 SELECT COUNT(*) = 3 FROM information_schema.columns WHERE table_name ='t1';
37 COUNT(*) = 3
38 1
39 connection node_1;
40 include/save_master_gtid.inc
41 connection node_4;
42 include/sync_with_master_gtid.inc
43 Node 4 column number AFTER ALTER
44 SELECT COUNT(*) = 3 FROM information_schema.columns WHERE table_name ='t1';
45 COUNT(*) = 3
46 1
47 connection node_6;
48 Node 6 column number AFTER ALTER
49 SELECT COUNT(*) = 3 FROM information_schema.columns WHERE table_name ='t1';
50 COUNT(*) = 3
51 1
52 connection node_2;
53 connection node_1;
54 connection node_3;
55 connection node_4;
56 connection node_5;
57 connection node_6;
58 connection node_2;
59 OPTIMIZE TABLE t1;
60 Table Op Msg_type Msg_text
61 test.t1 optimize note Table does not support optimize, doing recreate + analyze instead
62 test.t1 optimize status OK
63 Warnings:
64 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the slave
65 connection node_1;
66 connection node_3;
67 connection node_4;
68 connection node_5;
69 connection node_6;
70 connection node_1;
71 DROP TABLE t1;
72 connection node_4;
73 STOP SLAVE;
74 RESET SLAVE;
75 Warnings:
76 Note 4190 RESET SLAVE is implicitly changing the value of 'Using_Gtid' from 'Current_Pos' to 'Slave_Pos'
77 SET GLOBAL wsrep_on = OFF;
78 RESET MASTER;
79 SET GLOBAL wsrep_on = ON;
80 SET GLOBAL GTID_SLAVE_POS="";
81 connection node_1;
82 SET GLOBAL wsrep_on = OFF;
83 RESET MASTER;
84 SET GLOBAL wsrep_on = ON;
85 connection node_2;
86 SET GLOBAL wsrep_on = OFF;
87 RESET MASTER;
88 SET GLOBAL wsrep_on = ON;
89 connection node_3;
90 SET GLOBAL wsrep_on = OFF;
91 RESET MASTER;
92 SET GLOBAL wsrep_on = ON;
93 connection node_5;
94 SET GLOBAL wsrep_on = OFF;
95 RESET MASTER;
96 SET GLOBAL wsrep_on = ON;
97 connection node_6;
98 SET GLOBAL wsrep_on = OFF;
99 RESET MASTER;
100 SET GLOBAL wsrep_on = ON;
101 connection node_1;
102 CALL mtr.add_suppression("Ignoring server id .* for non bootstrap node");
103 CALL mtr.add_suppression("Unsafe statement written to the binary log using statement format since ");
104 connection node_2;
105 CALL mtr.add_suppression("Ignoring server id .* for non bootstrap node");
106 CALL mtr.add_suppression("Unsafe statement written to the binary log using statement format since ");
107 connection node_3;
108 CALL mtr.add_suppression("Ignoring server id .* for non bootstrap node");
109 CALL mtr.add_suppression("Unsafe statement written to the binary log using statement format since ");
110 connection node_4;
111 CALL mtr.add_suppression("Ignoring server id .* for non bootstrap node");
112 CALL mtr.add_suppression("Unsafe statement written to the binary log using statement format since ");
113 connection node_5;
114 CALL mtr.add_suppression("Ignoring server id .* for non bootstrap node");
115 CALL mtr.add_suppression("Unsafe statement written to the binary log using statement format since ");
116 connection node_6;
117 CALL mtr.add_suppression("Ignoring server id .* for non bootstrap node");
118 CALL mtr.add_suppression("Unsafe statement written to the binary log using statement format since ");