Debian Codegraph @

mysql-test/suite/rpl_nogtid/r/rpl_row_corruption.result

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 CREATE TABLE t1_11753004 (c1 INT);
7 CREATE TABLE t2_11753004 (c1 INT);
8 INSERT INTO t1_11753004 VALUES (1);
9 INSERT INTO t2_11753004 VALUES (2);
10 include/sync_slave_sql_with_master.inc
11 call mtr.add_suppression(".*Found table map event mapping table id 0 which was already mapped but with different settings.*");
12 call mtr.add_suppression("The replica coordinator and worker threads are stopped, possibly leaving data in inconsistent state");
13 include/stop_slave.inc
14 SET @save_debug= @@global.debug;
15 SET GLOBAL debug="+d,inject_tblmap_same_id_maps_diff_table";
16 include/start_slave.inc
17 UPDATE t1_11753004, t2_11753004 SET t1_11753004.c1=3, t2_11753004.c1=4 WHERE t1_11753004.c1=1 OR t2_11753004.c1=2;
18 include/wait_for_slave_sql_error.inc [errno=13117]
19 include/stop_slave_io.inc
20 SET GLOBAL debug="-d,inject_tblmap_same_id_maps_diff_table";
21 include/start_slave.inc
22 include/rpl_reset.inc
23 DROP TABLE t1_11753004, t2_11753004;
24 include/sync_slave_sql_with_master.inc
25 include/stop_slave.inc
26 SET GLOBAL debug="+d,inject_tblmap_same_id_maps_diff_table";
27 include/start_slave.inc
28 include/rpl_reset.inc
29 CREATE TABLE t1_11753004 (c1 INT);
30 CREATE TABLE t2_11753004_ign (c1 INT);
31 INSERT INTO t1_11753004 VALUES (1);
32 INSERT INTO t2_11753004_ign VALUES (2);
33 UPDATE t1_11753004, t2_11753004_ign SET t1_11753004.c1=3, t2_11753004_ign.c1=4 WHERE t1_11753004.c1=1 OR t2_11753004_ign.c1=2;
34 include/sync_slave_sql_with_master.inc
35 CREATE TABLE t1 (c1 INT);
36 CREATE TABLE t2 (c1 INT);
37 INSERT INTO t1 VALUES (1);
38 INSERT INTO t2 VALUES (1);
39 BINLOG '
40 SOgWTg8BAAAAbgAAAHIAAAAAAAQANS42LjMtbTUtZGVidWctbG9nAAAAAAAAAAAAAAAAAAAAAAAA
41 AAAAAAAAAAAAAAAAAABI6BZOEzgNAAgAEgAEBAQEEgAAVgAEGggAAAAICAgCAAAAAAVAYI8=
42 '/*!*/;
43 SET GLOBAL debug="+d,inject_tblmap_same_id_maps_diff_table";
44 BINLOG '
45 SOgWThMBAAAAKQAAAAYDAAAAAEIAAAAAAAEABHRlc3QAAnQxAAEDAAE=
46 SOgWThMBAAAAKQAAAC8DAAAAAEMAAAAAAAEABHRlc3QAAnQyAAEDAAE=
47 SOgWThgBAAAAKAAAAFcDAAAAAEIAAAAAAAAAAf///gEAAAD+AwAAAA==
48 SOgWThgBAAAAKAAAAH8DAAAAAEMAAAAAAAEAAf///gEAAAD+BAAAAA==
49 '/*!*/;
50 ERROR HY000: Fatal error: Found table map event mapping table id 0 which was already mapped but with different settings.
51 DROP TABLE t1,t2;
52 SET GLOBAL debug="-d,inject_tblmap_same_id_maps_diff_table";
53 DROP TABLE t1_11753004;
54 DROP TABLE t2_11753004_ign;
55 include/sync_slave_sql_with_master.inc
56 SET GLOBAL debug= @save_debug;
57 include/rpl_end.inc