Edit File: rpl_row_hash_scan.result
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