Debian Codegraph @

mysql-test/suite/rpl/r/rpl_mariadb_slave_capability.result

raw
1 include/master-slave.inc
2 [connection master]
3 connection master;
4 set @old_master_binlog_checksum= @@global.binlog_checksum;
5 connection slave;
6 include/stop_slave.inc
7 CHANGE MASTER TO MASTER_USE_GTID=NO;
8 include/start_slave.inc
9 connection master;
10 # Ensure only the new binlog dump thread is alive (wait for the old one
11 # to complete its kill)
12 # And that it has already sent its fake rotate
13 connection slave;
14 include/stop_slave.inc
15 # Test slave with no capability gets dummy event, which is ignored.
16 set @old_dbug= @@global.debug_dbug;
17 SET @@global.debug_dbug='+d,simulate_slave_capability_none';
18 include/start_slave.inc
19 connection master;
20 FLUSH LOGS;
21 CREATE TABLE t1 (a INT PRIMARY KEY);
22 INSERT INTO t1 VALUES (0);
23 connection slave;
24 connection master;
25 ALTER TABLE t1 ORDER BY a;
26 connection slave;
27 connection slave;
28 connection master;
29 SET SESSION binlog_annotate_row_events = ON;
30 DELETE FROM t1;
31 INSERT INTO t1 /* A comment just to make the annotate event sufficiently long that the dummy event will need to get padded with spaces so that we can test that this works */ VALUES(1);
32 include/show_binlog_events.inc
33 Log_name Pos Event_type Server_id End_log_pos Info
34 master-bin.000002 # Gtid # # BEGIN GTID #-#-#
35 master-bin.000002 # Annotate_rows # # DELETE FROM t1
36 master-bin.000002 # Table_map # # table_id: # (test.t1)
37 master-bin.000002 # Delete_rows_v1 # # table_id: # flags: STMT_END_F
38 master-bin.000002 # Query # # COMMIT
39 master-bin.000002 # Gtid # # BEGIN GTID #-#-#
40 master-bin.000002 # Annotate_rows # # INSERT INTO t1 /* A comment just to make the annotate event sufficiently long that the dummy event will need to get padded with spaces so that we can test that this works */ VALUES(1)
41 master-bin.000002 # Table_map # # table_id: # (test.t1)
42 master-bin.000002 # Write_rows_v1 # # table_id: # flags: STMT_END_F
43 master-bin.000002 # Query # # COMMIT
44 connection slave;
45 connection slave;
46 SELECT * FROM t1;
47 a
48 1
49 include/show_events.inc
50 Log_name Pos Event_type Server_id End_log_pos Info
51 slave-relay-bin.000005 # Query # # BEGIN
52 slave-relay-bin.000005 # Annotate_rows # # DELETE FROM t1
53 slave-relay-bin.000005 # Table_map # # table_id: # (test.t1)
54 slave-relay-bin.000005 # Delete_rows_v1 # # table_id: # flags: STMT_END_F
55 slave-relay-bin.000005 # Query # # COMMIT
56 slave-relay-bin.000005 # Query # # BEGIN
57 slave-relay-bin.000005 # Annotate_rows # # INSERT INTO t1 /* A comment just to make the annotate event sufficiently long that the dummy event will need to get padded with spaces so that we can test that this works */ VALUES(1)
58 slave-relay-bin.000005 # Table_map # # table_id: # (test.t1)
59 slave-relay-bin.000005 # Write_rows_v1 # # table_id: # flags: STMT_END_F
60 slave-relay-bin.000005 # Query # # COMMIT
61 set @@global.debug_dbug= @old_dbug;
62 # Test dummy event is checksummed correctly.
63 connection master;
64 set @@global.binlog_checksum = CRC32;
65 TRUNCATE t1;
66 INSERT INTO t1 VALUES(2);
67 include/show_binlog_events.inc
68 Log_name Pos Event_type Server_id End_log_pos Info
69 master-bin.000003 # Gtid # # BEGIN GTID #-#-#
70 master-bin.000003 # Annotate_rows # # INSERT INTO t1 VALUES(2)
71 master-bin.000003 # Table_map # # table_id: # (test.t1)
72 master-bin.000003 # Write_rows_v1 # # table_id: # flags: STMT_END_F
73 master-bin.000003 # Query # # COMMIT
74 connection slave;
75 connection slave;
76 SELECT * FROM t1;
77 a
78 2
79 include/show_events.inc
80 Log_name Pos Event_type Server_id End_log_pos Info
81 slave-relay-bin.000007 # Query # # BEGIN
82 slave-relay-bin.000007 # Annotate_rows # # INSERT INTO t1 VALUES(2)
83 slave-relay-bin.000007 # Table_map # # table_id: # (test.t1)
84 slave-relay-bin.000007 # Write_rows_v1 # # table_id: # flags: STMT_END_F
85 slave-relay-bin.000007 # Query # # COMMIT
86 *** MDEV-5754: MySQL 5.5 slaves cannot replicate from MariaDB 10.0 ***
87 connection master;
88 CREATE TABLE t2 (a INT PRIMARY KEY) ENGINE=InnoDB;
89 INSERT INTO t2 VALUES(100);
90 connect con1,127.0.0.1,root,,test,$SERVER_MYPORT_1,;
91 SET debug_sync='commit_after_release_LOCK_prepare_ordered SIGNAL master_queued1 WAIT_FOR master_cont1';
92 INSERT INTO t2 VALUES (1);
93 connection master;
94 SET debug_sync='now WAIT_FOR master_queued1';
95 connect con2,127.0.0.1,root,,test,$SERVER_MYPORT_1,;
96 SET debug_sync='commit_after_release_LOCK_prepare_ordered SIGNAL master_queued2';
97 INSERT INTO t2 VALUES (2);
98 connection master;
99 SET debug_sync='now WAIT_FOR master_queued2';
100 SET debug_sync='now SIGNAL master_cont1';
101 connection con1;
102 SET debug_sync='RESET';
103 connection con2;
104 SET debug_sync='RESET';
105 connection master;
106 SET debug_sync='RESET';
107 include/show_binlog_events.inc
108 Log_name Pos Event_type Server_id End_log_pos Info
109 master-bin.000003 # Gtid # # BEGIN GTID #-#-# cid=#
110 master-bin.000003 # Annotate_rows # # INSERT INTO t2 VALUES (1)
111 master-bin.000003 # Table_map # # table_id: # (test.t2)
112 master-bin.000003 # Write_rows_v1 # # table_id: # flags: STMT_END_F
113 master-bin.000003 # Xid # # COMMIT /* XID */
114 master-bin.000003 # Gtid # # BEGIN GTID #-#-# cid=#
115 master-bin.000003 # Annotate_rows # # INSERT INTO t2 VALUES (2)
116 master-bin.000003 # Table_map # # table_id: # (test.t2)
117 master-bin.000003 # Write_rows_v1 # # table_id: # flags: STMT_END_F
118 master-bin.000003 # Xid # # COMMIT /* XID */
119 connection slave;
120 SELECT * FROM t2 ORDER BY a;
121 a
122 1
123 2
124 100
125 # Test that slave which cannot tolerate holes in binlog stream but
126 # knows the event does not get dummy event
127 include/stop_slave.inc
128 SET @@global.debug_dbug='+d,simulate_slave_capability_old_53';
129 include/start_slave.inc
130 connection master;
131 ALTER TABLE t1 ORDER BY a;
132 connection slave;
133 connection slave;
134 connection master;
135 UPDATE t1 SET a = 3;
136 include/show_binlog_events.inc
137 Log_name Pos Event_type Server_id End_log_pos Info
138 master-bin.000003 # Gtid # # BEGIN GTID #-#-#
139 master-bin.000003 # Annotate_rows # # UPDATE t1 SET a = 3
140 master-bin.000003 # Table_map # # table_id: # (test.t1)
141 master-bin.000003 # Update_rows_v1 # # table_id: # flags: STMT_END_F
142 master-bin.000003 # Query # # COMMIT
143 connection slave;
144 connection slave;
145 SELECT * FROM t1;
146 a
147 3
148 include/show_events.inc
149 Log_name Pos Event_type Server_id End_log_pos Info
150 slave-relay-bin.000008 # Query # # BEGIN
151 slave-relay-bin.000008 # Annotate_rows # # UPDATE t1 SET a = 3
152 slave-relay-bin.000008 # Table_map # # table_id: # (test.t1)
153 slave-relay-bin.000008 # Update_rows_v1 # # table_id: # flags: STMT_END_F
154 slave-relay-bin.000008 # Query # # COMMIT
155 select @@global.log_slave_updates;
156 @@global.log_slave_updates
157 1
158 select @@global.replicate_annotate_row_events;
159 @@global.replicate_annotate_row_events
160 1
161 Clean up.
162 connection master;
163 set @@global.binlog_checksum = @old_master_binlog_checksum;
164 DROP TABLE t1, t2;
165 connection slave;
166 set @@global.debug_dbug= @old_dbug;
167 include/rpl_end.inc