Uploaded image for project: 'Percona XtraBackup'
  1. Percona XtraBackup
  2. PXB-2510

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

Details

    • Bug
    • Status: Done
    • Medium
    • Resolution: Duplicate
    • 8.0.25-17
    • None
    • None
    • None

    Description

      my.cnf include the following information about:

      [[email protected] 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 :

      [[email protected] 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。

      [[email protected] ~]# 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

      Attachments

        Issue Links

          Activity

            People

              rahul.malik Rahul Malik
              rahul.malik Rahul Malik
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - Not Specified
                  Not Specified
                  Logged:
                  Time Spent - 2 hours
                  2h

                  Smart Checklist