Failing assertion: 0x20UL & rec_get_info_bits( btr_cur_get_rec(btr_cur), dict_table_is_comp(index->table)) in file row0purge.c line 390 | abort in row_purge_remove_sec_if_poss_leaf

[Roel Van de Paar]

========================= Error log:
130202 5:26:55 InnoDB: Assertion failure in thread 140040500565760 in file row0purge.c line 390
InnoDB: Failing assertion: 0x20UL & rec_get_info_bits( btr_cur_get_rec(btr_cur), dict_table_is_comp(index->table))

========================= gdb :
Thread 1 (LWP 27101):
+bt
#0 0x0000003da180c60c in pthread_kill () from /lib64/libpthread.so.0
#1 0x00000000007dea78 in my_write_core (sig=6) at /ssd/QA-16724-5.5-2/Percona-Server-5.5.28-rel29.3/mysys/stacktrace.c:433
#2 0x00000000006b3144 in handle_fatal_signal (sig=6) at /ssd/QA-16724-5.5-2/Percona-Server-5.5.28-rel29.3/sql/signal_handler.cc:249
#3 <signal handler called>
#4 0x0000003da1435935 in raise () from /lib64/libc.so.6
#5 0x0000003da14370e8 in abort () from /lib64/libc.so.6
#6 0x00000000009d4402 in row_purge_remove_sec_if_poss_leaf (node=node@entry=0x31591c8, index=index@entry=0x7f5dac18a2a8, entry=entry@entry=0x7f5d9c002550) at /ssd/QA-16724-5.5-2/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0purge.c:387
#7 0x00000000009d5c70 in row_purge_remove_sec_if_poss (entry=0x7f5d9c002550, index=0x7f5dac18a2a8, node=0x31591c8) at /ssd/QA-16724-5.5-2/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0purge.c:433
#8 row_purge_del_mark (node=0x31591c8) at /ssd/QA-16724-5.5-2/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0purge.c:484
#9 row_purge (thr=0x3159010, node=0x31591c8) at /ssd/QA-16724-5.5-2/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0purge.c:765
#10 row_purge_step (thr=thr@entry=0x3159010) at /ssd/QA-16724-5.5-2/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0purge.c:805
#11 0x00000000009bdd4f in que_thr_step (thr=0x3159010) at /ssd/QA-16724-5.5-2/Percona-Server-5.5.28-rel29.3/storage/innobase/que/que0que.c:1259
#12 que_run_threads_low (thr=0x3159010) at /ssd/QA-16724-5.5-2/Percona-Server-5.5.28-rel29.3/storage/innobase/que/que0que.c:1319
#13 que_run_threads (thr=thr@entry=0x3159010) at /ssd/QA-16724-5.5-2/Percona-Server-5.5.28-rel29.3/storage/innobase/que/que0que.c:1356
#14 0x0000000000887212 in trx_purge (limit=<optimized out>) at /ssd/QA-16724-5.5-2/Percona-Server-5.5.28-rel29.3/storage/innobase/trx/trx0purge.c:1195
#15 0x000000000087849d in srv_purge_thread (arg=<optimized out>) at /ssd/QA-16724-5.5-2/Percona-Server-5.5.28-rel29.3/storage/innobase/srv/srv0srv.c:4037
#16 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0
#17 0x0000003da14f168d in clone () from /lib64/libc.so.6

========================= Run details:
[Roel@qaserver 861716]$ cat cmd67
ps -ef | grep 'cmdrun_67' | grep -v grep | awk '{print $2}' | xargs sudo kill -9
rm -Rf /ssd/861716/cmdrun_67
mkdir /ssd/861716/cmdrun_67
cd /ssd/randgen
bash -c "set -o pipefail; perl runall.pl --queries=100000000 --seed=20890 --duration=200 --querytimeout=60 --short_column_names --reporter=Shutdown,Backtrace,QueryTimeout,ErrorLog,ErrorLogAlarm --mysqld=--log-output=none --mysqld=--sql_mode=ONLY_FULL_GROUP_BY --grammar=conf/percona_qa/percona_qa.yy --gendata=conf/percona_qa/percona_qa.zz --basedir=/ssd/Percona-Server-5.5.28-rel29.3-422-debug.Linux.x86_64 --threads=25 --views --notnull --mysqld=--innodb_track_changed_pages=0 --mysqld=--innodb_changed_pages=OFF --mysqld=--innodb_flush_method=O_DSYNC --mysqld=--innodb_file_per_table=1 --mtr-build-thread=763 --mask=61459 --vardir1=/ssd/861716/cmdrun_67 > /ssd/861716/cmdrun67.log 2>&1"

[Roel Van de Paar (roel11)]

Not QA blocking

[Laurynas Biveinis (laurynas-biveinis)]

Not bitmap related, most likely an upstream bug.

Needs verification with upstream 5.1 and 5.5.

[Roel Van de Paar (roel11)]

Seen in 5.6 also...

2013-03-11 03:34:23 2447 [ERROR] /ssd/Percona-Server-5.6.8-alpha60.2-313-debug.Linux.x86_64/bin/mysqld-debug: Deadlock found when trying to get lock; try restarting transaction
2013-03-11 03:34:23 2447 [ERROR] /ssd/Percona-Server-5.6.8-alpha60.2-313-debug.Linux.x86_64/bin/mysqld-debug: Sort aborted: Deadlock found when trying to get lock; try restarting transaction
2013-03-11 03:34:23 7f9866dca700 InnoDB: Assertion failure in thread 140292537493248 in file row0purge.cc line 459
InnoDB: Failing assertion: 0x20UL & rec_get_info_bits( btr_cur_get_rec(btr_cur), dict_table_is_comp(index->table))

[Roel Van de Paar (roel11)]

Ramesh, can you test please (low prio) and report upstream if seen at least once?

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-630