Comment 20 for bug 1192834

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