Bug #86280 MySQL Enterprise backup does not correctly restore server uuid

Submitted: 11 May 2017 10:25 Modified: 29 Jun 2017 8:36
Reporter: Oli Sennhauser Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Enterprise Backup Severity:S3 (Non-critical)
Version:4.1.0 OS:Linux
Assigned to: CPU Architecture:Any
Tags: restore, UUID

[11 May 2017 10:25] Oli Sennhauser
Description:
MySQL Enterprise backup does not correctly restore server uuid.

IMHO server_uuid after restore should be automatically set back to the old value. That is at least the expected behaviour.

How to repeat:
+----------------+--------------------------------------+
| Variable_name  | Value                                |
+----------------+--------------------------------------+
| server_uuid    | 16a8bd0f-3632-11e7-991b-d0509970f88e |
+----------------+--------------------------------------+

./bin/mysqlbackup --user=root --backup-dir=/tmp/tape backup
./bin/mysqlbackup --user=root --backup-dir=/tmp/tape apply-log

grep uuid /tmp/tape/server-all.cnf 
# server_uuid=16a8bd0f-3632-11e7-991b-d0509970f88e

./bin/mysqlbackup --user=root --datadir=/home/mysql/data/mysql-5.7 --backup-dir=/tmp/tape copy-back

./bin/mysqlbackup --version
MySQL Enterprise Backup version 4.1.0 Linux-2.6.39-400.215.10.el5uek-x86_64 [2017/03/01] 

auto.cnf does not exist

2017-05-11T10:21:47.382382Z 0 [Note] Salting uuid generator variables, current_pid: 10598, server_start_time: 1494498107, bytes_sent: 0, 
2017-05-11T10:21:47.382410Z 0 [Note] Generated uuid: 'a395c95c-3633-11e7-a1aa-d0509970f88e', server_start_time: 2983071804674040993, bytes_sent: 66216416
2017-05-11T10:21:47.382417Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: a395c95c-3633-11e7-a1aa-d0509970f88e.

cat auto.cnf 
[auto]
server-uuid=a395c95c-3633-11e7-a1aa-d0509970f88e

Suggested fix:
Create auto.cnf from server_uuid
[29 Jun 2017 8:36] MySQL Verification Team
Hello Oli,

Thank you for the report.

Thanks,
Umesh

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.053 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.