Bug #88343 Docs: ambiguous default value of binlog_error_action option
Submitted: 3 Nov 2017 12:07 Modified: 16 Nov 2017 13:19
Reporter: Umesh Shastry Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:8.0 OS:Any
Assigned to: CPU Architecture:Any

[3 Nov 2017 12:07] Umesh Shastry
Description:
In the MySQL 8.0 manual section 18.1.6.4 at https://dev.mysql.com/doc/refman/8.0/en/replication-options-binary-log.html#sysvar_binlog_... the specified default value of the option binlog_error_action is ambiguous as it shows both values i.e IGNORE_ERROR and ABORT_SERVER. 

Just below the table, "This variable defaults to ABORT_SERVER.." which confirms default value. Imho, binlog_error_action's default value is ABORT_SERVER from >= 5.7.7

From 8.0.3 RC instance:

root@localhost [(none)]> show variables like 'binlog_error_action';
+---------------------+--------------+
| Variable_name       | Value        |
+---------------------+--------------+
| binlog_error_action | ABORT_SERVER |
+---------------------+--------------+
1 row in set (0.00 sec)

root@localhost [(none)]> show variables like '%version%';
+-------------------------+---------------------------------------------------------+
| Variable_name           | Value                                                   |
+-------------------------+---------------------------------------------------------+
| innodb_version          | 8.0.3                                                   |

5.7 - manual has correct information:

https://dev.mysql.com/doc/refman/5.7/en/replication-options-binary-log.html#sysvar_binlog_...

How to repeat:
As in description.

Suggested fix:
Below info should be removed?

Permitted Values	Type	enumeration
Default	IGNORE_ERROR
Valid Values	IGNORE_ERROR
ABORT_SERVER
[16 Nov 2017 13:19] Margaret Fisher
Posted by developer:
 
Thanks for the report. This was caused by a markup error which I have corrected. The online builds should show the corrected table before long.