Bug #80210 Unable to use mysqldbexport: "Error: Missing gtid_executed system variable"
Submitted: 31 Jan 2016 19:57 Modified: 1 Feb 2016 7:58
Reporter: Admin Opynios Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Utilities Severity:S2 (Serious)
Version:1.5.6 OS:CentOS
Assigned to: CPU Architecture:Any
Tags: mysqldbexport

[31 Jan 2016 19:57] Admin Opynios
Description:
When i try to use mysqldbexport using the latest Mysql Utilities(1.5.6) and Mysql Server (5.7.10) it fails with below error
ERROR: The server X.X.X.X:3306 does not comply to the latest GTID feature support. Errors:
    Missing gtid_executed system variable.

How to repeat:
Run the below command after installing the latest Mysql server(5.7.10) and Mysql Utilities (1.5.6)
mysqldbexport --server=user:password@X.X.X.X:3306 --all --export=both --rpl=master --rpl-user=ReplUser:ReplPasswd > data.sql

Suggested fix:
I found that this issue is because of the code in "/usr/lib/python2.7/site-packages/mysql/utilities/common/server.py"

Seems to be below code has the problem
res = self.exec_query("SHOW VARIABLES LIKE 'gtid_executed'")

It should be 
res = self.exec_query("SHOW GLOBAL VARIABLES LIKE 'gtid_executed'")

Since "SHOW VARIABLES LIKE 'gtid_executed'" returns empty set, whereas "SHOW GLOBAL VARIABLES LIKE 'gtid_executed'" returns the correct value.

It worked after i fixed the issue.
[1 Feb 2016 7:58] Umesh Shastry
Hello Admin Opynios,

Thank you for the report.

Thanks,
Umesh