test case #1: ########################################################################## # Bug 1192834: Crash during apply with index compaction enabled # ########################################################################## . inc/common.sh start_server --innodb_file_per_table load_dbase_schema sakila load_dbase_data sakila run_cmd $MYSQL $MYSQL_ARGS -e "DELETE FROM PAYMENT LIMIT 100" sakila sleep 2 backup_dir="$topdir/backup" innobackupex --no-timestamp --compact $backup_dir vlog "Backup created in directory $backup_dir" stop_server # Remove datadir rm -r $mysql_datadir # Restore sakila innobackupex --apply-log --rebuild-indexes $backup_dir vlog "Restoring MySQL datadir" mkdir -p $mysql_datadir innobackupex --copy-back $backup_dir start_server Crash: 09:06:04 UTC - xtrabackup got signal 6 ; This could be because you hit a bug or data is corrupted. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Thread pointer: 0x118cb9000 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 0 xtrabackup 0x000000010fbda9c8 my_print_stacktrace + 72 1 xtrabackup 0x000000011031ed15 handle_fatal_signal + 597 2 libsystem_platform.dylib 0x00007fff826dcf1a _sigtramp + 26 3 xtrabackup 0x0000000110ad9092 plugin_list + 45218 4 libsystem_c.dylib 0x00007fff82ddeb53 abort + 129 5 xtrabackup 0x000000010fc9f4e4 _Z27btr_cur_search_to_nth_levelP12dict_index_tmPK8dtuple_tmmP9btr_cur_tmPKcmP5mtr_t + 4500 6 xtrabackup 0x000000010ff3a103 _ZL17btr_pcur_open_lowP12dict_index_tmPK8dtuple_tmmP10btr_pcur_tPKcmP5mtr_t + 195 7 xtrabackup 0x000000010ff3a706 _Z22row_search_index_entryP12dict_index_tPK8dtuple_tmP10btr_pcur_tP5mtr_t + 166 8 xtrabackup 0x000000010ff324a8 _ZL33row_purge_remove_sec_if_poss_leafP12purge_node_tP12dict_index_tPK8dtuple_t + 344 9 xtrabackup 0x000000010ff315c0 _ZL28row_purge_remove_sec_if_possP12purge_node_tP12dict_index_tPK8dtuple_t + 64 10 xtrabackup 0x000000010ff30bca _ZL18row_purge_del_markP12purge_node_t + 298 11 xtrabackup 0x000000010ff305e5 _ZL21row_purge_record_funcP12purge_node_tPhPK9que_thr_tb + 133 12 xtrabackup 0x000000010ff2fc20 _ZL9row_purgeP12purge_node_tPhP9que_thr_t + 96 13 xtrabackup 0x000000010ff2fa4b _Z14row_purge_stepP9que_thr_t + 459 14 xtrabackup 0x000000010feb7d4e _ZL12que_thr_stepP9que_thr_t + 1022 15 xtrabackup 0x000000010feb73aa _ZL19que_run_threads_lowP9que_thr_t + 298 16 xtrabackup 0x000000010feb710e _Z15que_run_threadsP9que_thr_t + 206 17 xtrabackup 0x000000010ff946a4 _Z9trx_purgemmb + 852 18 xtrabackup 0x000000010ff7dc54 _ZL12srv_do_purgemPm + 676 19 xtrabackup 0x000000010ff7d1ac srv_purge_coordinator_thread + 652 20 libsystem_pthread.dylib 0x00007fff8ee9d268 _pthread_body + 131 21 libsystem_pthread.dylib 0x00007fff8ee9d1e5 _pthread_body + 0 22 libsystem_pthread.dylib 0x00007fff8ee9b41d thread_start + 13