Bug #80189 mysqlfailover and mysqlrpladmin do not work with MySQL57
Submitted: 28 Jan 2016 15:06 Modified: 2 Feb 2016 3:30
Reporter: Nelson Goncalves Email Updates:
Status: Closed Impact on me:
Category:MySQL Utilities Severity:S2 (Serious)
Version:1.6.2 OS:Any
Assigned to: CPU Architecture:Any

[28 Jan 2016 15:06] Nelson Goncalves
The mysqlfailover and mysqlrpladmin utilities are not working with mysql5.7 servers.
During the failover process, they fail with the following error:
Errors: Missing gtid_executed system variable.

This is caused by an incorrect validation done by the check_gtid_version method method of the Server
class. The method is wrongfully assuming that an empty result to the "SHOW VARIABLES LIKE 'gtid_executed'" query
is a signal that gtid_executed variable does not exist in the system.

How to repeat:
Run the mysql_rpl_admin_gtid test

$ python mut.py --server=root@localhost:13001 --do-tests=rpl_admin_gtid

Suggested fix:
Remove that validation from the method, besides not being correct, is is not necessary.
Ensuring that the server version is >= 5.6.9 and that GTIDs are enabled are sufficient 
conditions to ensure that gtid_executed variable will be on the system.
[28 Jan 2016 18:37] Nelson Goncalves
Posted by developer:
Fixed in version 1.6.3
[2 Feb 2016 3:30] Philip Olson
Posted by developer:
Fixed as of the upcoming MySQL Utilities 1.6.3 release, and here's the changelog entry:

The mysqlfailover and mysqlrpladmin utilities did not function with MySQL
5.7 Servers. During the failover process, they failed with the following
error: "Errors: Missing gtid_executed system variable."

Thank you for the bug report.