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

If the `undo tablespace` was created in a directory which is a symbolic link to another directory then the backup failed at backup stage.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: 8.0.x
    • Fix Version/s: 8.0.10
    • Component/s: None
    • Labels:
      None

      Description

      If undo_tablespace is created in a directory which is a symbolic link to another directory
      then backup fails in backup stage

      mkdir /dev/shm/undo
      ln -s /dev/shm/undo $HOME/undo 

      start the server with 

       --innodb_undo_directory=$HOME/undo 

      xtrabackup: recognized client arguments: --target-dir=/home/rahul.malik/MySQL/data/xo8 --core-file --user=root --socket=/tmp/socket_1320.sock --xtrabackup-plugin-dir=/home/rahul.malik/MySQL/src/x8/bld/plugin_output_directory --backup=1
      /home/rahul.malik/MySQL/src/x8/bld/runtime_output_directory/xtrabackup version 8.0.9 based on MySQL server 8.0.18 Linux (x86_64) (revision id: 32c6afd4211)
      200306 13:48:36 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;mysql_socket=/tmp/socket_1320.sock' as 'root' (using password: NO).
      200306 13:48:36 version_check Connected to MySQL server
      200306 13:48:36 version_check Executing a version check against the server...
      200306 13:48:36 version_check Done.
      200306 13:48:36 Connecting to MySQL server host: localhost, user: root, password: not set, port: not set, socket: /tmp/socket_1320.sock
      Using server version 8.0.19-debug
      xtrabackup: uses posix_fadvise().
      xtrabackup: cd to /home/rahul.malik/MySQL/data/o8/
      xtrabackup: open files limit requested 0, set to 1024
      xtrabackup: using the following InnoDB configuration:
      xtrabackup: innodb_data_home_dir = .
      xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend
      xtrabackup: innodb_log_group_home_dir = ./
      xtrabackup: innodb_log_files_in_group = 2
      xtrabackup: innodb_log_file_size = 50331648
      Number of pools: 1
      200306 13:48:36 Added plugin 'keyring_file.so' to load list.
      200306 13:48:36 Connecting to MySQL server host: localhost, user: root, password: not set, port: not set, socket: /tmp/socket_1320.sock
      200306 13:48:36 >> log scanned up to (21986169)
      xtrabackup: Redo Log Archiving is not set up.
      xtrabackup: Generating a list of tablespaces
      Directories to scan '.;/home/rahul.malik/undo;.'
      Scanning './'
      Scanning '/home/rahul.malik/undo/'
      Completed space ID check of 3 files.
      Allocated tablespace ID 1 for sys/sys_config, old maximum was 0
      Using undo tablespace '/home/rahul.malik/undo/undo_001'.
      Using undo tablespace '/home/rahul.malik/undo/undo_002'.
      my_realpath(/home/rahul.malik/undo/undo_003) failed!
      Using undo tablespace '/home/rahul.malik/undo/undo_003.ibu'.
      Opened 3 existing undo tablespaces.
      200306 13:48:36 [01] Copying ./ibdata1 to /home/rahul.malik/MySQL/data/xo8/ibdata1
      200306 13:48:36 [01] ...done
      200306 13:48:36 [01] Copying ./sys/sys_config.ibd to /home/rahul.malik/MySQL/data/xo8/sys/sys_config.ibd
      200306 13:48:36 [01] ...done
      200306 13:48:36 [01] Copying ./mysql.ibd to /home/rahul.malik/MySQL/data/xo8/mysql.ibd
      200306 13:48:37 [01] ...done
      xtrabackup: Can't create/write to file '/home/rahul.malik/undo/undo_003.ibu' (OS errno 17 - File exists)
      [01] xtrabackup: error: cannot open the destination stream for /home/rahul.malik/undo/undo_003.ibu
      [01] xtrabackup: Error: xtrabackup_copy_datafile() failed.
      [01] xtrabackup: Error: failed to copy datafile.
      200306 13:48:37 >> log scanned up to (21986169)
      0
       

        Smart Checklist

          Attachments

            Activity

              People

              Assignee:
              rahul.malik Rahul Malik
              Reporter:
              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 - 1 hour
                  1h