Debian Codegraph @

mysql-test/suite/rpl_gtid/r/rpl_gtid_replica_skip_errors_myisam.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 #
7 # Initialize
8 #
9 [connection slave]
10 include/suppress_messages.inc
11 # Connection 2 suppresses message <Replica SQL for channel .*: Worker 1 failed executing transaction.*>.
12 #
13 # R6.1 INSERT fails because row exists: ROW (MyISAM)
14 #
15 [connection master]
16 CREATE TABLE t (a INT PRIMARY KEY) ENGINE = MyISAM;
17 include/sync_slave_sql_with_master.inc
18 INSERT INTO t VALUES (1);
19 include/save_binlog_position.inc
20 [connection master]
21 INSERT INTO t VALUES (1);
22 include/sync_slave_sql_with_master.inc
23 include/assert_binlog_events.inc [Gtid # Query/BEGIN # Query/COMMIT]
24 include/save_binlog_position.inc
25 #
26 # R7.1 INSERT fails because table does not exist: ROW (MyISAM)
27 #
28 [connection slave]
29 DROP TABLE t;
30 include/save_binlog_position.inc
31 [connection master]
32 INSERT INTO t VALUES (2);
33 include/sync_slave_sql_with_master.inc
34 include/assert_binlog_events.inc [Gtid # Query/BEGIN # Query/COMMIT]
35 [connection master]
36 DROP TABLE IF EXISTS t;
37 include/sync_slave_sql_with_master.inc
38 #
39 # R6.2 INSERT fails because row exists: STATEMENT (MyISAM)
40 #
41 [connection master]
42 CREATE TABLE t (a INT PRIMARY KEY) ENGINE = MyISAM;
43 include/sync_slave_sql_with_master.inc
44 INSERT INTO t VALUES (1);
45 include/save_binlog_position.inc
46 [connection master]
47 INSERT INTO t VALUES (1);
48 include/sync_slave_sql_with_master.inc
49 include/assert_binlog_events.inc [Gtid # Query/BEGIN # Query/COMMIT]
50 include/save_binlog_position.inc
51 #
52 # R7.2 INSERT fails because table does not exist: STATEMENT (MyISAM)
53 #
54 [connection slave]
55 DROP TABLE t;
56 include/save_binlog_position.inc
57 [connection master]
58 INSERT INTO t VALUES (2);
59 include/sync_slave_sql_with_master.inc
60 include/assert_binlog_events.inc [Gtid # Query/BEGIN # Query/COMMIT]
61 [connection master]
62 DROP TABLE IF EXISTS t;
63 include/sync_slave_sql_with_master.inc
64 #
65 # Clean up
66 #
67 include/rpl_end.inc