Details
-
Bug
-
Status: Done
-
Medium
-
Resolution: Duplicate
-
2.4.20
-
None
-
None
-
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.
Attachments
Issue Links
- is duplicated by
-
PXB-2275 Modify backup processing to add validations if an encrypted table is created
-
- Done
-