Replication does not work when @@GLOBAL.SERVER_UUID is missing on the master

[Laurynas Biveinis]

Copy of http://bugs.mysql.com/bug.php?id=80962:

[5 Apr 15:57] Kenny Gryp
Description:
In commit https://github.com/mysql/mysql-server/commit/14d664f0ddca7c69d44599693ffcd3455557e7e6#diff..., the code that fetches the SERVER_UUID changed from SHOW GLOBAL VARIABLES to SELECT @@GLOBAL, which now returns an error if the variable is not there instead of an empty row.

However, as you can see in https://github.com/grypyrg/percona-server/blob/5.7/sql/rpl_slave.cc#L2429-L2437 the code actually catches the non presence of a row which is using the SHOW GLOBAL VARIABLES way.

This patch just made it handle SELECT @@GLOBAL properly.

This caused any replication from MySQL < 5.6 to MySQL 5.7 to break.

[Laurynas Biveinis (laurynas-biveinis)]

https://github.com/percona/percona-server/pull/442

[monty solomon (monty+launchpad)]

This is fixed in 5.7.13.
https://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-13.html

Replication: Slaves running MySQL 5.7 could not connect to a MySQL 5.5 master due to an error retrieving the server_uuid, which is not part of MySQL 5.5. This was caused by changes in the method of retrieving the server_uuid. (Bug #22748612)

References: This issue is a regression of: Bug #21455603.

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-2143