Bug #79517 if gtid-mode=on , set gtid-enforce-consistency=on by default if not specified

• Submitted: 4 Dec 2015 7:07
• Modified: 14 Dec 2015 12:31
• Reporter: Shane Bester (Platinum Quality Contributor)
• Status: Verified
• Category: MySQL Server: Options
• Severity: S4 (Feature request)
• Version: 8.0.0
• OS: Any
• CPU Architecture: Any

[4 Dec 2015 7:07] Shane Bester

Description:
I start my server with command line options:

--log-bin --server-id=1 --gtid-mode=on

it fails.

[ERROR] GTID_MODE = ON requires ENFORCE_GTID_CONSISTENCY = ON.
[ERROR] Aborting

How to repeat:
mysqld --log-bin --server-id=1 --gtid-mode=on

Suggested fix:
i cant remember all the options to type.  please just enable ENFORCE_GTID_CONSISTENCY by default if it wasn't specified and is required ;)

[14 Dec 2015 12:31] MySQL Verification Team

Hello Shane,

Thank you for the feature request!

Regards,
Umesh

[18 Jun 2016 21:35] Omer Barnir

Posted by developer:
 
Reported version value updated to reflect release name change from 5.8 to 8.0

[20 Jul 2018 11:25] Jean-François Gagné

This also affects 5.7.22.
Please consider also doing this in MySQL 5.7.
Thanks,
JFG

[20 Jul 2018 11:50] Jean-François Gagné

I got bitten by this today in 5.7.22.
Could you please consider implementing this for making MySQL more user-friendly ?
And maybe back-porting to 5.7...
Many thanks,

JFG