Debian Codegraph @

mysql-test/suite/rpl_gtid/r/rpl_repo_conversion_with_invalid_positions.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 # 1. Setup:
8 # Configure the replica channel with GTID_ONLY=1
9 # Restart the replica so it uses FILE repositories
10 [connection slave]
11 CHANGE REPLICATION SOURCE TO REQUIRE_ROW_FORMAT = 1, GTID_ONLY = 1;
12 include/rpl_restart_server.inc [server_number=2 parameters: --relay_log_info_repository=FILE --master_info_repository=FILE --skip_slave_start=0]
13 SET @@GLOBAL.replica_checkpoint_period= 1;
14 #
15 # 2. Add some data to the source
16 # Logs are flushed to cause rotations in the replica making the applier repository point to a deleted file
17 # Collect the info about the binlog file and position at the end
18 [connection master]
19 CREATE TABLE t1(c1 INTEGER) ENGINE= Innodb;
20 INSERT INTO t1 VALUES(1);
21 FLUSH LOGS;
22 INSERT INTO t1 VALUES(2);
23 FLUSH LOGS;
24 INSERT INTO t1 VALUES(3);
25 FLUSH LOGS;
26 include/sync_slave_sql_with_master.inc
27 #
28 # 3. Change the relay_log_info_repository type
29 # Check the lasted information is set in the new repository
30 include/stop_slave.inc
31 SET @@global.relay_log_info_repository="TABLE";
32 Warnings:
33 Warning 1287 '@@relay_log_info_repository' is deprecated and will be removed in a future release.
34 include/assert.inc [The source log file name is up to date in the applier repo]
35 include/assert.inc [The source log position is up to date in the applier repo]
36 include/assert.inc [The source log file name is up to date in the applier repo]
37 #
38 # 4. Change the master_info_repository type
39 # Check the lasted information is set in the new repository
40 SET @@global.master_info_repository="TABLE";
41 Warnings:
42 Warning 1287 '@@master_info_repository' is deprecated and will be removed in a future release.
43 include/assert.inc [The source log file name is up to date in the connection repo]
44 include/assert.inc [The source log position is up to date in the connection repo]
45 #
46 # 5. Start the replica, check that replication is working
47 [connection slave]
48 include/start_slave.inc
49 [connection master]
50 INSERT INTO t1 VALUES(4);
51 include/sync_slave_sql_with_master.inc
52 #
53 # 6. Restart the replica again so it uses FILE repositories.
54 # Check that position related info is marked as invalid
55 include/rpl_restart_server.inc [server_number=2 parameters: --relay_log_info_repository=FILE --master_info_repository=FILE --skip_slave_start=1]
56 include/assert.inc [The source log file name is invalid]
57 include/assert.inc [The source log file position is 0]
58 include/assert.inc [The source log file name in the applier is invalid]
59 include/assert.inc [The source log file position in the applier is 0]
60 #
61 # 7. Convert the repositories
62 # Check that position related info is still marked as invalid
63 SET @@global.relay_log_info_repository="TABLE";
64 Warnings:
65 Warning 1287 '@@relay_log_info_repository' is deprecated and will be removed in a future release.
66 SET @@global.master_info_repository="TABLE";
67 Warnings:
68 Warning 1287 '@@master_info_repository' is deprecated and will be removed in a future release.
69 include/assert.inc [The source log file name is invalid]
70 include/assert.inc [The source log file position is 0]
71 include/assert.inc [The source log file name in the applier is invalid]
72 include/assert.inc [The source log file position in the applier is 0]
73 #
74 # 8. Start the replica, check that replication is working
75 include/start_slave.inc
76 [connection master]
77 INSERT INTO t1 VALUES(5);
78 include/sync_slave_sql_with_master.inc
79 #
80 # 9. Cleanup
81 include/stop_slave.inc
82 CHANGE REPLICATION SOURCE TO REQUIRE_ROW_FORMAT = 0, GTID_ONLY = 0;
83 SET @@GLOBAL.replica_checkpoint_period= REPLICA_CHECKPOINT_PERIOD;
84 include/start_slave.inc
85 [connection master]
86 DROP TABLE t1;
87 include/rpl_end.inc