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] MySQL Verification Team
Hello  Tanaka-San,

Thank you for the report and contribution.

Thanks,
Umesh
[28 Sep 2016 11:18] MySQL Verification Team
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] MySQL Verification Team
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.

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

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