Debian Codegraph @

mysql-test/suite/rpl/r/rpl_gtid_events.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 ==== Initialize ====
7 ==== Test presence of transaction events ====
8 include/save_binlog_position.inc
9 CREATE TABLE t1 (a VARCHAR(10000));
10 include/assert_binlog_events.inc
11 include/save_binlog_position.inc
12 INSERT INTO t1 VALUES ('1');
13 include/assert_binlog_events.inc
14 ==== Generate new binary logs in many ways ====
15 ---- RESET MASTER ----
16 include/stop_slave.inc
17 RESET SLAVE;
18 Warnings:
19 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
20 RESET MASTER;
21 RESET MASTER;
22 INSERT INTO t1 VALUES ('2');
23 include/start_slave_io.inc
24 ---- FLUSH LOGS ----
25 FLUSH LOGS;
26 INSERT INTO t1 VALUES ('3');
27 ---- Grow over the limit ----
28 SET @@GLOBAL.MAX_BINLOG_SIZE= 4096;
29 INSERT INTO t1 VALUES ('<LONG_TEXT>');
30 SET @@GLOBAL.MAX_BINLOG_SIZE= 1073741824;
31 INSERT INTO t1 VALUES ('4');
32 ---- Restart server ----
33 include/sync_slave_io_with_master.inc
34 include/stop_slave_io.inc
35 include/rpl_restart_server.inc [server_number=1]
36 INSERT INTO t1 VALUES ('5');
37 ==== Generate new relay logs in many ways ====
38 ---- Reconnect receiver thread ----
39 include/save_master_pos.inc
40 include/start_slave_io.inc
41 include/sync_slave_io.inc
42 include/stop_slave_io.inc
43 SET @@GLOBAL.MAX_RELAY_LOG_SIZE= 4096;
44 include/start_slave_io.inc
45 INSERT INTO t1 VALUES ('6');
46 include/sync_slave_io_with_master.inc
47 ---- FLUSH RELAY LOGS ----
48 FLUSH RELAY LOGS;
49 INSERT INTO t1 VALUES ('7');
50 include/sync_slave_io_with_master.inc
51 ---- Grow over the limit ----
52 INSERT INTO t1 VALUES ('<LONG_TEXT>');
53 INSERT INTO t1 VALUES ('8');
54 include/sync_slave_io_with_master.inc
55 ---- Restart slave server ----
56 include/rpl_restart_server.inc [server_number=2]
57 include/start_slave_io.inc
58 INSERT INTO t1 VALUES ('9');
59 include/sync_slave_io_with_master.inc
60 ==== Test that binary logs contain Previous_gtids ====
61 SET SQL_LOG_BIN= 0;
62 CREATE TEMPORARY TABLE binlogs
63 (id INT PRIMARY KEY AUTO_INCREMENT, filename VARCHAR(512));
64 include/rpl_read_binlog_index_into_table.inc
65 master-bin.000001
66 include/assert_binlog_events.inc [Format_desc # Previous_gtids(.|#)*]
67 master-bin.000002
68 include/assert_binlog_events.inc [Format_desc # Previous_gtids(.|#)*]
69 master-bin.000003
70 include/assert_binlog_events.inc [Format_desc # Previous_gtids(.|#)*]
71 master-bin.000004
72 include/assert_binlog_events.inc [Format_desc # Previous_gtids(.|#)*]
73 DROP TEMPORARY TABLE binlogs;
74 SET SQL_LOG_BIN= 1;
75 ==== Test that relay logs contain Previous_gtids ====
76 SET SQL_LOG_BIN= 0;
77 CREATE TEMPORARY TABLE relay_logs
78 (id INT PRIMARY KEY AUTO_INCREMENT, filename VARCHAR(512));
79 include/rpl_read_binlog_index_into_table.inc
80 include/assert_binlog_events.inc [Format_desc # Previous_gtids(.|#)*]
81 include/assert_binlog_events.inc [Format_desc # Previous_gtids(.|#)*]
82 include/assert_binlog_events.inc [Format_desc # Previous_gtids(.|#)*]
83 include/assert_binlog_events.inc [Format_desc # Previous_gtids(.|#)*]
84 include/assert_binlog_events.inc [Format_desc # Previous_gtids(.|#)*]
85 include/assert_binlog_events.inc [Format_desc # Previous_gtids(.|#)*]
86 include/assert_binlog_events.inc [Format_desc # Previous_gtids(.|#)*]
87 include/assert_binlog_events.inc [Format_desc # Previous_gtids(.|#)*]
88 include/assert_binlog_events.inc [Format_desc # Previous_gtids(.|#)*]
89 include/assert_binlog_events.inc [Format_desc # Previous_gtids(.|#)*]
90 include/assert_binlog_events.inc [Format_desc # Previous_gtids(.|#)*]
91 include/assert_binlog_events.inc [Format_desc # Previous_gtids(.|#)*]
92 include/assert_binlog_events.inc [Format_desc # Previous_gtids(.|#)*]
93 include/assert_binlog_events.inc [Format_desc # Previous_gtids(.|#)*]
94 DROP TEMPORARY TABLE relay_logs;
95 SET SQL_LOG_BIN= 1;
96 ==== Clean up ====
97 include/start_slave_sql.inc
98 DROP TABLE t1;
99 include/rpl_end.inc