// 5.6.22 debug build 2014-10-30 10:45:00 6967 [Note] /data/ushastry/server/mysql-advanced-5.6.22/bin/mysqld-debug: ready for connections. Version: '5.6.22-enterprise-commercial-advanced-debug' socket: '/tmp/mysql.sock' port: 3306 MySQL Enterprise Server - Advanced Edition Debug (Commercial) innodb_change_buffering_debug flush 0 413 innodb_change_buffering_debug evict 0 413 2014-10-30 10:45:09 7fe53eb88700 InnoDB: Assertion failure in thread 140622576518912 in file btr0btr.cc line 1081 InnoDB: Failing assertion: node_addr.page != FIL_NULL (gdb) bt #0 0x0000003bf260c8ac in pthread_kill () from /lib64/libpthread.so.0 #1 0x0000000000afe982 in my_write_core (sig=6) at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/mysys/stacktrace.c:422 #2 0x000000000077e6cc in handle_fatal_signal (sig=6) at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/sql/signal_handler.cc:230 #3 #4 0x0000003bf2232635 in raise () from /lib64/libc.so.6 #5 0x0000003bf2233e15 in abort () from /lib64/libc.so.6 #6 0x0000000000d32030 in btr_page_alloc_for_ibuf (index=0x7df0338, mtr=0x7fe53eb82120) at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/storage/innobase/btr/btr0btr.cc:1081 #7 0x0000000000d321fb in btr_page_alloc (index=0x7df0338, hint_page_no=432, file_direction=111 'o', level=1, mtr=0x7fe53eb82120, init_mtr=0x7fe53eb82120) at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/storage/innobase/btr/btr0btr.cc:1171 #8 0x0000000000d3649a in btr_page_split_and_insert (flags=7, cursor=0x7fe53eb81740, offsets=0x7fe53eb817d0, heap=0x7fe53eb817c8, tuple=0x7fe524064ba8, n_ext=0, mtr=0x7fe53eb82120) at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/storage/innobase/btr/btr0btr.cc:3057 #9 0x0000000000d3485f in btr_root_raise_and_insert (flags=7, cursor=0x7fe53eb81740, offsets=0x7fe53eb817d0, heap=0x7fe53eb817c8, tuple=0x7fe524064ba8, n_ext=0, mtr=0x7fe53eb82120) at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/storage/innobase/btr/btr0btr.cc:2269 #10 0x0000000000d47179 in btr_cur_pessimistic_insert (flags=7, cursor=0x7fe53eb81740, offsets=0x7fe53eb817d0, heap=0x7fe53eb817c8, entry=0x7fe524064ba8, rec=0x7fe53eb817d8, big_rec=0x7fe53eb817e0, n_ext=0, thr=0x0, mtr=0x7fe53eb82120) at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/storage/innobase/btr/btr0cur.cc:1601 #11 0x0000000000d351ec in btr_insert_on_non_leaf_level_func (flags=3, index=0x7df0338, level=1, tuple=0x7fe524064ba8, file=0x1167408 "/export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/storage/innobase/btr/btr0btr.cc", line=2725, mtr=0x7fe53eb82120) at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/storage/innobase/btr/btr0btr.cc:2632 #12 0x0000000000d355b1 in btr_attach_half_pages (flags=3, index=0x7df0338, block=0x7fe5596c65c0, split_rec=0x7fe524064af4 "", new_block=0x7fe5596c91c0, direction=111, mtr=0x7fe53eb82120) at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/storage/innobase/btr/btr0btr.cc:2725 #13 0x0000000000d36779 in btr_page_split_and_insert (flags=3, cursor=0x7fe53eb825f0, offsets=0x7fe53eb827a8, heap=0x7fe53eb827b0, tuple=0x7fe524068348, n_ext=0, mtr=0x7fe53eb82120) at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/storage/innobase/btr/btr0btr.cc:3101 #14 0x0000000000d3485f in btr_root_raise_and_insert (flags=3, cursor=0x7fe53eb825f0, offsets=0x7fe53eb827a8, heap=0x7fe53eb827b0, tuple=0x7fe524068348, n_ext=0, mtr=0x7fe53eb82120) at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/storage/innobase/btr/btr0btr.cc:2269 #15 0x0000000000d47179 in btr_cur_pessimistic_insert (flags=3, cursor=0x7fe53eb825f0, offsets=0x7fe53eb827a8, heap=0x7fe53eb827b0, entry=0x7fe524068348, rec=0x7fe53eb82798, big_rec=0x7fe53eb827b8, n_ext=0, thr=0x7fe524076b50, mtr=0x7fe53eb82120) at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/storage/innobase/btr/btr0cur.cc:1601 #16 0x0000000000bdcd3b in ibuf_insert_low (mode=33, op=IBUF_OP_DELETE_MARK, no_counter=0, entry=0x7fe524067ec8, entry_size=28, index=0x7deb388, space=0, zip_size=0, page_no=413, thr=0x7fe524076b50) at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/storage/innobase/ibuf/ibuf0ibuf.cc:3730 #17 0x0000000000bdd301 in ibuf_insert (op=IBUF_OP_DELETE_MARK, entry=0x7fe524067ec8, index=0x7deb388, space=0, zip_size=0, page_no=413, thr=0x7fe524076b50) at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/storage/innobase/ibuf/ibuf0ibuf.cc:3917 #18 0x0000000000d44fe4 in btr_cur_search_to_nth_level (index=0x7deb388, level=0, tuple=0x7fe524067ec8, mode=4, latch_mode=2, cursor=0x7fe53eb83370, has_search_latch=0, file=0x1146f00 "/export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/storage/innobase/row/row0row.cc", line=815, mtr=0x7fe53eb82ea0) at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/storage/innobase/btr/btr0cur.cc:638 #19 0x0000000000cae63e in btr_pcur_open_low (index=0x7deb388, level=0, tuple=0x7fe524067ec8, mode=4, latch_mode=4098, cursor=0x7fe53eb83370, file=0x1146f00 "/export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/storage/innobase/row/row0row.cc", line=815, mtr=0x7fe53eb82ea0) at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/storage/innobase/include/btr0pcur.ic:440 #20 0x0000000000cb0363 in row_search_index_entry (index=0x7deb388, entry=0x7fe524067ec8, mode=4098, pcur=0x7fe53eb83370, mtr=0x7fe53eb82ea0) at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/storage/innobase/row/row0row.cc:815 #21 0x0000000000ccb37b in row_upd_sec_index_entry (node=0x7fe524076380, thr=0x7fe524076b50) at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/storage/innobase/row/row0upd.cc:1746 #22 0x0000000000ccb823 in row_upd_sec_step (node=0x7fe524076380, thr=0x7fe524076b50) at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/storage/innobase/row/row0upd.cc:1861 #23 0x0000000000ccd137 in row_upd (node=0x7fe524076380, thr=0x7fe524076b50) at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/storage/innobase/row/row0upd.cc:2556 #24 0x0000000000ccd43d in row_upd_step (thr=0x7fe524076b50) at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/storage/innobase/row/row0upd.cc:2673 #25 0x0000000000c4a5da in que_thr_step (thr=0x7fe524076b50) at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/storage/innobase/que/que0que.cc:1087 #26 0x0000000000c4a8e1 in que_run_threads_low (thr=0x7fe524076b50) at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/storage/innobase/que/que0que.cc:1167 #27 0x0000000000c4aaab in que_run_threads (thr=0x7fe524076b50) at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/storage/innobase/que/que0que.cc:1208 #28 0x0000000000c4ad11 in que_eval_sql (info=0x7fe524065d48, sql=0x113fd08 "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=0x7fe524047638) at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/storage/innobase/que/que0que.cc:1285 #29 0x0000000000c929a9 in row_drop_table_for_mysql (name=0x7fe53eb83d90 "test/t1#P#p1", trx=0x7fe524047638, drop_db=false, nonatomic=true) at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/storage/innobase/row/row0mysql.cc:4200 #30 0x0000000000ba0770 in ha_innobase::delete_table (this=0x7fe524007d38, name=0x7fe53eb84840 "./test/t1#P#p1") at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/storage/innobase/handler/ha_innodb.cc:10023 ---Type to continue, or q to quit--- #31 0x0000000000693792 in handler::ha_delete_table (this=0x7fe524007d38, name=0x7fe53eb84840 "./test/t1#P#p1") at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/sql/handler.cc:4492 #32 0x0000000000e7d170 in ha_partition::del_ren_table (this=0x7fe5240075a0, from=0x7fe53eb85be0 "./test/t1", to=0x0) at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/sql/ha_partition.cc:2353 #33 0x0000000000e78f04 in ha_partition::delete_table (this=0x7fe5240075a0, name=0x7fe53eb85be0 "./test/t1") at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/sql/ha_partition.cc:585 #34 0x0000000000693792 in handler::ha_delete_table (this=0x7fe5240075a0, name=0x7fe53eb85be0 "./test/t1") at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/sql/handler.cc:4492 #35 0x000000000068e647 in ha_delete_table (thd=0x7e5eaa0, table_type=0x7e1ebf0, path=0x7fe53eb85be0 "./test/t1", db=0x7fe5240073c0 "test", alias=0x7fe524006e28 "t1", generate_warning=true) at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/sql/handler.cc:2350 #36 0x00000000008940a0 in mysql_rm_table_no_locks (thd=0x7e5eaa0, tables=0x7fe524006e60, if_exists=true, drop_temporary=false, drop_view=false, dont_log_query=false) at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/sql/sql_table.cc:2518 #37 0x0000000000893479 in mysql_rm_table (thd=0x7e5eaa0, tables=0x7fe524006e60, if_exists=1 '\001', drop_temporary=0 '\000') at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/sql/sql_table.cc:2196 #38 0x00000000008303f4 in mysql_execute_command (thd=0x7e5eaa0) at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/sql/sql_parse.cc:3641 #39 0x00000000008375d1 in mysql_parse (thd=0x7e5eaa0, rawbuf=0x7fe524006d80 "DROP TABLE IF EXISTS t1", length=23, parser_state=0x7fe53eb87680) at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/sql/sql_parse.cc:6245 #40 0x000000000082a3a2 in dispatch_command (command=COM_QUERY, thd=0x7e5eaa0, packet=0x7f8dd21 "DROP TABLE IF EXISTS t1", packet_length=23) at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/sql/sql_parse.cc:1332 #41 0x0000000000829407 in do_command (thd=0x7e5eaa0) at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/sql/sql_parse.cc:1034 #42 0x00000000007f0887 in do_handle_one_connection (thd_arg=0x7e5eaa0) at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/sql/sql_connect.cc:982 #43 0x00000000007f0358 in handle_one_connection (arg=0x7e5eaa0) at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/sql/sql_connect.cc:898 #44 0x0000000000e5c19d in pfs_spawn_thread (arg=0x7f51450) at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/storage/perfschema/pfs.cc:1860 #45 0x0000003bf26079d1 in start_thread () from /lib64/libpthread.so.0 #46 0x0000003bf22e886d in clone () from /lib64/libc.so.6