Debian Codegraph @

mysql-test/suite/ndb_rpl/t/ndb_rpl_3site_no_log_updates.test

raw
1 --source include/have_ndb.inc
2
3 --echo ## BUG#35199996 table map entry for certain table were logged in to the
4 --echo ## binlogs even though the log_replica_updates is disabled
5
6 ## In this setup, server 2 should not log into its binlog the updates
7 ## applied through the relay log including the Table_map event. If the
8 ## Table_map event was logged, it would relay it to server 3 causing
9 ## it to have replication errors, because t1 does not exist in server
10 ## 3 (no create statement was ever applied there)
11
12 # set up circular replication
13 --let $rpl_server_count= 3
14 --let $rpl_topology= 1->2->3->1
15 --source include/rpl_init.inc
16
17 --let $rpl_connection_name= server.1
18 --let $rpl_server_number= 1
19 --source include/rpl_connect.inc
20
21 --let $rpl_connection_name= server.2
22 --let $rpl_server_number= 2
23 --source include/rpl_connect.inc
24 --let $rpl_connection_name= server.2
25 --source include/rpl_connection.inc
26 --source include/save_binlog_position.inc
27 --let $relaylog_file= query_get_value(SHOW REPLICA STATUS, Relay_Log_File, 1)
28 --let $relaylog_position= query_get_value(SHOW REPLICA STATUS, Relay_Log_Pos, 1)
29
30 --let $rpl_connection_name= server.3
31 --let $rpl_server_number= 3
32 --source include/rpl_connect.inc
33
34 --let $rpl_connection_name= server.1
35 --source include/rpl_connection.inc
36
37 --echo # Insert some data
38 CREATE TABLE t1 (a INT PRIMARY KEY, b BLOB) ENGINE = NDB;
39 INSERT INTO t1 VALUES (1, repeat(0x41, 8)),
40 (2, repeat(0x41, 8)),
41 (3, repeat(0x41, 8)),
42 (4, repeat(0x41, 8)),
43 (5, repeat(0x41, 8));
44 SELECT * FROM t1 ORDER BY a;
45 --sync_slave_with_master server.2
46 SELECT * FROM t1 ORDER BY a;
47
48 --let $create_stmt= !Gtid_or_anon # !Q(CREATE.*)
49 --let $insert_stmt= !Gtid_or_anon # !Begin # Table_map/.*t1.* # Table_map # Write_rows # Write_rows # !Commit
50 --let $event_sequence= $create_stmt # $insert_stmt
51 --let $dont_print_pattern= 1
52
53 --echo # server.2 binary log does NOT contain t1 Table_map
54 --let $invert= 1
55 --source include/assert_binlog_events.inc
56
57 --echo # server.2 relay log contains t1 Table_map
58 --let $binlog_position= $relaylog_position
59 --let $binlog_file= $relaylog_file
60 --let $invert= 0
61 --let $relay_log= 1
62 --source include/assert_binlog_events.inc
63
64 --sync_slave_with_master server.3
65 --echo # server.3 should not have t1
66 --error ER_NO_SUCH_TABLE
67 SELECT * FROM t1 ORDER BY a;
68
69 --echo Cleanup
70 --let $rpl_connection_name= server.1
71 --source include/rpl_connection.inc
72 DROP TABLE t1;
73 --source include/rpl_end.inc