Percona Server moved to https://jira.percona.com/projects/PS

handle_fatal_signal (sig=11) in i_s_fts_config_fill on SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_CONFIG

Bug #1375153 reported by Ramesh Sivaraman on 2014-09-29

This bug affects 1 person

	Status	Importance	Assigned to	Milestone
MySQL Server	Unknown	Unknown	mysql-bugs #74130
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	Fix Released	High	Unassigned	Percona Server moved to https://jira.percona.com/projects/PS 5.6.24-72.2
5.7	Fix Released	High	Unassigned	Percona Server moved to https://jira.percona.com/projects/PS 5.7.10-1rc1

Bug Description

************************ GDB info
+bt
#0 0x00007f20ba4cc69c in pthread_kill () from /lib64/libpthread.so.0
#1 0x0000000000ab6f6a in my_write_core (sig=11) 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 0x000000000072f89f in handle_fatal_signal (sig=11) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/signal_handler.cc:236
#3 <signal handler called>
#4 0x0000000000b04586 in i_s_fts_config_fill (thd=0x7f2091740000, tables=0x7f2020dae278) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/handler/i_s.cc:4042
#5 0x0000000000840b3b in do_fill_table (thd=0x7f2091740000, table_list=0x7f2020dae278, join_table=0x7f2020dafb40) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_show.cc:7902
#6 0x0000000000840f0a in get_schema_tables_result (join=0x7f2020daebb8, executed_place=PROCESSED_BY_JOIN_EXEC) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_show.cc:8003
#7 0x00000000008133c2 in JOIN::prepare_result (this=0x7f2020daebb8, columns_list=0x7f2022f79820) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_select.cc:823
#8 0x00000000007b03ab in JOIN::exec (this=0x7f2020daebb8) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_executor.cc:116
#9 0x0000000000813ebb in mysql_execute_select (thd=0x7f2091740000, select_lex=0x7f2091742c60, free_join=true) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_select.cc:1100
#10 0x00000000008141b7 in mysql_select (thd=0x7f2091740000, tables=0x7f2020dae278, wild_num=1, fields=..., conds=0x0, order=0x7f2091742e28, group=0x7f2091742d60, having=0x0, select_options=2684619520, result=0x7f2020daeb90, unit=0x7f2091742618, select_lex=0x7f2091742c60) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_select.cc:1221
#11 0x0000000000812246 in handle_select (thd=0x7f2091740000, result=0x7f2020daeb90, setup_tables_done_option=0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_select.cc:110
#12 0x00000000007ea732 in execute_sqlcom_select (thd=0x7f2091740000, all_tables=0x7f2020dae278) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:5597
#13 0x00000000007e2c89 in mysql_execute_command (thd=0x7f2091740000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:2958
#14 0x00000000007ed033 in mysql_parse (thd=0x7f2091740000, rawbuf=0x7f2020dae010 "SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_CONFIG", length=49, parser_state=0x7f2022f7ac90) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:6773
#15 0x00000000007df49c in dispatch_command (command=COM_QUERY, thd=0x7f2091740000, packet=0x7f2091744001 "SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_CONFIG", packet_length=49) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:1432
#16 0x00000000007de3c8 in do_command (thd=0x7f2091740000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:1049
#17 0x00000000008c2ad0 in threadpool_process_request (thd=0x7f2091740000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/threadpool_common.cc:311
#18 0x00000000008c5412 in handle_event (connection=0x7f20843f0bb0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/threadpool_unix.cc:1553
#19 0x00000000008c5642 in worker_main (param=0x1897800) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/threadpool_unix.cc:1606
#20 0x0000000000dc5590 in pfs_spawn_thread (arg=0x7f2024c84020) 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
#21 0x00007f20ba4c7851 in start_thread () from /lib64/libpthread.so.0
#22 0x00007f20b923194d in clone () from /lib64/libc.so.6
(gdb) +set logging off

*********** Testcase

DROP DATABASE test;CREATE DATABASE test;USE test;
SET SESSION OLD_ALTER_TABLE=1;
CREATE TABLE fti_t1(
c1 INT unsigned,
c2 TEXT,
FULLTEXT KEY k5(c2)
)ENGINE=INNODB;
SET GLOBAL innodb_ft_aux_table='test/fti_t1';
ALTER TABLE fti_t1 DROP INDEX k5;
SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_CONFIG;

********************* Server version
Percona-Server-5.6.21-rel69.0-669.Linux.x86_64-debug

********************* Server start command

if [ -r /usr/lib64/libjemalloc.so.1 ]; then export LD_PRELOAD=/usr/lib64/libjemalloc.so.1
elif [ -r /usr/lib/x86_64-linux-gnu/libjemalloc.so.1 ]; then export LD_PRELOAD=/usr/lib/x86_64-linux-gnu/libjemalloc.so.1
elif [ -r /ssd/qa56dbg/79/lib/mysql/libjemalloc.so.1 ]; then export LD_PRELOAD=/ssd/qa56dbg/79/lib/mysql/libjemalloc.so.1
else echo 'Error: jemalloc not found, please install it first'; exit 1; fi
/ssd/qa56dbg/Percona-Server-5.6.21-rel69.0-669.Linux.x86_64-debug/bin/mysqld --basedir=/ssd/qa56dbg/Percona-Server-5.6.21-rel69.0-669.Linux.x86_64-debug --tmpdir=/ssd/qa56dbg/79/data --datadir=/ssd/qa56dbg/79/vardir1_490/master-data --core --socket=/ssd/qa56dbg/79/vardir1_490/socket.sock --innodb_log_arch_dir=/ssd/qa56dbg/79/vardir1_490/1411877584024446620 --innodb_log_group_home_dir=/ssd/qa56dbg/79/vardir1_490/1411877584024446620 --log-error=/ssd/qa56dbg/79/vardir1_490/log/master.err 2>&1 &
echo 'Server socket: /ssd/qa56dbg/79/vardir1_490/socket.sock with vardir: /ssd/qa56dbg/79/vardir1_490'
echo 'Base Directory: /ssd/qa56dbg/Percona-Server-5.6.21-rel69.0-669.Linux.x86_64-debug'