InnoDB: Failing assertion: fil_page_get_type(page) == 17855 in file btr0cur.cc line 768 | abort (sig=6) in btr_cur_search_to_nth_level

[Roel Van de Paar]

[... See full error log in bundle ...]
InnoDB: Cannot reset all values for monitor counter metadata_table_handles_closed while it is on. Please turn it off and retry.
2014-10-07 01:46:18 7fe869378700 [Info] InnoDB: the file format in the system tablespace is now set to Antelope.
2014-10-07 01:46:18 7fe869378700 InnoDB: Assertion failure in thread 140636174386944 in file btr0cur.cc line 768
InnoDB: Failing assertion: fil_page_get_type(page) == 17855
[...]
Query (7fe8280050a0): ROLLBACK WORK TO SAVEPOINT A

Thread 1 (Thread 0x7fe869378700 (LWP 21213)):
+bt
#0 0x00007fe88774b771 in pthread_kill () from /lib64/libpthread.so.0
#1 0x0000000000ab6f6a in my_write_core (sig=6) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/mysys/stacktrace.c:422
#2 0x000000000072f89f in handle_fatal_signal (sig=6) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/signal_handler.cc:236
#3 <signal handler called>
#4 0x00007fe88634f5c9 in raise () from /lib64/libc.so.6
#5 0x00007fe886350cd8 in abort () from /lib64/libc.so.6
#6 0x0000000000c96dec in btr_cur_search_to_nth_level (index=0x7fe82916de88, level=0, tuple=0x7fe829116378, mode=4, latch_mode=2, cursor=0x7fe8291a1f68, has_search_latch=0, file=0x1075828 "/mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/row/row0row.cc", line=734, mtr=0x7fe8693750a0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/btr/btr0cur.cc:768
#7 0x0000000000bfabfd in btr_pcur_open_low (index=0x7fe82916de88, level=0, tuple=0x7fe829116378, mode=4, latch_mode=2, cursor=0x7fe8291a1f68, file=0x1075828 "/mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/row/row0row.cc", line=734, mtr=0x7fe8693750a0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/include/btr0pcur.ic:440
#8 0x0000000000bfc74b in row_search_on_row_ref (pcur=0x7fe8291a1f68, mode=2, table=0x7fe828087168, ref=0x7fe829116378, mtr=0x7fe8693750a0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/row/row0row.cc:734
#9 0x0000000000c0e83d in row_undo_search_clust_to_pcur (node=0x7fe8291a1ef8) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/row/row0undo.cc:182
#10 0x0000000000d6eec5 in row_undo_ins_parse_undo_rec (node=0x7fe8291a1ef8, dict_locked=0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/row/row0uins.cc:334
#11 0x0000000000d6f176 in row_undo_ins (node=0x7fe8291a1ef8) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/row/row0uins.cc:429
#12 0x0000000000c0ec15 in row_undo (node=0x7fe8291a1ef8, thr=0x7fe829258f80) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/row/row0undo.cc:303
#13 0x0000000000c0ed68 in row_undo_step (thr=0x7fe829258f80) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/row/row0undo.cc:350
#14 0x0000000000b94f76 in que_thr_step (thr=0x7fe829258f80) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/que/que0que.cc:1113
#15 0x0000000000b951b7 in que_run_threads_low (thr=0x7fe829258f80) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/que/que0que.cc:1177
#16 0x0000000000b95386 in que_run_threads (thr=0x7fe829258f80) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/que/que0que.cc:1218
#17 0x0000000000c52523 in trx_rollback_to_savepoint_low (trx=0x7fe828014d48, savept=0x7fe8291103e0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/trx/trx0roll.cc:109
#18 0x0000000000c5286c in trx_rollback_to_savepoint (trx=0x7fe828014d48, savept=0x7fe8291103e0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/trx/trx0roll.cc:151
#19 0x0000000000c53363 in trx_rollback_to_savepoint_for_mysql_low (trx=0x7fe828014d48, savep=0x7fe8291103d8, mysql_binlog_cache_pos=0x7fe8693758f8) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/trx/trx0roll.cc:364
#20 0x0000000000c534c5 in trx_rollback_to_savepoint_for_mysql (trx=0x7fe828014d48, savepoint_name=0x7fe8693758b0 "1DUMV3P19S", mysql_binlog_cache_pos=0x7fe8693758f8) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/trx/trx0roll.cc:422
#21 0x0000000000ad12f8 in innobase_rollback_to_savepoint (hton=0x26df130, thd=0x26bb320, savepoint=0x7fe8280071b0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/handler/ha_innodb.cc:4325
#22 0x000000000064070c in ha_rollback_to_savepoint (thd=0x26bb320, sv=0x7fe828007180) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/handler.cc:2119
#23 0x00000000008b7d76 in trans_rollback_to_savepoint (thd=0x26bb320, name=...) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/transaction.cc:659
#24 0x00000000007e8117 in mysql_execute_command (thd=0x26bb320) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:4798
#25 0x00000000007ed033 in mysql_parse (thd=0x26bb320, rawbuf=0x7fe8280050a0 "ROLLBACK WORK TO SAVEPOINT A", length=28, parser_state=0x7fe869376e30) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:6773
#26 0x00000000007df49c in dispatch_command (command=COM_QUERY, thd=0x26bb320, packet=0x2ecd4d1 "ROLLBACK WORK TO SAVEPOINT A;", packet_length=29) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:1432
#27 0x00000000007de3c8 in do_command (thd=0x26bb320) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:1049
#28 0x00000000007a6385 in do_handle_one_connection (thd_arg=0x26bb320) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_connect.cc:1532
#29 0x00000000007a5e8d in handle_one_connection (arg=0x26bb320) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_connect.cc:1443
#30 0x0000000000dc5590 in pfs_spawn_thread (arg=0x2e382d0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/perfschema/pfs.cc:1860
#31 0x00007fe887746df3 in start_thread () from /lib64/libpthread.so.0
#32 0x00007fe88641001d in clone () from /lib64/libc.so.6

[Shahriyar Rzayev (rzayev-sehriyar)]

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