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

Error reading xtrabackup_keys: failed to read magic.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: On Hold
    • Priority: Medium
    • Resolution: Unresolved
    • Affects Version/s: 2.4.12
    • Fix Version/s: None
    • Component/s: None
    • Labels:

      Description

      Backup taken with --stream=tar and --transition-key fails during --prepare

      Attached copies of backup, decompress and prepare phases.

      [root@mysql1 ~]# xtrabackup --stream=tar --backup --target-dir=backup/ --transition-key=NSu7kfUgcTTIY2ym7Qu6jnYOotOuMIeT | nc 192.168.0.117 9999
      [root@mysql2 ~]# tar xvfi backup.tar -C backup/
      [root@mysql2 ~]# xtrabackup --prepare --target-dir=backup/ --transition-key=NSu7kfUgcTTIY2ym7Qu6jnYOotOuMIeT
      xtrabackup: recognized server arguments: --innodb_checksum_algorithm=crc32 --innodb_log_checksum_algorithm=strict_crc32 --innodb_data_file_path=ibdata1:12M:autoextend --innodb_log_files_in_group=2 --innodb_log_file_size=50331648 --innodb_fast_checksum=0 --innodb_page_size=16384 --innodb_log_block_size=512 --innodb_undo_directory=./ --innodb_undo_tablespaces=0 --server-id=1 --redo-log-version=1 --transition-key=*
      xtrabackup: recognized client arguments: --innodb_checksum_algorithm=crc32 --innodb_log_checksum_algorithm=strict_crc32 --innodb_data_file_path=ibdata1:12M:autoextend --innodb_log_files_in_group=2 --innodb_log_file_size=50331648 --innodb_fast_checksum=0 --innodb_page_size=16384 --innodb_log_block_size=512 --innodb_undo_directory=./ --innodb_undo_tablespaces=0 --server-id=1 --redo-log-version=1 --transition-key=* --prepare=1 --target-dir=backup/
      xtrabackup version 2.4.12 based on MySQL server 5.7.19 Linux (x86_64) (revision id: 170eb8c)
      xtrabackup: cd to /root/backup/
      xtrabackup: This target seems to be not prepared yet.
      InnoDB: Number of pools: 1
      xtrabackup: xtrabackup_logfile detected: size=8388608, start_lsn=(2621044)
      xtrabackup: using the following InnoDB configuration for recovery:
      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 = 1
      xtrabackup:   innodb_log_file_size = 8388608
      180724 05:53:21 Loading xtrabackup_keys.
      180724 05:53:21 Error reading xtrabackup_keys: failed to read magic.
      xtrabackup: Error: failed to load tablespace keys

      Backup works with --stream=xbstream see gist - https://gist.github.com/riveraja/85c69e09255e44c3605c1da2eedfa2ee

        Attachments

        1. backup.txt
          34 kB
        2. decompress.txt
          10 kB
        3. prepare.txt
          2 kB

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              jericho.rivera Jericho Rivera
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: