Debian Codegraph @

mysql-test/suite/galera_sr/r/mysql-wsrep-features#136.result

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 SET GLOBAL wsrep_on=OFF;
5 RESET MASTER;
6 SET GLOBAL wsrep_on=ON;
7 connection node_2;
8 SET GLOBAL wsrep_on=OFF;
9 RESET MASTER;
10 SET GLOBAL wsrep_on=ON;
11 connection node_1;
12 SET SESSION wsrep_trx_fragment_size = 1;
13 SET AUTOCOMMIT=OFF;
14 START TRANSACTION;
15 CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
16 INSERT INTO t1 VALUES (1),(2);
17 COMMIT;
18 SET SESSION wsrep_trx_fragment_size = 0;
19 INSERT INTO t1 VALUES (3),(4);
20 COMMIT;
21 connection node_1;
22 SHOW BINLOG EVENTS IN 'mysqld-bin.000001' FROM 256;
23 Log_name Pos Event_type Server_id End_log_pos Info
24 mysqld-bin.000001 <Pos> Gtid_list 1 <End_log_pos> []
25 mysqld-bin.000001 <Pos> Binlog_checkpoint 1 <End_log_pos> mysqld-bin.000001
26 mysqld-bin.000001 <Pos> Gtid 1 <End_log_pos> GTID 0-1-1
27 mysqld-bin.000001 <Pos> Query 1 <End_log_pos> use `test`; CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB
28 mysqld-bin.000001 <Pos> Gtid 1 <End_log_pos> BEGIN GTID 0-1-2
29 mysqld-bin.000001 <Pos> Annotate_rows 1 <End_log_pos> INSERT INTO t1 VALUES (1),(2)
30 mysqld-bin.000001 <Pos> Table_map 1 <End_log_pos> table_id: ### (test.t1)
31 mysqld-bin.000001 <Pos> Write_rows_v1 1 <End_log_pos> table_id: ### flags: STMT_END_F
32 mysqld-bin.000001 <Pos> Table_map 1 <End_log_pos> table_id: ### (test.t1)
33 mysqld-bin.000001 <Pos> Write_rows_v1 1 <End_log_pos> table_id: ### flags: STMT_END_F
34 mysqld-bin.000001 <Pos> Xid 1 <End_log_pos> COMMIT /* xid=### */
35 mysqld-bin.000001 <Pos> Gtid 1 <End_log_pos> BEGIN GTID 0-1-3
36 mysqld-bin.000001 <Pos> Annotate_rows 1 <End_log_pos> INSERT INTO t1 VALUES (3),(4)
37 mysqld-bin.000001 <Pos> Table_map 1 <End_log_pos> table_id: ### (test.t1)
38 mysqld-bin.000001 <Pos> Write_rows_v1 1 <End_log_pos> table_id: ### flags: STMT_END_F
39 mysqld-bin.000001 <Pos> Xid 1 <End_log_pos> COMMIT /* xid=### */
40 connection node_2;
41 SELECT COUNT(*) = 4 FROM t1;
42 COUNT(*) = 4
43 1
44 SHOW BINLOG EVENTS IN 'mysqld-bin.000001' FROM 256;
45 Log_name Pos Event_type Server_id End_log_pos Info
46 mysqld-bin.000001 <Pos> Gtid_list 2 <End_log_pos> []
47 mysqld-bin.000001 <Pos> Binlog_checkpoint 2 <End_log_pos> mysqld-bin.000001
48 mysqld-bin.000001 <Pos> Gtid 1 <End_log_pos> GTID 0-1-1
49 mysqld-bin.000001 <Pos> Query 1 <End_log_pos> use `test`; CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB
50 mysqld-bin.000001 <Pos> Gtid 1 <End_log_pos> BEGIN GTID 0-1-2
51 mysqld-bin.000001 <Pos> Annotate_rows 1 <End_log_pos> INSERT INTO t1 VALUES (1),(2)
52 mysqld-bin.000001 <Pos> Table_map 1 <End_log_pos> table_id: ### (test.t1)
53 mysqld-bin.000001 <Pos> Write_rows_v1 1 <End_log_pos> table_id: ### flags: STMT_END_F
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> Xid 1 <End_log_pos> COMMIT /* xid=### */
57 mysqld-bin.000001 <Pos> Gtid 1 <End_log_pos> BEGIN GTID 0-1-3
58 mysqld-bin.000001 <Pos> Annotate_rows 1 <End_log_pos> INSERT INTO t1 VALUES (3),(4)
59 mysqld-bin.000001 <Pos> Table_map 1 <End_log_pos> table_id: ### (test.t1)
60 mysqld-bin.000001 <Pos> Write_rows_v1 1 <End_log_pos> table_id: ### flags: STMT_END_F
61 mysqld-bin.000001 <Pos> Xid 1 <End_log_pos> COMMIT /* xid=### */
62 connection node_1;
63 DROP TABLE t1;