Debian Codegraph @

mysql-test/suite/galera/r/rpl_row_annotate.result

raw
1 connection node_2;
2 connection node_1;
3 # On node_2
4 connection node_2;
5 SET GLOBAL wsrep_on=OFF;
6 RESET MASTER;
7 SET GLOBAL wsrep_on=ON;
8 # On node_1
9 connection node_1;
10 SET GLOBAL wsrep_on=OFF;
11 RESET MASTER;
12 SET GLOBAL wsrep_on=ON;
13 CREATE TABLE t1(i INT)ENGINE=INNODB;
14 INSERT INTO t1 VALUES(1);
15 DELETE FROM t1 WHERE i = 1;
16 # On node_2
17 connection node_2;
18 INSERT INTO t1 VALUES(2);
19 DELETE FROM t1 WHERE i = 2;
20 # On node_1
21 connection node_1;
22 SHOW BINLOG EVENTS IN 'mysqld-bin.000001' FROM <start_pos>;
23 Log_name Pos Event_type Server_id End_log_pos Info
24 mysqld-bin.000001 # Gtid_list 1 # []
25 mysqld-bin.000001 # Binlog_checkpoint 1 # mysqld-bin.000001
26 mysqld-bin.000001 # Gtid 1 # GTID 0-1-1
27 mysqld-bin.000001 # Query 1 # use `test`; CREATE TABLE t1(i INT)ENGINE=INNODB
28 mysqld-bin.000001 # Gtid 1 # BEGIN GTID 0-1-2
29 mysqld-bin.000001 # Annotate_rows 1 # INSERT INTO t1 VALUES(1)
30 mysqld-bin.000001 # Table_map 1 # table_id: # (test.t1)
31 mysqld-bin.000001 # Write_rows_v1 1 # table_id: # flags: STMT_END_F
32 mysqld-bin.000001 # Xid 1 # COMMIT /* xid= */
33 mysqld-bin.000001 # Gtid 1 # BEGIN GTID 0-1-3
34 mysqld-bin.000001 # Annotate_rows 1 # DELETE FROM t1 WHERE i = 1
35 mysqld-bin.000001 # Table_map 1 # table_id: # (test.t1)
36 mysqld-bin.000001 # Delete_rows_v1 1 # table_id: # flags: STMT_END_F
37 mysqld-bin.000001 # Xid 1 # COMMIT /* xid= */
38 mysqld-bin.000001 # Gtid 2 # BEGIN GTID 0-2-4
39 mysqld-bin.000001 # Annotate_rows 2 # INSERT INTO t1 VALUES(2)
40 mysqld-bin.000001 # Table_map 2 # table_id: # (test.t1)
41 mysqld-bin.000001 # Write_rows_v1 2 # table_id: # flags: STMT_END_F
42 mysqld-bin.000001 # Xid 2 # COMMIT /* xid= */
43 mysqld-bin.000001 # Gtid 2 # BEGIN GTID 0-2-5
44 mysqld-bin.000001 # Annotate_rows 2 # DELETE FROM t1 WHERE i = 2
45 mysqld-bin.000001 # Table_map 2 # table_id: # (test.t1)
46 mysqld-bin.000001 # Delete_rows_v1 2 # table_id: # flags: STMT_END_F
47 mysqld-bin.000001 # Xid 2 # COMMIT /* xid= */
48 # On node_2
49 connection node_2;
50 SHOW BINLOG EVENTS IN 'mysqld-bin.000001' FROM <start_pos>;
51 Log_name Pos Event_type Server_id End_log_pos Info
52 mysqld-bin.000001 # Gtid_list 2 # []
53 mysqld-bin.000001 # Binlog_checkpoint 2 # mysqld-bin.000001
54 mysqld-bin.000001 # Gtid 1 # GTID 0-1-1
55 mysqld-bin.000001 # Query 1 # use `test`; CREATE TABLE t1(i INT)ENGINE=INNODB
56 mysqld-bin.000001 # Gtid 1 # BEGIN GTID 0-1-2
57 mysqld-bin.000001 # Annotate_rows 1 # INSERT INTO t1 VALUES(1)
58 mysqld-bin.000001 # Table_map 1 # table_id: # (test.t1)
59 mysqld-bin.000001 # Write_rows_v1 1 # table_id: # flags: STMT_END_F
60 mysqld-bin.000001 # Xid 1 # COMMIT /* xid= */
61 mysqld-bin.000001 # Gtid 1 # BEGIN GTID 0-1-3
62 mysqld-bin.000001 # Annotate_rows 1 # DELETE FROM t1 WHERE i = 1
63 mysqld-bin.000001 # Table_map 1 # table_id: # (test.t1)
64 mysqld-bin.000001 # Delete_rows_v1 1 # table_id: # flags: STMT_END_F
65 mysqld-bin.000001 # Xid 1 # COMMIT /* xid= */
66 mysqld-bin.000001 # Gtid 2 # BEGIN GTID 0-2-4
67 mysqld-bin.000001 # Annotate_rows 2 # INSERT INTO t1 VALUES(2)
68 mysqld-bin.000001 # Table_map 2 # table_id: # (test.t1)
69 mysqld-bin.000001 # Write_rows_v1 2 # table_id: # flags: STMT_END_F
70 mysqld-bin.000001 # Xid 2 # COMMIT /* xid= */
71 mysqld-bin.000001 # Gtid 2 # BEGIN GTID 0-2-5
72 mysqld-bin.000001 # Annotate_rows 2 # DELETE FROM t1 WHERE i = 2
73 mysqld-bin.000001 # Table_map 2 # table_id: # (test.t1)
74 mysqld-bin.000001 # Delete_rows_v1 2 # table_id: # flags: STMT_END_F
75 mysqld-bin.000001 # Xid 2 # COMMIT /* xid= */
76 DROP TABLE t1;
77 # End of test