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
|
# Bug#47699 rpl.rpl_backup_block fails sporadically
#
# START SLAVE released the lock and returned before it cleared the error,
# so there is a possibility that Slave_SQL_Error is not 0.
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]
[on slave]
CALL mtr.add_suppression("Replica: Table 't1' already exists Error_code: MY-001050");
CALL mtr.add_suppression("Replica SQL for channel '': .*Error .Table .t1. already exists. on query.* Error_code: MY-001050");
call mtr.add_suppression("The replica coordinator and worker threads are stopped, possibly leaving data in inconsistent state");
# The statement makes SQL thread to fail.
CREATE TABLE t1(c1 INT);
[on master]
CREATE TABLE t1(c1 INT);
[on slave]
include/wait_for_slave_sql_error.inc [errno=1050]
DROP TABLE t1;
# Block SQL thread immediately after it starts.
SET DEBUG_SYNC='after_start_replica WAIT_FOR signal.continue';
START SLAVE SQL_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_sql_to_start.inc
# Check Slave_SQL_Error, there should not be an error.
include/check_slave_no_error.inc
# Resume SQL thread
SET DEBUG_SYNC="now SIGNAL signal.continue";
[on master]
DROP TABLE t1;
include/rpl_end.inc
|
