5.7 upgrade scripts does not properly initialize multi-src replication

Bug #1594790 reported by Johan Nilsson
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
New
Undecided
Unassigned

Bug Description

When upgrading from 5.6.x to 5.7.12, the upgrade script does not properly initialize the tables required to have multi-source replication working, regardless if replication was configured in the 5.6-installation or not.

After upgrading, it's possible to create multiple replication channels, but they will all be displayed with the same name (the name from the first channel configured) in all ways, except in mysql.slave_relay_log_info.
Both channels can be manipulated with giving the correct channel name in slave-commands.

After instance restart, all channels except the first one disappears.

Revision history for this message
Johan Nilsson (johan-nilsson-y) wrote :

This has been reported to Oracle under
Bug #81846 - mysql_upgrade does not correctly set up the databae for multi-source replication
(https://bugs.mysql.com/bug.php?id=81846)

tags: added: replication
tags: added: upstream
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-3473

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

Other bug subscribers

Remote bug watches

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