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

PXB crashes during backup when an encrypted table is updated

    XMLWordPrintable

    Details

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

      Description

      Initialize and start MS5.7.31 with encryption options

      /home/mchawla/MS_5_7_31/bin/mysqld --no-defaults --core-file --basedir=/home/mchawla/MS_5_7_31 --tmpdir=/home/mchawla/MS_5_7_31/data --datadir=/home/mchawla/MS_5_7_31/data --socket=/home/mchawla/MS_5_7_31/socket.sock --port=14445 --log-error=/home/mchawla/MS_5_7_31/log/master.err --server-id=100 --log-bin=binlog --early-plugin-load=keyring_file.so --keyring_file_data=/home/mchawla/MS_5_7_31/keyring --log-slave-updates --gtid-mode=ON --enforce-gtid-consistency --binlog-format=row --master_verify_checksum=ON --binlog_checksum=CRC32

      Create 10 encrypted sysbench tables
      Run the following

      /home/mchawla/MS_5_7_31/bin/mysql -uroot -S/home/mchawla/MS_5_7_31/socket.sock -e "SET @@SESSION.OPTIMIZER_SWITCH='firstmatch=ON';"
      /home/mchawla/MS_5_7_31/bin/mysql -uroot -S/home/mchawla/MS_5_7_31/socket.sock -e "UPDATE test.sbtest1 SET c='Œ„´‰?Á¨ˆØ?"'';"
      /home/mchawla/MS_5_7_31/bin/mysql -uroot -S/home/mchawla/MS_5_7_31/socket.sock -e "OPTIMIZE TABLE test.sbtest1;"
      /home/mchawla/MS_5_7_31/bin/mysql -uroot -S/home/mchawla/MS_5_7_31/socket.sock -e "TRUNCATE test.sbtest1;"

      Take full backup with lock-ddl-per-table

      /home/mchawla/pxb_2_4_21_debug/bin/xtrabackup --user=root --password= --backup --target-dir=/home/mchawla/dbbackup_22_07_2020/full -S /home/mchawla/MS_5_7_31/socket.sock --datadir=/home/mchawla/MS_5_7_31/data --keyring_file_data=/home/mchawla/MS_5_7_31/keyring --xtrabackup-plugin-dir=/home/mchawla/pxb_2_4_21_debug/bin/../lib/plugin --lock-ddl-per-table

      PXB crashes

      09:26:05 UTC - xtrabackup got signal 11 ;
      This could be because you hit a bug or data is corrupted.
      This error can also be caused by malfunctioning hardware.
      Attempting to collect some information that could help diagnose the problem.
      As this is a crash and something is definitely wrong, the information
      collection process might fail.
      Thread pointer: 0x0
      Attempting backtrace. You can use the following information to find out
      where mysqld died. If you see no messages after this, something went
      terribly wrong...
      stack_bottom = 0 thread_stack 0x10000
      /home/mchawla/pxb_2_4_21_debug/bin/xtrabackup(my_print_stacktrace+0x35)[0x16f5a81]
      /home/mchawla/pxb_2_4_21_debug/bin/xtrabackup(handle_fatal_signal+0x2a5)[0x1273c56]
      /usr/lib64/libpthread.so.0(+0xf630)[0x7fc41237b630]
      /home/mchawla/pxb_2_4_21_debug/bin/xtrabackup(_ZN9__gnu_cxx17__normal_iteratorIP15recv_encryptionSt6vectorIS1_12ut_allocatorIS1_EEEC2ERKS2_+0x10)[0xe404be]
      /home/mchawla/pxb_2_4_21_debug/bin/xtrabackup(_ZNSt6vectorI15recv_encryption12ut_allocatorIS0_EE5beginEv+0x23)[0xe3fd25]
      /home/mchawla/pxb_2_4_21_debug/bin/xtrabackup(_ZN8Datafile19validate_first_pageEPmb+0x6ca)[0x1597f20]
      /home/mchawla/pxb_2_4_21_debug/bin/xtrabackup(_Z31xb_load_single_table_tablespacePKcS0_b+0x1a1)[0xe0be4c]
      /home/mchawla/pxb_2_4_21_debug/bin/xtrabackup(_Z32xb_load_single_table_tablespacesPFbPKcS0_E+0x2f7)[0xe0c52f]
      /home/mchawla/pxb_2_4_21_debug/bin/xtrabackup[0xe0c7d6]
      /home/mchawla/pxb_2_4_21_debug/bin/xtrabackup(_Z22xtrabackup_backup_funcv+0xbb8)[0xe0e75f]
      /home/mchawla/pxb_2_4_21_debug/bin/xtrabackup(main+0x9b1)[0xe17e3c]
      /usr/lib64/libc.so.6(__libc_start_main+0xf5)[0x7fc40ffdf555]
      /home/mchawla/pxb_2_4_21_debug/bin/xtrabackup[0xe01bf9]

      Logs are attached.

        Smart Checklist

          Attachments

            Activity

              People

              Assignee:
              rahul.malik Rahul Malik
              Reporter:
              manish.chawla Manish Chawla
              Votes:
              0 Vote for this issue
              Watchers:
              2 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 - 2 hours, 30 minutes
                  2h 30m