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

Prepare of full backup fails for encrypted tables with Generic error

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: In Progress
    • Priority: High
    • Resolution: Unresolved
    • Affects Version/s: 8.0.10, 8.0.22-15
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      • Initialize and start PS8.0.17-8 with options
        /home/mchawla/PS241019_8_0_17_8_debug/bin/mysqld --no-defaults --core-file --basedir=/home/mchawla/PS241019_8_0_17_8_debug --tmpdir=/home/mchawla/PS241019_8_0_17_8_debug/data --datadir=/home/mchawla/PS241019_8_0_17_8_debug/data --plugin-load-add=tokudb=ha_tokudb.so --tokudb-check-jemalloc=0 --plugin-load-add=rocksdb=ha_rocksdb.so --socket=/home/mchawla/PS241019_8_0_17_8_debug/socket.sock --port=11764 --log-error=/home/mchawla/PS241019_8_0_17_8_debug/log/master.err --server-id=100 --log-bin=binlog --log-bin=binlog --early-plugin-load=keyring_file.so --keyring_file_data=/home/mchawla/PS241019_8_0_17_8_debug/keyring --log-slave-updates --gtid-mode=ON --enforce-gtid-consistency --binlog-format=row --master_verify_checksum=ON --binlog_checksum=CRC32

        Run pquery

        ./pquery2-ps --tables 10 --logdir=$HOME/backuplogs --records 200 --threads 10 --seconds 30 --socket $HOME/PS241019_8_0_17_8_debug/socket.sock -k --undo-tbs-sql 0

        Take full backup and 5 incremental backup with options

        --keyring_file_data=${mysqldir}/keyring --xtrabackup-plugin-dir=${xtrabackup_dir}/../lib/plugin

        Prepare full backup with options

        --keyring_file_data=${mysqldir}/keyring --xtrabackup-plugin-dir=${xtrabackup_dir}/../lib/plugin

        Prepare of full backup fails with error

        ############### CORRUPT LOG RECORD FOUND ###############
        Log record type 30, page 90:0. Log parsing proceeded successfully up to 52049717. Previous log record type 4, is multi 1 Recv offset 479871, prev 479865
        Hex dump starting 100 bytes before and ending 100 bytes after the corrupted record:
         len 206; hex 015a0000ae80fe015a0000ae80fa085a0000960000000000045a0000aa02045a00005200025a000056809e045a00005800025a00005c809e045a00009ef0ffffffff025a0000a200045a0000a4f0ffffffff025a0000a800045a00004e01045a00003a02045a000036251e5a000596006950534100100000005a059600000000000000000002be7b4e3a28a5c783561b9fe8c08e74ac0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000; asc Z Z Z Z Z R Z V Z X Z \ Z Z Z Z Z N Z : Z 6% Z iPSA Z {N:( V t ;
        Set innodb_force_recovery to ignore this error.
        Doing recovery: scanned up to log sequence number 52411392
        Plugin initialization aborted at srv0start.cc[2487] with error Generic error.
        xtrabackup: innodb_init(): Error occured.

        Logs attached: Full, Inc backup logs, pquery logs

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              rahul.malik Rahul Malik
              Reporter:
              manish.chawla Manish Chawla
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - Not Specified
                  Not Specified
                  Logged:
                  Time Spent - 1 day, 6 hours
                  1d 6h

                    Smart Checklist