MySQL#74605 - InnoDB: Failing assertion: node_addr.page != FIL_NULL in file btr0btr.cc line 1101

DROP DATABASE test;CREATE DATABASE test;USE test;

SET GLOBAL innodb_change_buffering_debug=1;

CREATE TABLE t1(c1 INT)PARTITION BY HASH (c1) PARTITIONS 15;

SET @start_global_value=@@global.innodb_spin_wait_delay;

SET @@global.innodb_limit_optimistic_insert_debug=@start_global_value;

create table tt(a int,b int,primary key(a,b));

set global innodb_limit_optimistic_insert_debug=1;

DROP TABLE IF EXISTS t1;

innodb_change_buffering_debug flush 0 336

innodb_change_buffering_debug evict 0 336

2014-11-08 20:20:42 7f33ea975700  InnoDB: Assertion failure in thread 139860955846400 in file btr0btr.cc line 1101

InnoDB: Failing assertion: node_addr.page != FIL_NULL

InnoDB: We intentionally generate a memory trap.

#5  0x00007f33e89fa7c0 in *__GI_abort () at abort.c:92

#6  0x0000000000b9f2a4 in btr_page_alloc_for_ibuf (index=0x7f33e8022478, mtr=0x7f33ea96f590) at 10.0/storage/xtradb/btr/btr0btr.cc:1101

#7  0x0000000000b9f459 in btr_page_alloc (index=0x7f33e8022478, hint_page_no=355, file_direction=111 'o', level=1, mtr=0x7f33ea96f590, init_mtr=0x7f33ea96f590) at 10.0/storage/xtradb/btr/btr0btr.cc:1191

#8  0x0000000000ba2e41 in btr_page_split_and_insert (flags=7, cursor=0x7f33ea96eef0, offsets=0x7f33ea96ef80, heap=0x7f33ea96ef78, tuple=0x7f33d542bb78, n_ext=0, mtr=0x7f33ea96f590) at 10.0/storage/xtradb/btr/btr0btr.cc:2963

#9  0x0000000000ba18f8 in btr_root_raise_and_insert (flags=7, cursor=0x7f33ea96eef0, offsets=0x7f33ea96ef80, heap=0x7f33ea96ef78, tuple=0x7f33d542bb78, n_ext=0, mtr=0x7f33ea96f590) at 10.0/storage/xtradb/btr/btr0btr.cc:2311

#10 0x0000000000bb34f4 in btr_cur_pessimistic_insert (flags=7, cursor=0x7f33ea96eef0, offsets=0x7f33ea96ef80, heap=0x7f33ea96ef78, entry=0x7f33d542bb78, rec=0x7f33ea96ef88, big_rec=0x7f33ea96ef90, n_ext=0, thr=0x0, mtr=0x7f33ea96f590) at 10.0/storage/xtradb/btr/btr0cur.cc:1728

#11 0x0000000000ba2241 in btr_insert_on_non_leaf_level_func (flags=3, index=0x7f33e8022478, level=1, tuple=0x7f33d542bb78, file=0x109fc70 "10.0/storage/xtradb/btr/btr0btr.cc", line=2767, mtr=0x7f33ea96f590) at 10.0/storage/xtradb/btr/btr0btr.cc:2674

#12 0x0000000000ba25d4 in btr_attach_half_pages (flags=3, index=0x7f33e8022478, block=0x7f33e2bb8a18, split_rec=0x7f33d54e3e84 "", new_block=0x7f33e2bb8750, direction=111, mtr=0x7f33ea96f590) at 10.0/storage/xtradb/btr/btr0btr.cc:2767

#13 0x0000000000ba30fc in btr_page_split_and_insert (flags=3, cursor=0x7f33ea96f4b0, offsets=0x7f33ea96ff68, heap=0x7f33ea96ff70, tuple=0x7f33d542b178, n_ext=0, mtr=0x7f33ea96f590) at 10.0/storage/xtradb/btr/btr0btr.cc:3007

