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.
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.