Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.1.18, 10.2.2
-
None
Description
How to reproduce:
$ perl mtr rpl_blackhole_bug --mysqld=--binlog_annotate_row_events=1 --mysqld=--replicate_annotate_row_events=1
|
Test case:
source include/master-slave.inc;
|
source include/have_blackhole.inc;
|
|
call mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT");
|
|
# We start with no primary key
|
CREATE TABLE t1 (a INT, b INT, c INT);
|
|
sync_slave_with_master;
|
ALTER TABLE t1 ENGINE=BLACKHOLE;
|
|
connection master;
|
INSERT INTO t1 VALUES (1,1,1),(2,1,2),(3,1,3),(4,1,4);
|
--disable_warnings
|
UPDATE t1 SET c = 2 WHERE b = 1;
|
--enable_warnings
|
|
DROP TABLE t1;
|
|
sync_slave_with_master;
|
source include/rpl_end.inc;
|
Output:
...
|
worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019
|
rpl.rpl_blackhole_bug 'mix' [ pass ] 791
|
rpl.rpl_blackhole_bug 'row' [ fail ]
|
Test ended at 2016-10-20 17:09:52
|
...
|
Replicate_Wild_Ignore_Table
|
Last_Errno 1032
|
Last_Error Could not execute Update_rows_v1 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.000001, end_log_pos 1510
|
Skip_Counter 0
|
Exec_Master_Log_Pos 1271
|
...
|
Original test: rpl.rpl_blackhole
Note: The failure is only triggered if replicate_annotate_row_events is enables as well.
Attachments
Issue Links
- relates to
-
MDEV-7635 update defaults and simplify mysqld config parameters
- Closed