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

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.

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.

Hello Tanaka-San,

Thank you for the feature request and contribution.

Thanks,
Umesh

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.

Page generated in 0.038 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.