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

Bug #1444642 reported by Ramesh Sivaraman
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Status tracked in 5.7
5.1
Invalid
Undecided
Unassigned
5.5
Invalid
Undecided
Unassigned
5.6
Triaged
High
Unassigned
5.7
Triaged
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

Revision history for this message
Ramesh Sivaraman (rameshvs02) wrote :
tags: added: set-statement
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-893

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.