copy-back is not restoring binlog file properly when absolute path in used in log-bin

Description

my.cnf include the following information about:

[root@192 data]# cat /etc/my.cnf |grep 'log-bin|datadir'
datadir = /data/mysql
log-bin = /data/mysql/mybinlog
1.do backup

2.do prepare
prepare is ok , and I get the following values like :

[root@192 backup]# cat xtra_full_20210515160208/mybinlog.index
/data/mysql/mybinlog.000005
copy-back
xtrabackup --defaults-file=/etc/my.cnf --copy-back --target-dir=/data/backup/xtra_full_20210515160208/
When I finished executing --copy-back, I found that there was a problem,The index file of binlog is missing some information,When I change it to mybinlog.000005,MySQL can be started normally。

[root@192 ~]# cat /data/mysql/mybinlog.index
/data/mysql/.000005

https://forums.percona.com/t/is-this-a-bug-of-xtrabackup-8-0-23-16-and-mysql-8-0-23-when-i-executed-copy-back-there-was-an-error-in-the-index-file-of-binlog/10472

Environment

None

Smart Checklist

Activity

Show:
Duplicate

Details

Assignee

Reporter

Time tracking

2h logged

Affects versions

Priority

Smart Checklist

Created May 21, 2021 at 1:57 PM
Updated March 6, 2024 at 6:40 PM
Resolved May 24, 2021 at 2:34 PM

Flag notifications