2014-10-30T05:25:13.554708Z 0 [Note] /data/ushastry/server/mysql-advanced-5.7.6/bin/mysqld-debug: ready for connections. Version: '5.7.6-m16-enterprise-commercial-advanced-debug' socket: '/tmp/mysql.sock' port: 3306 MySQL Enterprise Server - Advanced Edition Debug (Commercial) 2014-10-30T05:25:21.701810Z 1 [Note] InnoDB: innodb_change_buffering_debug flush [page id: space=0, page number=360] 2014-10-30 10:55:21 0x7feb70214700 InnoDB: Assertion failure in thread 140649175271168 in file btr0btr.cc line 424 InnoDB: Failing assertion: node_addr.page != FIL_NULL (gdb) bt #0 0x0000003bf260c8ac in pthread_kill () from /lib64/libpthread.so.0 #1 0x0000000000e794c5 in my_write_core (sig=6) at /pb2/build/sb_0-13146106-1409929295.44/mysqlcom-pro-5.7.6-m16/mysys/stacktrace.c:247 #2 0x000000000086cb4e in handle_fatal_signal (sig=6) at /pb2/build/sb_0-13146106-1409929295.44/mysqlcom-pro-5.7.6-m16/sql/signal_handler.cc:219 #3 #4 0x0000003bf2232635 in raise () from /lib64/libc.so.6 #5 0x0000003bf2233e15 in abort () from /lib64/libc.so.6 #6 0x00000000010663db in ut_dbg_assertion_failed (expr=0x15e87db "node_addr.page != FIL_NULL", file=0x15e8500 "/pb2/build/sb_0-13146106-1409929295.44/mysqlcom-pro-5.7.6-m16/storage/innobase/btr/btr0btr.cc", line=424) at /pb2/build/sb_0-13146106-1409929295.44/mysqlcom-pro-5.7.6-m16/storage/innobase/ut/ut0dbg.cc:68 #7 0x000000000107af33 in btr_page_alloc_for_ibuf (index=0xc92e008, mtr=0x7feb7020d150) at /pb2/build/sb_0-13146106-1409929295.44/mysqlcom-pro-5.7.6-m16/storage/innobase/btr/btr0btr.cc:424 #8 0x000000000107b116 in btr_page_alloc (index=0xc92e008, hint_page_no=376, file_direction=111 'o', level=1, mtr=0x7feb7020d150, init_mtr=0x7feb7020d150) at /pb2/build/sb_0-13146106-1409929295.44/mysqlcom-pro-5.7.6-m16/storage/innobase/btr/btr0btr.cc:516 #9 0x0000000001080226 in btr_page_split_and_insert (flags=7, cursor=0x7feb7020c710, offsets=0x7feb7020c798, heap=0x7feb7020c7a0, tuple=0x7feaa801e608, n_ext=0, mtr=0x7feb7020d150) at /pb2/build/sb_0-13146106-1409929295.44/mysqlcom-pro-5.7.6-m16/storage/innobase/btr/btr0btr.cc:2583 #10 0x000000000107e122 in btr_root_raise_and_insert (flags=7, cursor=0x7feb7020c710, offsets=0x7feb7020c798, heap=0x7feb7020c7a0, tuple=0x7feaa801e608, n_ext=0, mtr=0x7feb7020d150) at /pb2/build/sb_0-13146106-1409929295.44/mysqlcom-pro-5.7.6-m16/storage/innobase/btr/btr0btr.cc:1717 #11 0x00000000010982e1 in btr_cur_pessimistic_insert (flags=7, cursor=0x7feb7020c710, offsets=0x7feb7020c798, heap=0x7feb7020c7a0, entry=0x7feaa801e608, rec=0x7feb7020c7a8, big_rec=0x7feb7020c7b0, n_ext=0, thr=0x0, mtr=0x7feb7020d150) at /pb2/build/sb_0-13146106-1409929295.44/mysqlcom-pro-5.7.6-m16/storage/innobase/btr/btr0cur.cc:3379 #12 0x000000000107ebdc in btr_insert_on_non_leaf_level_func (flags=3, index=0xc92e008, level=1, tuple=0x7feaa801e608, file=0x15e8500 "/pb2/build/sb_0-13146106-1409929295.44/mysqlcom-pro-5.7.6-m16/storage/innobase/btr/btr0btr.cc", line=2225, mtr=0x7feb7020d150) at /pb2/build/sb_0-13146106-1409929295.44/mysqlcom-pro-5.7.6-m16/storage/innobase/btr/btr0btr.cc:2104 #13 0x000000000107f1d3 in btr_attach_half_pages (flags=3, index=0xc92e008, block=0x7feb0f5b9d80, split_rec=0x7feaa8021f3c "", new_block=0x7feb0f5bc828, direction=111, mtr=0x7feb7020d150) at /pb2/build/sb_0-13146106-1409929295.44/mysqlcom-pro-5.7.6-m16/storage/innobase/btr/btr0btr.cc:2225 #14 0x0000000001080510 in btr_page_split_and_insert (flags=3, cursor=0x7feb7020d640, offsets=0x7feb7020d808, heap=0x7feb7020d810, tuple=0x7feaa804bde8, n_ext=0, mtr=0x7feb7020d150) at /pb2/build/sb_0-13146106-1409929295.44/mysqlcom-pro-5.7.6-m16/storage/innobase/btr/btr0btr.cc:2628 #15 0x000000000107e122 in btr_root_raise_and_insert (flags=3, cursor=0x7feb7020d640, offsets=0x7feb7020d808, heap=0x7feb7020d810, tuple=0x7feaa804bde8, n_ext=0, mtr=0x7feb7020d150) at /pb2/build/sb_0-13146106-1409929295.44/mysqlcom-pro-5.7.6-m16/storage/innobase/btr/btr0btr.cc:1717 #16 0x00000000010982e1 in btr_cur_pessimistic_insert (flags=3, cursor=0x7feb7020d640, offsets=0x7feb7020d808, heap=0x7feb7020d810, entry=0x7feaa804bde8, rec=0x7feb7020d7f8, big_rec=0x7feb7020d818, n_ext=0, thr=0x7feaa8072f20, mtr=0x7feb7020d150) at /pb2/build/sb_0-13146106-1409929295.44/mysqlcom-pro-5.7.6-m16/storage/innobase/btr/btr0cur.cc:3379 #17 0x0000000000ef2145 in ibuf_insert_low (mode=32801, op=IBUF_OP_DELETE_MARK, no_counter=0, entry=0x7feaa804ceb8, entry_size=28, index=0xc926008, page_id=..., page_size=..., thr=0x7feaa8072f20) at /pb2/build/sb_0-13146106-1409929295.44/mysqlcom-pro-5.7.6-m16/storage/innobase/ibuf/ibuf0ibuf.cc:3714 #18 0x0000000000ef274a in ibuf_insert (op=IBUF_OP_DELETE_MARK, entry=0x7feaa804ceb8, index=0xc926008, page_id=..., page_size=..., thr=0x7feaa8072f20) at /pb2/build/sb_0-13146106-1409929295.44/mysqlcom-pro-5.7.6-m16/storage/innobase/ibuf/ibuf0ibuf.cc:3904 #19 0x00000000010927ed in btr_cur_search_to_nth_level (index=0xc926008, level=0, tuple=0x7feaa804ceb8, mode=4, latch_mode=2, cursor=0x7feb7020ef20, has_search_latch=0, file=0x15bf080 "/pb2/build/sb_0-13146106-1409929295.44/mysqlcom-pro-5.7.6-m16/storage/innobase/row/row0row.cc", line=918, mtr=0x7feb7020ea30) at /pb2/build/sb_0-13146106-1409929295.44/mysqlcom-pro-5.7.6-m16/storage/innobase/btr/btr0cur.cc:1120 #20 0x0000000000fd339c in btr_pcur_open_low (index=0xc926008, level=0, tuple=0x7feaa804ceb8, mode=4, latch_mode=4098, cursor=0x7feb7020ef20, file=0x15bf080 "/pb2/build/sb_0-13146106-1409929295.44/mysqlcom-pro-5.7.6-m16/storage/innobase/row/row0row.cc", line=918, mtr=0x7feb7020ea30) at /pb2/build/sb_0-13146106-1409929295.44/mysqlcom-pro-5.7.6-m16/storage/innobase/include/btr0pcur.ic:455 #21 0x0000000000fd531c in row_search_index_entry (index=0xc926008, entry=0x7feaa804ceb8, mode=4098, pcur=0x7feb7020ef20, mtr=0x7feb7020ea30) at /pb2/build/sb_0-13146106-1409929295.44/mysqlcom-pro-5.7.6-m16/storage/innobase/row/row0row.cc:918 #22 0x00000000010027bd in row_upd_sec_index_entry (node=0x7feaa80726c0, thr=0x7feaa8072f20) at /pb2/build/sb_0-13146106-1409929295.44/mysqlcom-pro-5.7.6-m16/storage/innobase/row/row0upd.cc:1733 #23 0x0000000001002d5f in row_upd_sec_step (node=0x7feaa80726c0, thr=0x7feaa8072f20) at /pb2/build/sb_0-13146106-1409929295.44/mysqlcom-pro-5.7.6-m16/storage/innobase/row/row0upd.cc:1866 #24 0x00000000010048f8 in row_upd (node=0x7feaa80726c0, thr=0x7feaa8072f20) at /pb2/build/sb_0-13146106-1409929295.44/mysqlcom-pro-5.7.6-m16/storage/innobase/row/row0upd.cc:2563 #25 0x0000000001004c5b in row_upd_step (thr=0x7feaa8072f20) at /pb2/build/sb_0-13146106-1409929295.44/mysqlcom-pro-5.7.6-m16/storage/innobase/row/row0upd.cc:2681 #26 0x0000000000f62fd8 in que_thr_step (thr=0x7feaa8072f20) at /pb2/build/sb_0-13146106-1409929295.44/mysqlcom-pro-5.7.6-m16/storage/innobase/que/que0que.cc:1035 #27 0x0000000000f632b5 in que_run_threads_low (thr=0x7feaa8072f20) at /pb2/build/sb_0-13146106-1409929295.44/mysqlcom-pro-5.7.6-m16/storage/innobase/que/que0que.cc:1115 #28 0x0000000000f63474 in que_run_threads (thr=0x7feaa8072f20) at /pb2/build/sb_0-13146106-1409929295.44/mysqlcom-pro-5.7.6-m16/storage/innobase/que/que0que.cc:1156 #29 0x0000000000f63726 in que_eval_sql (info=0x7feaa8066108, sql=0x15b6bf0 "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=0x7feb72628ca0) at /pb2/build/sb_0-13146106-1409929295.44/mysqlcom-pro-5.7.6-m16/storage/innobase/que/que0que.cc:1234 #30 0x0000000000fb4b9c in row_drop_table_for_mysql (name=0x7feb7020fa80 "test/t1#P#p1", trx=0x7feb72628ca0, drop_db=false, nonatomic=true, handler=0x0) at /pb2/build/sb_0-13146106-1409929295.44/mysqlcom-pro-5.7.6-m16/storage/innobase/row/row0mysql.cc:4317 #31 0x0000000000eaa675 in ha_innobase::delete_table (this=0x7feaa8006bf8, name=0x7feb70210580 "./test/t1#P#p1") at /pb2/build/sb_0-13146106-1409929295.44/mysqlcom-pro-5.7.6-m16/storage/innobase/handler/ha_innodb.cc:10637 ---Type to continue, or q to quit--- #32 0x00000000008d5ee8 in handler::ha_delete_table (this=0x7feaa8006bf8, name=0x7feb70210580 "./test/t1#P#p1") at /pb2/build/sb_0-13146106-1409929295.44/mysqlcom-pro-5.7.6-m16/sql/handler.cc:4582 #33 0x00000000012a6896 in ha_partition::del_ren_table (this=0x7feaa80063b8, from=0x7feb702119d0 "./test/t1", to=0x0) at /pb2/build/sb_0-13146106-1409929295.44/mysqlcom-pro-5.7.6-m16/sql/ha_partition.cc:2394 #34 0x00000000012a23ee in ha_partition::delete_table (this=0x7feaa80063b8, name=0x7feb702119d0 "./test/t1") at /pb2/build/sb_0-13146106-1409929295.44/mysqlcom-pro-5.7.6-m16/sql/ha_partition.cc:582 #35 0x00000000008d5ee8 in handler::ha_delete_table (this=0x7feaa80063b8, name=0x7feb702119d0 "./test/t1") at /pb2/build/sb_0-13146106-1409929295.44/mysqlcom-pro-5.7.6-m16/sql/handler.cc:4582 #36 0x00000000008cf87d in ha_delete_table (thd=0x7feaa8000d30, table_type=0xc9763d0, path=0x7feb702119d0 "./test/t1", db=0x7feaa80061c8 "test", alias=0x7feaa8005c18 "t1", generate_warning=true) at /pb2/build/sb_0-13146106-1409929295.44/mysqlcom-pro-5.7.6-m16/sql/handler.cc:2291 #37 0x0000000000c14407 in mysql_rm_table_no_locks (thd=0x7feaa8000d30, tables=0x7feaa8005c50, if_exists=true, drop_temporary=false, drop_view=false, dont_log_query=false) at /pb2/build/sb_0-13146106-1409929295.44/mysqlcom-pro-5.7.6-m16/sql/sql_table.cc:2500 #38 0x0000000000c136c0 in mysql_rm_table (thd=0x7feaa8000d30, tables=0x7feaa8005c50, if_exists=1 '\001', drop_temporary=0 '\000') at /pb2/build/sb_0-13146106-1409929295.44/mysqlcom-pro-5.7.6-m16/sql/sql_table.cc:2167 #39 0x0000000000ba4982 in mysql_execute_command (thd=0x7feaa8000d30) at /pb2/build/sb_0-13146106-1409929295.44/mysqlcom-pro-5.7.6-m16/sql/sql_parse.cc:3585 #40 0x0000000000baa012 in mysql_parse (thd=0x7feaa8000d30, parser_state=0x7feb70213660) at /pb2/build/sb_0-13146106-1409929295.44/mysqlcom-pro-5.7.6-m16/sql/sql_parse.cc:5427 #41 0x0000000000b9dec7 in dispatch_command (command=COM_QUERY, thd=0x7feaa8000d30, packet=0x7feaa80098b1 "DROP TABLE IF EXISTS t1", packet_length=23) at /pb2/build/sb_0-13146106-1409929295.44/mysqlcom-pro-5.7.6-m16/sql/sql_parse.cc:1250 #42 0x0000000000b9cb7b in do_command (thd=0x7feaa8000d30) at /pb2/build/sb_0-13146106-1409929295.44/mysqlcom-pro-5.7.6-m16/sql/sql_parse.cc:834 #43 0x0000000000caa2d8 in handle_connection (arg=0xca0b930) at /pb2/build/sb_0-13146106-1409929295.44/mysqlcom-pro-5.7.6-m16/sql/conn_handler/connection_handler_per_thread.cc:298 #44 0x0000000001241f24 in pfs_spawn_thread (arg=0xca57d80) at /pb2/build/sb_0-13146106-1409929295.44/mysqlcom-pro-5.7.6-m16/storage/perfschema/pfs.cc:2137 #45 0x0000003bf26079d1 in start_thread () from /lib64/libpthread.so.0 #46 0x0000003bf22e886d in clone () from /lib64/libc.so.6 (gdb)