Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 CALL mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT.");
4 CALL mtr.add_suppression("Failed to open the existing info file");
5 CALL mtr.add_suppression("Error while reading from connection metadata repository");
6 CALL mtr.add_suppression("Failed to create a new info file");
7 CALL mtr.add_suppression("The replica coordinator and worker threads are stopped, possibly leaving data in inconsistent state");
8 start slave;
9 Got one of the listed errors
10 start slave;
11 ERROR HY000: Could not initialize connection metadata structure; more error messages can be found in the MySQL error log
12 CHANGE REPLICATION SOURCE to SOURCE_HOST='127.0.0.1',SOURCE_PORT=MASTER_PORT, SOURCE_USER='root';
13 ERROR HY000: Could not initialize connection metadata structure; more error messages can be found in the MySQL error log
14 reset slave;
15 Warnings:
16 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
17 CHANGE REPLICATION SOURCE to SOURCE_HOST='127.0.0.1',SOURCE_PORT=MASTER_PORT, SOURCE_USER='root';
18 Warnings:
19 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
20 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.
21 reset master;
22 start slave;
23 Warnings:
24 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
25 include/wait_for_slave_to_start.inc
26 create temporary table temp_table (a char(80) not null);
27 insert into temp_table values ("testing temporary tables");
28 create table t1 (s text);
29 insert into t1 values('Could not break slave'),('Tried hard');
30 include/sync_slave_sql_with_master.inc
31 Master_Log_File = 'master-bin.000001'
32 Relay_Master_Log_File = 'master-bin.000001'
33 include/check_slave_is_running.inc
34 include/assert.inc [Table t1 should contain the first inserted line]
35 include/assert.inc [Table t1 should contain the second inserted line]
36 flush logs;
37 create table t2(m int not null auto_increment primary key);
38 insert into t2 values (34),(67),(123);
39 flush logs;
40 show binary logs;
41 Log_name File_size Encrypted
42 master-bin.000001 # #
43 master-bin.000002 # #
44 master-bin.000003 # #
45 create table t3 select * from temp_table;
46 include/sync_slave_sql_with_master.inc
47 include/assert.inc [Data in t3 should be equal to temp_table]
48 drop table temp_table, t3;
49 include/sync_slave_sql_with_master.inc
50 insert into t2 values(1234);
51 set insert_id=1234;
52 insert into t2 values(NULL);
53 call mtr.add_suppression("Replica SQL.*Error .Duplicate entry .1234. for key .t2.PRIMARY.. on query.* Error_code: MY-001062");
54 include/wait_for_slave_sql_error_and_skip.inc [errno=1062]
55 include/sync_slave_sql_with_master.inc
56 purge master logs to 'master-bin.000002';
57 show master logs;
58 Log_name master-bin.000002
59 File_size #
60 Encrypted #
61 Log_name master-bin.000003
62 File_size #
63 Encrypted #
64 purge binary logs to 'master-bin.000002';
65 show binary logs;
66 Log_name File_size Encrypted
67 master-bin.000002 # #
68 master-bin.000003 # #
69 SELECT @time_for_purge:=DATE_ADD('tmpval', INTERVAL 1 SECOND);
70 purge master logs before (@time_for_purge);
71 Warnings:
72 Warning 1868 file master-bin.000003 was not purged because it is the active log file.
73 show binary logs;
74 Log_name File_size Encrypted
75 master-bin.000003 # #
76 insert into t2 values (65);
77 include/sync_slave_sql_with_master.inc
78 Master_Log_File = 'master-bin.000003'
79 Relay_Master_Log_File = 'master-bin.000003'
80 include/check_slave_is_running.inc
81 include/assert.inc [Table t2 should still contain the first inserted line after creation]
82 include/assert.inc [Table t2 should contain the line inserted after the purge]
83 include/assert.inc [Table t2 should still contain the second insert line after creation]
84 include/assert.inc [Table t2 should still contain the third inserted line after creation]
85 include/assert.inc [Table t2 should still contain the line from the duplicated key test]
86 create temporary table temp_table (a char(80) not null);
87 insert into temp_table values ("testing temporary tables part 2");
88 create table t3 (n int);
89 include/assert.inc [Table t3 should contain 90 lines on the master]
90 create table t4 select * from temp_table;
91 include/sync_slave_sql_with_master.inc
92 include/assert.inc [Data in t4 should be equal to temp_table]
93 include/check_slave_is_running.inc
94 lock tables t3 read;
95 include/assert.inc [Table t3 should contain 90 lines on the slave]
96 unlock tables;
97 drop table if exists t1,t2,t3,t4;
98 drop temporary table temp_table;
99 include/sync_slave_sql_with_master.inc
100 End of 4.1 tests
101 show binlog events in 'non existing_binlog_file';
102 ERROR HY000: Error when executing command SHOW BINLOG EVENTS: Could not find target log
103 purge master logs before now();
104 Warnings:
105 Warning 1868 file slave-bin.000001 was not purged because it is the active log file.
106 show binlog events in '';
107 ERROR HY000: Error when executing command SHOW BINLOG EVENTS: Could not find target log
108 purge master logs before now();
109 Warnings:
110 Warning 1868 file slave-bin.000001 was not purged because it is the active log file.
111 End of 5.0 tests
112 include/rpl_end.inc