Debian Codegraph @

mysql-test/suite/galera_sr/r/galera_sr_log_bin.result

raw
1 CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
2 CREATE TABLE t2 (f1 INTEGER) ENGINE=InnoDB;
3 CREATE TABLE t3 (f1 INTEGER) ENGINE=InnoDB;
4 CREATE TABLE t4 (f1 INTEGER) ENGINE=InnoDB;
5 connection node_2;
6 connection node_1;
7 SET SESSION wsrep_trx_fragment_size = 1;
8 SET AUTOCOMMIT=OFF;
9 START TRANSACTION;
10 INSERT INTO t1 VALUES (1);
11 connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1;
12 connection node_1a;
13 SET GLOBAL wsrep_on=OFF;
14 RESET MASTER;
15 SET GLOBAL wsrep_on=ON;
16 SET AUTOCOMMIT=OFF;
17 START TRANSACTION;
18 INSERT INTO t2 VALUES (1);
19 connection node_2;
20 SET GLOBAL wsrep_on=OFF;
21 RESET MASTER;
22 SET GLOBAL wsrep_on=ON;
23 SET AUTOCOMMIT=OFF;
24 SET SESSION wsrep_trx_fragment_size = 1;
25 START TRANSACTION;
26 INSERT INTO t3 VALUES (1);
27 connect node_2a, 127.0.0.1, root, , test, $NODE_MYPORT_2;
28 connection node_2a;
29 SET AUTOCOMMIT=OFF;
30 START TRANSACTION;
31 INSERT INTO t4 VALUES (1);
32 connection node_1;
33 INSERT INTO t1 VALUES (2);
34 COMMIT;
35 connection node_1a;
36 INSERT INTO t2 VALUES (2);
37 COMMIT;
38 connection node_2;
39 INSERT INTO t3 VALUES (2);
40 COMMIT;
41 connection node_2a;
42 INSERT INTO t4 VALUES (2);
43 COMMIT;
44 connection node_1;
45 SELECT COUNT(*) = 2 FROM t4;
46 COUNT(*) = 2
47 1
48 SHOW BINLOG EVENTS IN 'mysqld-bin.000001' FROM 256;
49 Log_name Pos Event_type Server_id End_log_pos Info
50 mysqld-bin.000001 <Pos> Gtid_list 1 <End_log_pos> []
51 mysqld-bin.000001 <Pos> Binlog_checkpoint 1 <End_log_pos> mysqld-bin.000001
52 mysqld-bin.000001 <Pos> Gtid 1 <End_log_pos> BEGIN GTID 0-1-1
53 mysqld-bin.000001 <Pos> Annotate_rows 1 <End_log_pos> INSERT INTO t1 VALUES (1)
54 mysqld-bin.000001 <Pos> Table_map 1 <End_log_pos> table_id: ### (test.t1)
55 mysqld-bin.000001 <Pos> Write_rows_v1 1 <End_log_pos> table_id: ### flags: STMT_END_F
56 mysqld-bin.000001 <Pos> Annotate_rows 1 <End_log_pos> INSERT INTO t1 VALUES (2)
57 mysqld-bin.000001 <Pos> Table_map 1 <End_log_pos> table_id: ### (test.t1)
58 mysqld-bin.000001 <Pos> Write_rows_v1 1 <End_log_pos> table_id: ### flags: STMT_END_F
59 mysqld-bin.000001 <Pos> Xid 1 <End_log_pos> COMMIT /* xid=### */
60 mysqld-bin.000001 <Pos> Gtid 1 <End_log_pos> BEGIN GTID 0-1-2
61 mysqld-bin.000001 <Pos> Annotate_rows 1 <End_log_pos> INSERT INTO t2 VALUES (1)
62 mysqld-bin.000001 <Pos> Table_map 1 <End_log_pos> table_id: ### (test.t2)
63 mysqld-bin.000001 <Pos> Write_rows_v1 1 <End_log_pos> table_id: ### flags: STMT_END_F
64 mysqld-bin.000001 <Pos> Annotate_rows 1 <End_log_pos> INSERT INTO t2 VALUES (2)
65 mysqld-bin.000001 <Pos> Table_map 1 <End_log_pos> table_id: ### (test.t2)
66 mysqld-bin.000001 <Pos> Write_rows_v1 1 <End_log_pos> table_id: ### flags: STMT_END_F
67 mysqld-bin.000001 <Pos> Xid 1 <End_log_pos> COMMIT /* xid=### */
68 mysqld-bin.000001 <Pos> Gtid 2 <End_log_pos> BEGIN GTID 0-2-3
69 mysqld-bin.000001 <Pos> Annotate_rows 2 <End_log_pos> INSERT INTO t3 VALUES (1)
70 mysqld-bin.000001 <Pos> Table_map 2 <End_log_pos> table_id: ### (test.t3)
71 mysqld-bin.000001 <Pos> Write_rows_v1 2 <End_log_pos> table_id: ### flags: STMT_END_F
72 mysqld-bin.000001 <Pos> Annotate_rows 2 <End_log_pos> INSERT INTO t3 VALUES (2)
73 mysqld-bin.000001 <Pos> Table_map 2 <End_log_pos> table_id: ### (test.t3)
74 mysqld-bin.000001 <Pos> Write_rows_v1 2 <End_log_pos> table_id: ### flags: STMT_END_F
75 mysqld-bin.000001 <Pos> Xid 2 <End_log_pos> COMMIT /* xid=### */
76 mysqld-bin.000001 <Pos> Gtid 2 <End_log_pos> BEGIN GTID 0-2-4
77 mysqld-bin.000001 <Pos> Annotate_rows 2 <End_log_pos> INSERT INTO t4 VALUES (1)
78 mysqld-bin.000001 <Pos> Table_map 2 <End_log_pos> table_id: ### (test.t4)
79 mysqld-bin.000001 <Pos> Write_rows_v1 2 <End_log_pos> table_id: ### flags: STMT_END_F
80 mysqld-bin.000001 <Pos> Annotate_rows 2 <End_log_pos> INSERT INTO t4 VALUES (2)
81 mysqld-bin.000001 <Pos> Table_map 2 <End_log_pos> table_id: ### (test.t4)
82 mysqld-bin.000001 <Pos> Write_rows_v1 2 <End_log_pos> table_id: ### flags: STMT_END_F
83 mysqld-bin.000001 <Pos> Xid 2 <End_log_pos> COMMIT /* xid=### */
84 connection node_2;
85 SELECT COUNT(*) = 2 FROM t4;
86 COUNT(*) = 2
87 1
88 SHOW BINLOG EVENTS IN 'mysqld-bin.000001' FROM 256;
89 Log_name Pos Event_type Server_id End_log_pos Info
90 mysqld-bin.000001 <Pos> Gtid_list 2 <End_log_pos> []
91 mysqld-bin.000001 <Pos> Binlog_checkpoint 2 <End_log_pos> mysqld-bin.000001
92 mysqld-bin.000001 <Pos> Gtid 1 <End_log_pos> BEGIN GTID 0-1-1
93 mysqld-bin.000001 <Pos> Annotate_rows 1 <End_log_pos> INSERT INTO t1 VALUES (1)
94 mysqld-bin.000001 <Pos> Table_map 1 <End_log_pos> table_id: ### (test.t1)
95 mysqld-bin.000001 <Pos> Write_rows_v1 1 <End_log_pos> table_id: ### flags: STMT_END_F
96 mysqld-bin.000001 <Pos> Annotate_rows 1 <End_log_pos> INSERT INTO t1 VALUES (2)
97 mysqld-bin.000001 <Pos> Table_map 1 <End_log_pos> table_id: ### (test.t1)
98 mysqld-bin.000001 <Pos> Write_rows_v1 1 <End_log_pos> table_id: ### flags: STMT_END_F
99 mysqld-bin.000001 <Pos> Xid 1 <End_log_pos> COMMIT /* xid=### */
100 mysqld-bin.000001 <Pos> Gtid 1 <End_log_pos> BEGIN GTID 0-1-2
101 mysqld-bin.000001 <Pos> Annotate_rows 1 <End_log_pos> INSERT INTO t2 VALUES (1)
102 mysqld-bin.000001 <Pos> Table_map 1 <End_log_pos> table_id: ### (test.t2)
103 mysqld-bin.000001 <Pos> Write_rows_v1 1 <End_log_pos> table_id: ### flags: STMT_END_F
104 mysqld-bin.000001 <Pos> Annotate_rows 1 <End_log_pos> INSERT INTO t2 VALUES (2)
105 mysqld-bin.000001 <Pos> Table_map 1 <End_log_pos> table_id: ### (test.t2)
106 mysqld-bin.000001 <Pos> Write_rows_v1 1 <End_log_pos> table_id: ### flags: STMT_END_F
107 mysqld-bin.000001 <Pos> Xid 1 <End_log_pos> COMMIT /* xid=### */
108 mysqld-bin.000001 <Pos> Gtid 2 <End_log_pos> BEGIN GTID 0-2-3
109 mysqld-bin.000001 <Pos> Annotate_rows 2 <End_log_pos> INSERT INTO t3 VALUES (1)
110 mysqld-bin.000001 <Pos> Table_map 2 <End_log_pos> table_id: ### (test.t3)
111 mysqld-bin.000001 <Pos> Write_rows_v1 2 <End_log_pos> table_id: ### flags: STMT_END_F
112 mysqld-bin.000001 <Pos> Annotate_rows 2 <End_log_pos> INSERT INTO t3 VALUES (2)
113 mysqld-bin.000001 <Pos> Table_map 2 <End_log_pos> table_id: ### (test.t3)
114 mysqld-bin.000001 <Pos> Write_rows_v1 2 <End_log_pos> table_id: ### flags: STMT_END_F
115 mysqld-bin.000001 <Pos> Xid 2 <End_log_pos> COMMIT /* xid=### */
116 mysqld-bin.000001 <Pos> Gtid 2 <End_log_pos> BEGIN GTID 0-2-4
117 mysqld-bin.000001 <Pos> Annotate_rows 2 <End_log_pos> INSERT INTO t4 VALUES (1)
118 mysqld-bin.000001 <Pos> Table_map 2 <End_log_pos> table_id: ### (test.t4)
119 mysqld-bin.000001 <Pos> Write_rows_v1 2 <End_log_pos> table_id: ### flags: STMT_END_F
120 mysqld-bin.000001 <Pos> Annotate_rows 2 <End_log_pos> INSERT INTO t4 VALUES (2)
121 mysqld-bin.000001 <Pos> Table_map 2 <End_log_pos> table_id: ### (test.t4)
122 mysqld-bin.000001 <Pos> Write_rows_v1 2 <End_log_pos> table_id: ### flags: STMT_END_F
123 mysqld-bin.000001 <Pos> Xid 2 <End_log_pos> COMMIT /* xid=### */
124 DROP TABLE t1,t2,t3,t4;