Bug #83184 Can't set slave_skip_errors > 3000
Submitted: 28 Sep 2016 10:34 Modified: 1 Apr 2017 14:37
Reporter: tsubasa tanaka (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Replication Severity:S3 (Non-critical)
Version:5.7.15, 8.0.0 OS:Any
Assigned to: CPU Architecture:Any
Tags: Contribution

[28 Sep 2016 10:34] tsubasa tanaka
Description:
MySQL 5.7 has introduced 3000's error numbers but "slave_skip_errors" doesn't allow error numbers which is greater than 3000.

This caused MAX_SLAVE_ERROR (https://github.com/mysql/mysql-server/blob/mysql-5.7.15/sql/rpl_slave.h#L66) is still 2000.

How to repeat:
$ bin/mysqld_safe --no-defaults --slave-skip-errors=3002 &
$ bin/mysql
mysql> SHOW VARIABLES LIKE 'slave_skip_errors';
+-------------------+-------+
| Variable_name     | Value |
+-------------------+-------+
| slave_skip_errors | OFF   |
+-------------------+-------+
1 row in set (0.01 sec)

Suggested fix:
See attached patch.
[28 Sep 2016 10:34] 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: bug83184.patch (application/octet-stream, text), 1.23 KiB.

[28 Sep 2016 11:17] Umesh Shastry
Hello  Tanaka-San,

Thank you for the report and contribution.

Thanks,
Umesh
[28 Sep 2016 11:18] Umesh Shastry
Changing category to closest one, i.e replication
[28 Sep 2016 12:43] tsubasa tanaka
Hello Umesh,

Thank you for your confirming.

And I'm sorry for my patch is incomplete one (attached again)
[28 Sep 2016 12:43] tsubasa tanaka
FIxed incomplete

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

Contribution: bug83184_2.patch (application/octet-stream, text), 1.76 KiB.

[28 Sep 2016 12:51] Umesh Shastry
Thank you Tanaka-San!

Regards,
Umesh
[1 Apr 2017 14:37] Paul Dubois
Posted by developer:
 
Noted in 5.7.19, 8.0.2 changelogs.

The slave_skip_errors system variable did not permit error numbers
larger than 3000.
[1 Apr 2017 14:38] Paul Dubois
Posted by developer:
 
Thanks to Tsubasa Tanaka for the patch.