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
Triage: Needs Triage: D5 (Feature request)

[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] Umesh Shastry
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.