Debian Codegraph @

mysql-test/suite/rpl_nogtid/r/rpl_manual_change_index_file.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 CALL mtr.add_suppression("Failed to open log");
7 FLUSH LOGS;
8 CREATE TABLE t1(c1 INT);
9 include/sync_slave_sql_with_master.inc
10 FLUSH LOGS;
11 call mtr.add_suppression('Got fatal error 1236 from source when reading data from binary log: .*could not find next log');
12 include/wait_for_slave_io_error.inc [errno=13114]
13 Last_IO_Error = 'Got fatal error 1236 from source when reading data from binary log: 'could not find next log; the first event '' at XXX, the last event read from './master-bin.000002' at XXX, the last byte read from './master-bin.000002' at XXX.''
14 CREATE TABLE t2(c1 INT);
15 FLUSH LOGS;
16 CREATE TABLE t3(c1 INT);
17 FLUSH LOGS;
18 CREATE TABLE t4(c1 INT);
19 START SLAVE IO_THREAD;
20 Warnings:
21 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
22 include/wait_for_slave_io_to_start.inc
23 include/sync_slave_sql_with_master.inc
24 SHOW TABLES;
25 Tables_in_test
26 t1
27 t2
28 t3
29 t4
30 DROP TABLE t1, t2, t3, t4;
31 include/sync_slave_sql_with_master.inc
32
33 # BUG#21437 server_errno=29 error message flood mysqld error log
34 # --------------------------------------------------------------------------
35 # This test verifies if the ER_SOURCE_FATAL_ERROR_READING_BINLOG which
36 # insteads of EE_FILENOTFOUND error is sent to slave, so that the slave
37 # I/O thread stops immediately.
38 include/rpl_reset.inc
39 [ on master ]
40 call mtr.add_suppression("Got fatal error 1236 from source when reading data from binary log:");
41 CREATE TABLE t1(c1 int);
42 DROP TABLE t1;
43 FLUSH LOGS;
44 CREATE TABLE t2(c1 int);
45 DROP TABLE t2;
46 include/sync_slave_sql_with_master.inc
47 [ on slave ]
48 include/stop_slave.inc
49 [ on master ]
50 # This operation will result in error EE_FILENOTFOUND which happens
51 # when slave IO thread is connecting to master.
52 [ on slave ]
53 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_LOG_FILE='master-bin.000001';
54 Warnings:
55 Warning 3023 CHANGE REPLICATION SOURCE TO with a SOURCE_LOG_FILE clause but no SOURCE_LOG_POS clause may not be safe. The old position value may not be valid for the new binary log file.
56 START SLAVE IO_THREAD;
57 Warnings:
58 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
59 # Instead of EE_FILENOTFOUND, ER_SERVER_SOURCE_FATAL_ERROR_READING_BINLOG
60 # and the specific information are sent to slave.
61 include/wait_for_slave_io_error.inc [errno=13114]
62 Last_IO_Error = 'Got fatal error 1236 from source when reading data from binary log: 'Could not open log file''
63 [ on master ]
64 # Restore master-bin.000001 file
65 [ on slave ]
66 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_LOG_FILE='master-bin.000002';
67 Warnings:
68 Warning 3023 CHANGE REPLICATION SOURCE TO with a SOURCE_LOG_FILE clause but no SOURCE_LOG_POS clause may not be safe. The old position value may not be valid for the new binary log file.
69 include/start_slave.inc
70 [ on master ]
71 CREATE TABLE t1(c1 INT);
72 include/sync_slave_sql_with_master.inc
73 [ on slave ]
74 SELECT * FROM t1;
75 c1
76 DROP TABLE t1;
77 include/rpl_end.inc