Percona Server moved to https://jira.percona.com/projects/PS

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

Bug #1566642 reported by Laurynas Biveinis
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL Server
Unknown
Unknown
Percona Server moved to https://jira.percona.com/projects/PS
Status tracked in 5.7
5.5
Invalid
Undecided
Unassigned
5.6
Invalid
Undecided
Unassigned
5.7
Fix Released
Low
Laurynas Biveinis
Percona Server moved to https://jira.percona.com/projects/PS 5.7.12-5

Bug Description

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.

Tags: upstream
Laurynas Biveinis (laurynas-biveinis)
tags: added: upstream
Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote :

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

Revision history for this message
monty solomon (monty+launchpad) wrote :

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.

Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

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

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.