Bug #40001 Replication failure on RBR + no PK + field with index + field with no index

Submitted: 13 Oct 2008 14:04 Modified: 16 Oct 2008 8:12
Reporter: Philip Stoev Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Row Based Replication ( RBR ) Severity:S2 (Serious)
Version:6.0-rpl OS:Any
Assigned to: Assigned Account CPU Architecture:Any

[13 Oct 2008 14:04] Philip Stoev
Description:
When issuing UPDATEs on a table with no primary key but with both indexed and non-indexed fields, row-based replication breaks fairly easily:

081013 17:02:59 [ERROR] 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.000001, end_log_pos 832, Error_code: 1032
081013 17:02:59 [ERROR] Slave: Can't find record in 't1' Error_code: 1032
081013 17:02:59 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'master-bin.000001' position 682

How to repeat:
--source include/master-slave.inc

SET binlog_format = 'row';

CREATE TABLE t1 (
        `int_key` int,
        `int` int,
        key (`int_key` )
) ENGINE=myisam;

INSERT IGNORE INTO t1 VALUES (NULL, '9');
UPDATE t1 SET `int_key` = 5 WHERE `int` = 9;
UPDATE t1 SET `int` = 0 WHERE `int_key` < 9;

--save_master_pos
--connection slave
--sync_with_master
[13 Oct 2008 20:51] Sveta Smirnova
Thank you for the report.

Verified as described.
[16 Oct 2008 8:12] Mats Kindahl
Unable to reproduce failure for 5.1-5.1.29-rc.
[16 Oct 2008 13:57] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/56381

2772 Mats Kindahl	2008-10-16
      BUG#40001: Replication failure on RBR + no PK + field with index +
                 field with no index 
      
      Adding test case for bug to avoid regressions.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.054 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.