#14 0x0000000000ba18f8 in btr_root_raise_and_insert (flags=3, cursor=0x7f33ea96f4b0, offsets=0x7f33ea96ff68, heap=0x7f33ea96ff70, tuple=0x7f33d542b178, n_ext=0, mtr=0x7f33ea96f590) at 10.0/storage/xtradb/btr/btr0btr.cc:2311

#15 0x0000000000bb34f4 in btr_cur_pessimistic_insert (flags=3, cursor=0x7f33ea96f4b0, offsets=0x7f33ea96ff68, heap=0x7f33ea96ff70, entry=0x7f33d542b178, rec=0x7f33ea96ff58, big_rec=0x7f33ea96ff78, n_ext=0, thr=0x7f33d573d190, mtr=0x7f33ea96f590) at 10.0/storage/xtradb/btr/btr0cur.cc:1728

#16 0x0000000000a4e5e7 in ibuf_insert_low (mode=33, op=IBUF_OP_DELETE_MARK, no_counter=0, entry=0x7f33d542ac78, entry_size=28, index=0x7f33e8021cf8, space=0, zip_size=0, page_no=336, thr=0x7f33d573d190) at 10.0/storage/xtradb/ibuf/ibuf0ibuf.cc:3776

#17 0x0000000000a4eb8f in ibuf_insert (op=IBUF_OP_DELETE_MARK, entry=0x7f33d542ac78, index=0x7f33e8021cf8, space=0, zip_size=0, page_no=336, thr=0x7f33d573d190) at 10.0/storage/xtradb/ibuf/ibuf0ibuf.cc:3963

#18 0x0000000000bb1238 in btr_cur_search_to_nth_level (index=0x7f33e8021cf8, level=0, tuple=0x7f33d542ac78, mode=4, latch_mode=2, cursor=0x7f33ea970640, has_search_latch=0, file=0x1081c68 "10.0/storage/xtradb/row/row0row.cc", line=815, mtr=0x7f33ea970720) at 10.0/storage/xtradb/btr/btr0cur.cc:695

#19 0x0000000000b1e9a5 in btr_pcur_open_low (index=0x7f33e8021cf8, level=0, tuple=0x7f33d542ac78, mode=4, latch_mode=4098, cursor=0x7f33ea970640, file=0x1081c68 "10.0/storage/xtradb/row/row0row.cc", line=815, mtr=0x7f33ea970720) at 10.0/storage/xtradb/include/btr0pcur.ic:440

#20 0x0000000000b20531 in row_search_index_entry (index=0x7f33e8021cf8, entry=0x7f33d542ac78, mode=4098, pcur=0x7f33ea970640, mtr=0x7f33ea970720) at 10.0/storage/xtradb/row/row0row.cc:815

#21 0x0000000000b39e23 in row_upd_sec_index_entry (node=0x7f33d573c9c0, thr=0x7f33d573d190) at 10.0/storage/xtradb/row/row0upd.cc:1751

#22 0x0000000000b3a281 in row_upd_sec_step (node=0x7f33d573c9c0, thr=0x7f33d573d190) at 10.0/storage/xtradb/row/row0upd.cc:1866

#23 0x0000000000b3bae8 in row_upd (node=0x7f33d573c9c0, thr=0x7f33d573d190) at 10.0/storage/xtradb/row/row0upd.cc:2569

#24 0x0000000000b3bdcf in row_upd_step (thr=0x7f33d573d190) at 10.0/storage/xtradb/row/row0upd.cc:2686

#25 0x0000000000abf69b in que_thr_step (thr=0x7f33d573d190) at 10.0/storage/xtradb/que/que0que.cc:1097

#26 0x0000000000abf97e in que_run_threads_low (thr=0x7f33d573d190) at 10.0/storage/xtradb/que/que0que.cc:1177

#27 0x0000000000abfb10 in que_run_threads (thr=0x7f33d573d190) at 10.0/storage/xtradb/que/que0que.cc:1218

