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