Bug #86280 MySQL Enterprise backup does not correctly restore server uuid
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
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.