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)
• Status: Closed
• Category: MySQL Server: Replication
• Severity: S3 (Non-critical)
• Version: 5.7.15, 8.0.0
• OS: Any
• 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.