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 master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
[connection master]
call mtr.add_suppression("Slave SQL: .*Could not execute Update_rows event on table test.t1; Can't find record in 't1', Error_code: 1032; handler error HA_ERR_END_OF_FILE; the event's master log master-bin.[0-9]*, end_log_pos [0-9]*, Error_code: 1032");
call mtr.add_suppression("Slave: Can't find record in 't1' Error_code: 1032");
call mtr.add_suppression("Slave SQL: .*Could not execute Delete_rows event on table test.t1; Can't find record in 't1', Error_code: 1032; handler error HA_ERR_END_OF_FILE; the event's master log master-bin.[0-9]*, end_log_pos [0-9]*, Error_code: 1032");
call mtr.add_suppression("Slave SQL: ... The slave coordinator and worker threads are stopped, possibly leaving data in inconsistent state. A restart should restore consistency automatically, although using non-transactional storage for data or info tables or DDL queries could lead to problems. In such cases you have to examine your data (see documentation for details). Error_code: 1756");
Warnings:
Warning	1265	Data truncated for column 'pattern' at row 1
call mtr.add_suppression("Slave SQL: .*Could not execute Delete_rows event on table test.t1; Can't find record in 't1', Error_code: 1032; handler error HA_ERR_END_OF_FILE; the event's master log FIRST, end_log_pos [0-9]*, Error_code: 1032");
SET @saved_slave_rows_search_algorithms= @@global.slave_rows_search_algorithms;
SET GLOBAL slave_rows_search_algorithms= 'INDEX_SCAN,HASH_SCAN';
CREATE TABLE t1 (a INT);
INSERT INTO t1 VALUES (1), (1), (2), (3);
include/sync_slave_sql_with_master.inc
DELETE FROM t1;
INSERT INTO t1 VALUES (2), (1), (3), (1);
UPDATE t1 SET a=1000 WHERE a=1;
include/sync_slave_sql_with_master.inc
include/diff_tables.inc [master:test.t1, slave:test.t1]
DELETE FROM t1 WHERE a=1000;
DELETE FROM t1 WHERE a=2 OR a=3;
include/sync_slave_sql_with_master.inc
include/diff_tables.inc [master:test.t1, slave:test.t1]
DROP TABLE  t1;
include/sync_slave_sql_with_master.inc
include/rpl_reset.inc
SET SQL_LOG_BIN=0;
CREATE TABLE t1 (a INT, b INT);
SET SQL_LOG_BIN=1;
CREATE TABLE t1 (a INT);
INSERT INTO t1 VALUES (1,1), (1,2), (2,1), (2,2);
UPDATE t1 SET a=1000 WHERE a=1;
SELECT * FROM t1;
a	b
1000	1
1000	2
2	1
2	2
include/sync_slave_sql_with_master.inc
SELECT * FROM t1;
a
1000
1000
2
2
DELETE FROM t1 WHERE a=1000;
DELETE FROM t1 WHERE a=2;
SELECT * FROM t1;
a	b
include/sync_slave_sql_with_master.inc
SELECT * FROM t1;
a
DROP TABLE  t1;
include/sync_slave_sql_with_master.inc
include/rpl_reset.inc
CREATE TABLE t1 (a INT);
INSERT INTO t1 VALUES (1), (1), (2), (3);
include/sync_slave_sql_with_master.inc
DELETE FROM t1 WHERE a=1;
DELETE FROM t1 WHERE a=2;
UPDATE t1 SET a=1000 WHERE a=1;
include/wait_for_slave_sql_error_and_skip.inc [errno=1032]
DELETE FROM t1 WHERE a=2;
include/wait_for_slave_sql_error_and_skip.inc [errno=1032]
DROP TABLE t1;
include/sync_slave_sql_with_master.inc
include/rpl_reset.inc
CREATE TABLE t1 (a INT, b TINYBLOB);
INSERT INTO t1 VALUES (1,'a'), (1, 'b'), (2,'aa'), (2, 'aa');
UPDATE t1 SET b='c' WHERE a=1;
include/sync_slave_sql_with_master.inc
include/diff_tables.inc [master:test.t1, slave:test.t1]
UPDATE t1 SET a=10000 WHERE b='aa';
include/sync_slave_sql_with_master.inc
include/diff_tables.inc [master:test.t1, slave:test.t1]
UPDATE t1 SET b='c' WHERE b='aa';
include/sync_slave_sql_with_master.inc
include/diff_tables.inc [master:test.t1, slave:test.t1]
DELETE FROM t1 WHERE b='c';
include/sync_slave_sql_with_master.inc
include/diff_tables.inc [master:test.t1, slave:test.t1]
DROP TABLE  t1;
include/sync_slave_sql_with_master.inc
include/rpl_reset.inc
CREATE TABLE t1 (a TINYBLOB, b TINYBLOB);
INSERT INTO t1 VALUES ('a','a'), ('b', 'b'), ('a','aa'), ('a', 'aa');
UPDATE t1 SET b='c' WHERE b='aa';
include/sync_slave_sql_with_master.inc
include/diff_tables.inc [master:test.t1, slave:test.t1]
DELETE FROM t1;
include/sync_slave_sql_with_master.inc
include/diff_tables.inc [master:test.t1, slave:test.t1]
INSERT INTO t1 VALUES (NULL,NULL), (NULL, NULL);
DELETE FROM t1;
include/sync_slave_sql_with_master.inc
include/diff_tables.inc [master:test.t1, slave:test.t1]
DROP TABLE  t1;
include/sync_slave_sql_with_master.inc
SET @@global.slave_rows_search_algorithms= @saved_slave_rows_search_algorithms;
include/rpl_end.inc
