handle_fatal_signal (sig=11) in table_cache_key | sql/table_cache.cc:39

Bug #1444642 reported by Ramesh Sivaraman on 2015-04-15
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server
Status tracked in 5.7
5.1
Undecided
Unassigned
5.5
Undecided
Unassigned
5.6
High
Unassigned
5.7
High
Unassigned

Bug Description

** Testcase

DROP DATABASE test;CREATE DATABASE test;USE test;
update performance_schema.setup_instruments set enabled='';
CREATE TABLE t1(c1 REAL,c2 NUMERIC,c3 INT,c4 CHAR (1));
flush tables;
set tokudb_optimize_index_name='';
SELECT EVENT_NAME,e.SUM_NUMBER_OF_BYTES_READ,SUM(i.SUM_NUMBER_OF_BYTES_READ)FROM performance_schema.file_summary_by_event_name AS e JOIN performance_schema.file_summary_by_instance AS i USING (EVENT_NAME);
ALTER TABLE t1 DROP COLUMN c2;
SET STATEMENT myisam_sort_buffer_size=320000,myisam_repair_threads=2,sort_buffer_size=220022,binlog_format=row,keep_files_on_create=ON,max_join_size=2222220000000 FOR CALL p2();
select * from performance_schema.events_waits_summary_by_host_by_event_name;
set tokudb_optimize_index_name='';
ALTER TABLE t1 ADD c2 CHAR(1)FIRST;

** Startup options

--plugin-load=tokudb=ha_tokudb.so

** GDB info

#0 0x00007fa408b08771 in __pthread_kill (threadid=<optimized out>, signo=11) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
#1 0x0000000000abb47a in my_write_core (sig=11) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/mysys/stacktrace.c:422
#2 0x00000000007312c3 in handle_fatal_signal (sig=11) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/signal_handler.cc:236
#3 <signal handler called>
#4 0x00000000008b8058 in table_cache_key (record=0x7fa3f63efc80 "test/t1", length=0x7fa4090b66f0, not_used=0 '\000') at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/table_cache.cc:39
#5 0x0000000000a9b358 in my_hash_key (hash=0x189f070 <table_cache_manager+48>, record=0x7fa3f63efc80 "test/t1", length=0x7fa4090b66f0, first=0 '\000') at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/mysys/hash.c:195
#6 0x0000000000a9b444 in rec_hashnr (hash=0x189f070 <table_cache_manager+48>, record=0x7fa3f63efc80 "test/t1") at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/mysys/hash.c:227
#7 0x0000000000a9bf97 in my_hash_delete (hash=0x189f070 <table_cache_manager+48>, record=0x7fa3f67ffa20 "") at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/mysys/hash.c:565
#8 0x000000000078245b in Table_cache::remove_table (this=0x189f040 <table_cache_manager>, table=0x7fa38e44f000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/table_cache.h:429
#9 0x000000000076f32c in close_thread_table (thd=0x7fa3f637a000, table_ptr=0x7fa3f637a0d0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/sql_base.cc:1523
#10 0x000000000076ecbf in close_all_tables_for_name (thd=0x7fa3f637a000, share=0x7fa406c5f810, remove_from_locked_tables=false, skip_table=0x0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/sql_base.cc:1301
#11 0x0000000000859433 in mysql_inplace_alter_table (thd=0x7fa3f637a000, table_list=0x7fa38e421108, table=0x7fa38e44f000, altered_table=0x7fa406c97800, ha_alter_info=0x7fa4090b7130, inplace_supported=HA_ALTER_INPLACE_NO_LOCK_AFTER_PREPARE, target_mdl_request=0x7fa4090b6b80, alter_ctx=0x7fa4090b7690) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/sql_table.cc:6688
#12 0x000000000085e166 in mysql_alter_table (thd=0x7fa3f637a000, new_db=0x7fa38e421668 "test", new_name=0x0, create_info=0x7fa4090b8550, table_list=0x7fa38e421108, alter_info=0x7fa4090b8490, order_num=0, order=0x0, ignore=false) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/sql_table.cc:8679
#13 0x00000000009a6599 in Sql_cmd_alter_table::execute (this=0x7fa38e421738, thd=0x7fa3f637a000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/sql_alter.cc:317
#14 0x00000000007eb7f9 in mysql_execute_command (thd=0x7fa3f637a000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/sql_parse.cc:5445
#15 0x00000000007ef059 in mysql_parse (thd=0x7fa3f637a000, rawbuf=0x7fa38e421010 "ALTER TABLE t1 ADD c2 CHAR(1)FIRST", length=34, parser_state=0x7fa4090b9df0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/sql_parse.cc:6922
#16 0x00000000007e0ecf in dispatch_command (command=COM_QUERY, thd=0x7fa3f637a000, packet=0x7fa3ef7e6001 "ALTER TABLE t1 ADD c2 CHAR(1)FIRST", packet_length=34) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/sql_parse.cc:1434
#17 0x00000000007dfded in do_command (thd=0x7fa3f637a000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/sql_parse.cc:1051
#18 0x00000000007a7d0d in do_handle_one_connection (thd_arg=0x7fa3f637a000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/sql_connect.cc:1532
#19 0x00000000007a7815 in handle_one_connection (arg=0x7fa3f637a000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/sql_connect.cc:1443
#20 0x0000000000dcc8ac in pfs_spawn_thread (arg=0x7fa402341740) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/storage/perfschema/pfs.cc:1860
#21 0x00007fa408b03df5 in start_thread (arg=0x7fa4090bb700) at pthread_create.c:308
#22 0x00007fa4077cd1ad in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113

Ramesh Sivaraman (rameshvs02) wrote :
tags: added: set-statement
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers