"Missing gtid_executed system variable" in MySQL 5.7

[etsxxx]

I got this error message in some failover operations with MySQL 5.7 servers.

ERROR: The server xxxx:3306 does not comply to the latest GTID feature support. Errors:
    Missing gtid_executed system variable.

I suppose the query from mysql/utilities/common/server.py is invalid:

"SHOW VARIABLES LIKE 'gtid_executed'"

and this is correct:

"SHOW GLOBAL VARIABLES LIKE 'gtid_executed'"

[fr34kyn01535]

I got the same message today, no idea what happened, GTID_MODE is on, fresh installation..

[sameer1001]

Even I got the same message. I cross checked GTID_MODE is on for all slaves.

Any resolution on this ?

[etsxxx]

My workaround for MySQL 5.7:

1. Open mysql/utilities/common/server.py and find SHOW VARIABLES strings.
2. Change it to SHOW GLOBAL VARIABLES .

[sameer1001]

Thanks for the quick reply @etsxxx

How can I do this change ? Do I have to build the utilities from the source ?

Currently I have installed this as a deb package.

[ioggstream]

A quick fix could be setting compatibility mode on your mysql server.

mysql> set show_compatibility_56='ON';

[dfredell]

I upgraded my Connector-Python from 2.1.3 to 2.1.7 and my issue (same as @etsxxx) went away. I'm running

mysqld Ver 5.7.19-17 for debian-linux-gnu on x86_64 (Percona Server (GPL), Release '17', Revision 'e19a6b7b73f')