Bug #101519 Document about 'enforce_gtid_consistency' is inaccurate.

• Submitted: 9 Nov 2020 7:28
• Modified: 8 Apr 2021 14:42
• Reporter: Zhou Shu
• Status: Closed
• Category: MySQL Server: Documentation
• Severity: S3 (Non-critical)
• Version: 5.7, 8.0
• OS: Any
• CPU Architecture: Any

[9 Nov 2020 7:28] Zhou Shu

Description:
The expression about the relationship between 'enforce_gtid_consistency' and 'gtid_mode' is inaccurate

How to repeat:
The system variable 'enforce_gtid_consistency' could be 'OFF', 'ON', and 'WARN'. If a user want to set 'gtid_mode=ON', the value of 'enforce_gtid_consistency' must be 'ON'. However, in description of 'gtid_mode'(https://dev.mysql.com/doc/refman/5.7/en/replication-options-gtids.html#sysvar_gtid_mode), it says that:

"MySQL 5.7.6 enables this variable to be set dynamically. You must have privileges sufficient to set global system variables. See Section 5.1.8.1, \“System Variable Privileges\”. enforce_gtid_consistency must be true before you can set gtid_mode=ON."

The "enforce_gtid_consistency must be true before you can set gtid_mode=ON" is not accurate, since there is also an alternative value 'WARN". So I recommend to adjust this expression to "enforce_gtid_consistency must be 'ON' before you can set gtid_mode=ON".

[9 Nov 2020 7:50] MySQL Verification Team

Hello Zhou Shu,

Thank you for the report and feedback.

regards,
Umesh

[8 Apr 2021 14:42] Margaret Fisher

Posted by developer:
 
Thanks for spotting this! It must have been missed when WARN was added. I've updated to say that the variable must be set to ON.