#28 0x0000000000abfd94 in que_eval_sql (info=0x7f33d5415278, sql=0x107b420 "PROCEDURE DROP_TABLE_PROC () IS\nsys_foreign_id CHAR;\ntable_id CHAR;\nindex_id CHAR;\nforeign_id CHAR;\nspace_id INT;\nfound INT;\nDECLARE CURSOR cur_fk IS\nSELECT ID FROM SYS_FOREIGN\nWHERE FOR_NAME = :table"..., reserve_dict_mutex=0, trx=0x7f33d5555278) at 10.0/storage/xtradb/que/que0que.cc:1301

#29 0x0000000000b04c67 in row_drop_table_for_mysql (name=0x7f33ea971330 "test/t1#P#p1", trx=0x7f33d5555278, drop_db=false, nonatomic=true) at 10.0/storage/xtradb/row/row0mysql.cc:4187

#30 0x0000000000a10630 in ha_innobase::delete_table (this=0x7f33d5629088, name=0x7f33ea9717d0 "./test/t1#P#p1") at 10.0/storage/xtradb/handler/ha_innodb.cc:11085

#31 0x0000000000870f8e in handler::ha_delete_table (this=0x7f33d5629088, name=0x7f33ea9717d0 "./test/t1#P#p1") at 10.0/sql/handler.cc:4251

#32 0x0000000000e0d5c3 in ha_partition::del_ren_table (this=0x7f33d561d908, from=0x7f33ea973830 "./test/t1", to=0x0) at 10.0/sql/ha_partition.cc:2324

#33 0x0000000000e09736 in ha_partition::delete_table (this=0x7f33d561d908, name=0x7f33ea973830 "./test/t1") at 10.0/sql/ha_partition.cc:557

#34 0x0000000000870f8e in handler::ha_delete_table (this=0x7f33d561d908, name=0x7f33ea973830 "./test/t1") at 10.0/sql/handler.cc:4251

#35 0x000000000086c817 in ha_delete_table (thd=0x7f33e270b070, table_type=0x7f33dee48270, path=0x7f33ea973830 "./test/t1", db=0x7f33d561d738 "test", alias=0x7f33d561d128 "t1", generate_warning=true) at 10.0/sql/handler.cc:2323

#36 0x000000000072145f in mysql_rm_table_no_locks (thd=0x7f33e270b070, tables=0x7f33d561d160, if_exists=true, drop_temporary=false, drop_view=false, dont_log_query=false, dont_free_locks=false) at 10.0/sql/sql_table.cc:2496

#37 0x00000000007207c9 in mysql_rm_table (thd=0x7f33e270b070, tables=0x7f33d561d160, if_exists=1 '\001', drop_temporary=0 '\000') at 10.0/sql/sql_table.cc:2108

#38 0x000000000067e282 in mysql_execute_command (thd=0x7f33e270b070) at 10.0/sql/sql_parse.cc:3665

#39 0x000000000068586f in mysql_parse (thd=0x7f33e270b070, rawbuf=0x7f33d561d088 "DROP TABLE IF EXISTS t1", length=23, parser_state=0x7f33ea974630) at 10.0/sql/sql_parse.cc:6407

#40 0x0000000000678652 in dispatch_command (command=COM_QUERY, thd=0x7f33e270b070, packet=0x7f33d77f2071 "DROP TABLE IF EXISTS t1", packet_length=23) at 10.0/sql/sql_parse.cc:1299

#41 0x00000000006779f7 in do_command (thd=0x7f33e270b070) at 10.0/sql/sql_parse.cc:996

#42 0x00000000007944aa in do_handle_one_connection (thd_arg=0x7f33e270b070) at 10.0/sql/sql_connect.cc:1379

#43 0x00000000007941fd in handle_one_connection (arg=0x7f33e270b070) at 10.0/sql/sql_connect.cc:1293

#44 0x0000000000ccb4a6 in pfs_spawn_thread (arg=0x7f33e27d9df0) at 10.0/storage/perfschema/pfs.cc:1860

#45 0x00007f33ea5a9b50 in start_thread (arg=<optimized out>) at pthread_create.c:304

#46 0x00007f33e8aa120d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112

revision-id: sergii@pisem.net-20141103164737-457hfby1eg82zol9

date: 2014-11-03 17:47:37 +0100

build-date: 2014-11-08 20:24:28 +0400

revno: 4471

branch-nick: 10.0