Failing assertion: node_addr.page != FIL_NULL in btr0btr.cc line 1101

Bug #1384561 reported by Ramesh Sivaraman
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL Server
Unknown
Unknown
Percona Server moved to https://jira.percona.com/projects/PS
Fix Released
Undecided
Unassigned
5.1
Won't Fix
Undecided
Unassigned
5.5
Fix Released
Low
Unassigned
5.6
Fix Released
Low
Unassigned

Bug Description

GDB info *******************

#0 0x00007ff219e53771 in pthread_kill () from /lib64/libpthread.so.0
#1 0x0000000000ab7586 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 0x000000000072f9ff in handle_fatal_signal (sig=6) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.2
1-69.0/sql/signal_handler.cc:236
#3 <signal handler called>
#4 0x00007ff218a575c9 in raise () from /lib64/libc.so.6
#5 0x00007ff218a58cd8 in abort () from /lib64/libc.so.6
#6 0x0000000000c83739 in btr_page_alloc_for_ibuf (index=0x2d0d5c8, mtr=0x7ff1fc27c580) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_e
xp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/btr/btr0btr.cc:1101
#7 0x0000000000c83901 in btr_page_alloc (index=0x2d0d5c8, hint_page_no=474, file_direction=111 'o', level=1, mtr=0x7ff1fc27c580, init_mtr=0x7ff1fc27c580
) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/btr/btr0btr.cc:1191
#8 0x0000000000c87be2 in btr_page_split_and_insert (flags=7, cursor=0x7ff1fc27bee0, offsets=0x7ff1fc27bf70, heap=0x7ff1fc27bf68, tuple=0x7ff1c0252c68, n
_ext=0, mtr=0x7ff1fc27c580) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/bt
r/btr0btr.cc:3099
#9 0x0000000000c85fef in btr_root_raise_and_insert (flags=7, cursor=0x7ff1fc27bee0, offsets=0x7ff1fc27bf70, heap=0x7ff1fc27bf68, tuple=0x7ff1c0252c68, n
_ext=0, mtr=0x7ff1fc27c580) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/bt
r/btr0btr.cc:2311
#10 0x0000000000c99679 in btr_cur_pessimistic_insert (flags=7, cursor=0x7ff1fc27bee0, offsets=0x7ff1fc27bf70, heap=0x7ff1fc27bf68, entry=0x7ff1c0252c68,
rec=0x7ff1fc27bf78, big_rec=0x7ff1fc27bf80, n_ext=0, thr=0x0, mtr=0x7ff1fc27c580) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/cen
tos6-64/percona-server-5.6.21-69.0/storage/innobase/btr/btr0cur.cc:1728
#11 0x0000000000c8697b in btr_insert_on_non_leaf_level_func (flags=3, index=0x2d0d5c8, level=1, tuple=0x7ff1c0252c68, file=0x109a470 "/mnt/workspace/perc
ona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/btr/btr0btr.cc", line=2767, mtr=0x7ff1fc27c580) at /
mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/btr/btr0btr.cc:2674
#12 0x0000000000c86d3c in btr_attach_half_pages (flags=3, index=0x2d0d5c8, block=0x7ff1effa8378, split_rec=0x7ff1c01d2374 "", new_block=0x7ff1eff9f010, d
irection=111, mtr=0x7ff1fc27c580) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innob
ase/btr/btr0btr.cc:2767
#13 0x0000000000c87eb8 in btr_page_split_and_insert (flags=3, cursor=0x7ff1fc27c4a0, offsets=0x7ff1fc27cf38, heap=0x7ff1fc27cf40, tuple=0x7ff1c01d1d68, n
_ext=0, mtr=0x7ff1fc27c580) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/bt
r/btr0btr.cc:3143
#14 0x0000000000c85fef in btr_root_raise_and_insert (flags=3, cursor=0x7ff1fc27c4a0, offsets=0x7ff1fc27cf38, heap=0x7ff1fc27cf40, tuple=0x7ff1c01d1d68, n
_ext=0, mtr=0x7ff1fc27c580) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/bt
r/btr0btr.cc:2311
#15 0x0000000000c99679 in btr_cur_pessimistic_insert (flags=3, cursor=0x7ff1fc27c4a0, offsets=0x7ff1fc27cf38, heap=0x7ff1fc27cf40, entry=0x7ff1c01d1d68,
rec=0x7ff1fc27cf28, big_rec=0x7ff1fc27cf48, n_ext=0, thr=0x7ff1c03cd1d0, mtr=0x7ff1fc27c580) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/la
bel_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/btr/btr0cur.cc:1728
#16 0x0000000000b1d1e6 in ibuf_insert_low (mode=33, op=IBUF_OP_DELETE_MARK, no_counter=0, entry=0x7ff1c0250428, entry_size=33, index=0x2d081e8, space=0,
zip_size=0, page_no=463, thr=0x7ff1c03cd1d0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/st
orage/innobase/ibuf/ibuf0ibuf.cc:3776
#17 0x0000000000b1d7ae in ibuf_insert (op=IBUF_OP_DELETE_MARK, entry=0x7ff1c0250428, index=0x2d081e8, space=0, zip_size=0, page_no=463, thr=0x7ff1c03cd1d
0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/ibuf/ibuf0ibuf.cc:3963
#18 0x0000000000c971b2 in btr_cur_search_to_nth_level (index=0x2d081e8, level=0, tuple=0x7ff1c0250428, mode=4, latch_mode=2, cursor=0x7ff1fc27d5f0, has_s
earch_latch=0, file=0x1075fa8 "/mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/ro
w/row0row.cc", line=815, mtr=0x7ff1fc27d6d0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/st
orage/innobase/btr/btr0cur.cc:695
#19 0x0000000000bfb219 in btr_pcur_open_low (index=0x2d081e8, level=0, tuple=0x7ff1c0250428, mode=4, latch_mode=4098, cursor=0x7ff1fc27d5f0, file=0x1075f
a8 "/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=815, mt
r=0x7ff1fc27d6d0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/include/btr0
pcur.ic:440
#20 0x0000000000bfcfb9 in row_search_index_entry (index=0x2d081e8, entry=0x7ff1c0250428, mode=4098, pcur=0x7ff1fc27d5f0, mtr=0x7ff1fc27d6d0) at /mnt/work
space/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/row/row0row.cc:815
#21 0x0000000000c1849c in row_upd_sec_index_entry (node=0x7ff1c03cca00, thr=0x7ff1c03cd1d0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/lab
el_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/row/row0upd.cc:1751
#22 0x0000000000c18929 in row_upd_sec_step (node=0x7ff1c03cca00, thr=0x7ff1c03cd1d0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/
centos6-64/percona-server-5.6.21-69.0/storage/innobase/row/row0upd.cc:1866
#23 0x0000000000c1a2b6 in row_upd (node=0x7ff1c03cca00, thr=0x7ff1c03cd1d0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-6
4/percona-server-5.6.21-69.0/storage/innobase/row/row0upd.cc:2569
#24 0x0000000000c1a5b5 in row_upd_step (thr=0x7ff1c03cd1d0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server
-5.6.21-69.0/storage/innobase/row/row0upd.cc:2686
#25 0x0000000000b954cc in que_thr_step (thr=0x7ff1c03cd1d0) 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:1097
#26 0x0000000000b957d3 in que_run_threads_low (thr=0x7ff1c03cd1d0) 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
#27 0x0000000000b959a2 in que_run_threads (thr=0x7ff1c03cd1d0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-ser
ver-5.6.21-69.0/storage/innobase/que/que0que.cc:1218
#28 0x0000000000b95c4a in que_eval_sql (info=0x7ff1c03ab978, sql=0x106e400 "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_name\nAND TO_BINARY(FOR_NAME)\n = TO_BINARY(:table_name)\nLOCK IN SHARE MODE;\nDECLARE CURSOR cur_idx IS\nSELECT ID FROM SYS_INDEXES\nWHERE TABLE_ID = table_id\nLOCK IN SHARE MODE;\nBEGIN\nSELECT ID INTO table_id\nFROM SYS_TABLES\nWHERE NAME = :table_name\nLOCK IN SHARE MODE;\nIF (SQL % NOTFOUND) THEN\n RETURN;\nEND IF;\nSELECT SPACE INTO space_id\nFROM SYS_TABLES\nWHERE NAME = :table_name;\nIF (SQL % NOTFOUND) THEN\n RETURN;\nEND IF;\nfound := 1;\nSELECT ID INTO sys_foreign_id\nFROM SYS_TABLES\nWHERE NAME = 'SYS_FOREIGN'\nLOCK IN SHARE MODE;\nIF (SQL % NOTFOUND) THEN\n found := 0;\nEND IF;\nIF (:table_name = 'SYS_FOREIGN') THEN\n found := 0;\nEND IF;\nIF (:table_name = 'SYS_FOREIGN_COLS') THEN\n found := 0;\nEND IF;\nOPEN cur_fk;\nWHILE found = 1 LOOP\n FETCH cur_fk INTO foreign_id;\n IF (SQL % NOTFOUND) THEN\n", ' ' <repeats 15 times>, "found := 0;\n ELSE\n", ' ' <repeats 15 times>, "DELETE FROM SYS_FOREIGN_COLS\n", ' ' <repeats 15 times>, "WHERE ID = foreign_id;\n", ' ' <repeats 15 times>, "DELETE FROM SYS_FOREIGN\n", ' ' <repeats 15 times>, "WHERE ID = foreign_id;\n END IF;\nEND LOOP;\nCLOSE cur_fk;\nfound := 1;\nOPEN cur_idx;\nWHILE found = 1 LOOP\n FETCH cur_idx INTO index_id;\n IF (SQL % NOTFOUND) THEN\n", ' ' <repeats 15 times>, "found := 0;\n ELSE\n", ' ' <repeats 15 times>, "DELETE FROM SYS_FIELDS\n", ' ' <repeats 15 times>, "WHERE INDEX_ID = index_id;\n", ' ' <repeats 15 times>, "DELETE FROM SYS_INDEXES\n", ' ' <repeats 15 times>, "WHERE ID = index_id\n", ' ' <repeats 15 times>, "AND TABLE_ID = table_id;\n END IF;\nEND LOOP;\nCLOSE cur_idx;\nDELETE FROM SYS_TABLESPACES\nWHERE SPACE = space_id;\nDELETE FROM SYS_DATAFILES\nWHERE SPACE = space_id;\nDELETE FROM SYS_COLUMNS\nWHERE TABLE_ID = table_id;\nDELETE FROM SYS_TABLES\nWHERE NAME = :table_name;\nEND;\n", reserve_dict_mutex=0, trx=0x7ff1c01cb638) 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:1301
#29 0x0000000000bdf1d3 in row_drop_table_for_mysql (name=0x7ff1fc27e550 "tmp/#sql5e33_4_37", trx=0x7ff1c01cb638, drop_db=false, nonatomic=true) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/row/row0mysql.cc:4216
#30 0x0000000000add7d9 in ha_innobase::delete_table (this=0x7ff1c02570c8, name=0x7ff1c035b780 "/dev/shm/072854/4129/tmp/#sql5e33_4_37") 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:10786
#31 0x00000000006466b6 in handler::ha_delete_table (this=0x7ff1c02570c8, name=0x7ff1c035b780 "/dev/shm/072854/4129/tmp/#sql5e33_4_37") at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/handler.cc:4679
#32 0x0000000000776bf3 in rm_temporary_table (base=0x26c3d10, path=0x7ff1c035b780 "/dev/shm/072854/4129/tmp/#sql5e33_4_37") at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_base.cc:6417
#33 0x000000000076f552 in close_temporary (table=0x7ff1c035ab80, free_share=true, delete_table=true) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_base.cc:2250
#34 0x000000000076dced in close_temporary_tables (thd=0x269d560) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_base.cc:1579
#35 0x0000000000796fb6 in THD::cleanup (this=0x269d560) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_class.cc:1714
#36 0x00000000007971bf in THD::release_resources (this=0x269d560) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_class.cc:1771
#37 0x00000000006244ac in one_thread_per_connection_end (thd=0x269d560, block_pthread=true) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/mysqld.cc:2830
#38 0x00000000007a659c in do_handle_one_connection (thd_arg=0x269d560) 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:1546
#39 0x00000000007a5fed in handle_one_connection (arg=0x269d560) 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
#40 0x0000000000dc5bac in pfs_spawn_thread (arg=0x2e551c0) 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
#41 0x00007ff219e4edf3 in start_thread () from /lib64/libpthread.so.0
#42 0x00007ff218b1801d in clone () from /lib64/libc.so.6

Tags: qa upstream

Related branches

Revision history for this message
Ramesh Sivaraman (rameshvs02) wrote :
tags: added: qa
Revision history for this message
Ramesh Sivaraman (rameshvs02) wrote :

Single threaded run, single mysqld involved/

Revision history for this message
Ramesh Sivaraman (rameshvs02) wrote :

This is an upstream bug : http://bugs.mysql.com/bug.php?id=74605

Testcase *****

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;

tags: added: upstream
Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote :

Please remove innodb_change_buffering_debug from RQG grammars

Changed in percona-server:
status: Triaged → Won't Fix
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

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

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.