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

PXB displays path error for undo directory when undo logs exist outside data directory

    Details

    • Type: Bug
    • Status: Done
    • Priority: High
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 8.0.5
    • Component/s: None
    • Labels:
      None

      Description

      Start MS with --innodb-undo-directory=/home/mchawla/mysql-8.0.14-linux-glibc2.12-x86_64/undo

      /home/mchawla/mysql-8.0.14-linux-glibc2.12-x86_64/bin/mysqld --no-defaults --core-file --basedir=/home/mchawla/mysql-8.0.14-linux-glibc2.12-x86_64 --tmpdir=/home/mchawla/mysql-8.0.14-linux-glibc2.12-x86_64/data --datadir=/home/mchawla/mysql-8.0.14-linux-glibc2.12-x86_64/data --socket=/home/mchawla/mysql-8.0.14-linux-glibc2.12-x86_64/socket.sock --port=14404 --log-error=/home/mchawla/mysql-8.0.14-linux-glibc2.12-x86_64/log/master.err --server-id=100 --innodb-undo-directory=/home/mchawla/mysql-8.0.14-linux-glibc2.12-x86_64/undo

      Add data in MS using sysbench
      Take full backup

      ./xtrabackup --user=root --password='' --backup --target-dir=$HOME/dbbackup_MS8 -S $HOME/mysql-8.0.14-linux-glibc2.12-x86_64/socket.sock --datadir=$HOME/mysql-8.0.14-linux-glibc2.12-x86_64/data

      Prepare full backup

      ./xtrabackup --prepare --target_dir=$HOME/dbbackup_MS8

      Restore full backup

      ./xtrabackup --copy-back --target-dir=$HOME/dbbackup_MS8 --datadir=$HOME/mysql-8.0.14-linux-glibc2.12-x86_64/data --innodb-undo-directory=$HOME/mysql-8.0.14-linux-glibc2.12-x86_64/undo

      The restore logs displays the following error:

      xtrabackup: recognized server arguments: --datadir=/var/lib/mysql --datadir=/home/mchawla/mysql-8.0.14-linux-glibc2.12-x86_64/data --innodb_undo_directory=/home/mchawla/mysql-8.0.14-linux-glibc2.12-x86_64/undo 
      xtrabackup: recognized client arguments: --copy-back=1 --target-dir=/home/mchawla/dbbackup_MS8 
      ./xtrabackup version 8.0.4 based on MySQL server 8.0.14 Linux (x86_64) (revision id: be60781)
      my_realpath(/home/mchawla/mysql-8.0.14-linux-glibc2.12-x86_64/undo/undo_001) failed!
      my_realpath(/home/mchawla/mysql-8.0.14-linux-glibc2.12-x86_64/undo/undo_002) failed!

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                sergei.glushchenko Sergei Glushchenko
                Reporter:
                manish.chawla Manish Chawla
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 4 hours
                  4h