Debian Codegraph @

mysql-test/suite/rpl_gtid/r/rpl_gtids_restart_slave_io_lost_trx.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(i INT) ENGINE=InnoDB;
7 FLUSH LOGS;
8 include/sync_slave_sql_with_master.inc
9 SET @save_debug=@@global.debug;
10 SET GLOBAL DEBUG='d,stop_io_after_reading_gtid_log_event';
11 BEGIN;
12 INSERT INTO t1 VALUES (1);
13 SET @v= 1 * 100;
14 INSERT INTO t1 VALUES (@v);
15 COMMIT;
16 include/wait_for_slave_io_to_stop.inc
17 SET GLOBAL DEBUG= @save_debug;
18 include/start_slave_io.inc
19 INSERT INTO t1 VALUES (1);
20 include/sync_slave_sql_with_master.inc
21 include/diff_tables.inc [master:t1, slave:t1]
22 SET GLOBAL DEBUG='d,stop_io_after_reading_query_log_event';
23 BEGIN;
24 INSERT INTO t1 VALUES (2);
25 SET @v= 2 * 100;
26 INSERT INTO t1 VALUES (@v);
27 COMMIT;
28 include/wait_for_slave_io_to_stop.inc
29 SET GLOBAL DEBUG= @save_debug;
30 include/start_slave_io.inc
31 INSERT INTO t1 VALUES (2);
32 include/sync_slave_sql_with_master.inc
33 include/diff_tables.inc [master:t1, slave:t1]
34 include/stop_slave_sql.inc
35 SET GLOBAL DEBUG='d,stop_io_after_reading_xid_log_event';
36 BEGIN;
37 INSERT INTO t1 VALUES (3);
38 SET @v= 3 * 100;
39 INSERT INTO t1 VALUES (@v);
40 COMMIT;
41 include/wait_for_slave_io_to_stop.inc
42 SET GLOBAL DEBUG= @save_debug;
43 include/start_slave_io.inc
44 include/start_slave_sql.inc
45 INSERT INTO t1 VALUES (3);
46 include/sync_slave_sql_with_master.inc
47 include/diff_tables.inc [master:t1, slave:t1]
48 BEGIN;
49 INSERT INTO t1 VALUES (4);
50 SET @v= 4 * 100;
51 INSERT INTO t1 VALUES (@v);
52 COMMIT;
53 include/sync_slave_sql_with_master.inc
54 include/stop_slave_io.inc
55 include/wait_for_slave_io_to_stop.inc
56 SET GLOBAL DEBUG= @save_debug;
57 include/start_slave_io.inc
58 INSERT INTO t1 VALUES (4);
59 include/sync_slave_sql_with_master.inc
60 include/diff_tables.inc [master:t1, slave:t1]
61 SET GLOBAL DEBUG='d,stop_io_after_reading_user_var_log_event';
62 BEGIN;
63 INSERT INTO t1 VALUES (5);
64 SET @v= 5 * 100;
65 INSERT INTO t1 VALUES (@v);
66 COMMIT;
67 include/wait_for_slave_io_to_stop.inc
68 SET GLOBAL DEBUG= @save_debug;
69 include/start_slave_io.inc
70 INSERT INTO t1 VALUES (5);
71 include/sync_slave_sql_with_master.inc
72 include/diff_tables.inc [master:t1, slave:t1]
73 DROP TABLE t1;
74 include/rpl_end.inc