Bug #83186 Request for slave_skip_errors = ER_INCONSISTENT_ERROR
Submitted: 28 Sep 2016 10:50 Modified: 8 Jun 2017 14:06
Reporter: Tsubasa Tanaka (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Replication Severity:S4 (Feature request)
Version:5.7.15 OS:CentOS (7.2)
Assigned to: CPU Architecture:Any

[28 Sep 2016 10:50] Tsubasa Tanaka 
Description:
Replication applier thread returns 3002, ER_INCONSISTENT_ERROR, when there's difference between expected error number and actual error number.

This is feature request for ignore ER_INCONSISTENT_ERROR directly by setting slave_skip_errors= 3002.

How to repeat:
This is feature request.

Suggested fix:
See attached patch.
[28 Sep 2016 10:51] Tsubasa Tanaka 
Patch for 5.7.15

(*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Contribution: bug83186.patch (application/octet-stream, text), 1.42 KiB.
[29 Sep 2016 5:03] MySQL Verification Team 
Hello Tanaka-San,

Thank you for the feature request and contribution.

Thanks,
Umesh
[8 Jun 2017 14:06] Jon Stephens 
Documented fix in the MySQL 5.7.19 and 8.0.2 changelogs as follows:

    The replication applier thread returns error 3002
    ER_INCONSISTENT_ERROR when there is a difference between an
    expected error number and the actual error number. It is now
    possible to ignore this error by using 3002 with
    slave_skip_errors.

Closed.