handle_fatal_signal (sig=11) in open_table_error | sql/table.cc:2699

Bug #1416975 reported by Ramesh Sivaraman
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Triaged
High
Unassigned
5.1
Invalid
Undecided
Unassigned
5.5
Invalid
Undecided
Unassigned
5.6
Triaged
High
Unassigned

Bug Description

** Startup options

--plugin-load=audit_log=audit_log.so\;tokudb=ha_tokudb.so --init-file=/sda/percona-qa/TokuDB.sql --event-scheduler=ON --maximum-bulk_insert_buffer_size=1M --maximum-join_buffer_size=1M --maximum-max_heap_table_size=1M --maximum-max_join_size=1M --maximum-myisam_max_sort_file_size=1M --maximum-myisam_mmap_size=1M --maximum-myisam_sort_buffer_size=1M --maximum-optimizer_trace_max_mem_size=1M --maximum-preload_buffer_size=1M --maximum-query_alloc_block_size=1M --maximum-query_prealloc_size=1M --maximum-range_alloc_block_size=1M --maximum-read_buffer_size=1M --maximum-read_rnd_buffer_size=1M --maximum-sort_buffer_size=1M --maximum-tmp_table_size=1M --maximum-transaction_alloc_block_size=1M --maximum-transaction_prealloc_size=1M --log-output=none --sql_mode=ONLY_FULL_GROUP_BY --log-error=/dev/shm/1422858155/error.log.out --event-scheduler=ON

** Testcase

DROP DATABASE test;CREATE DATABASE test;USE test;
create temporary table t1(a int)select 1 as a;
SET lc_messages=cs_CZ;
handler t1 open as t1;
set debug_sync='p0 signal s1 wait_for s2 timeout 6 hit_';
FLUSH LOCAL TABLES test.t1,t1 for ExPoRt;
SET STATEMENT sort_buffer_size=150000 FOR SELECT * FROM t1;
SELECT FROM_BASE64(TO_BASE64(dt1)) FROM t1;

** GDB info

#1 0x00000000006772cd in handle_fatal_signal (sig=11) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71
.0/sql/signal_handler.cc:236
#2 <signal handler called>
#3 0x00000000005b6dca in get_server_errmsgs () at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/
derror.cc:40
#4 0x00000000008e703d in my_get_err_msg (nr=nr@entry=1146) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/mysys/my_error.c:149
#5 0x00000000008e70d4 in my_error (nr=1146, MyFlags=0) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/mysys/my_error.c:176
#6 0x0000000000776e6c in open_table_error (share=share@entry=0x7f716cc99c10, error=error@entry=1, db_errno=2, errarg=errarg@entry=0) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/table.cc:2699
#7 0x000000000077723b in open_table_def (thd=thd@entry=0x7f7191f3f000, share=share@entry=0x7f716cc99c10, db_flags=db_flags@entry=8192) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/table.cc:779
#8 0x00000000006aa0fd in get_table_share (thd=thd@entry=0x7f7191f3f000, table_list=table_list@entry=0x7f716cc1f4d8, key=0x7f716cc1f89d "test", key_length=key_length@entry=8, db_flags=db_flags@entry=8192, error=error@entry=0x7f71a435a750, hash_value=hash_value@entry=1096967734) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_base.cc:508
#9 0x00000000006ab198 in get_table_share_with_discover (db_flags=8192, hash_value=1096967734, error=0x7f71a435a750, key_length=8, key=<optimized out>, table_list=0x7f716cc1f4d8, thd=0x7f7191f3f000) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_base.cc:587
#10 open_table (thd=thd@entry=0x7f7191f3f000, table_list=table_list@entry=0x7f716cc1f4d8, ot_ctx=ot_ctx@entry=0x7f71a435aae0) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_base.cc:3056
#11 0x00000000006b3725 in open_and_process_table (ot_ctx=0x7f71a435aae0, has_prelocking_list=false, prelocking_strategy=0x7f71a435ad20, flags=0, counter=0x7f7191f415d8, tables=0x7f716cc1f4d8, lex=0x7f7191f41518, thd=0x7f7191f3f000) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_base.cc:4719
#12 open_tables (thd=thd@entry=0x7f7191f3f000, start=start@entry=0x7f71a435ad18, counter=0x7f7191f415d8, flags=flags@entry=0, prelocking_strategy=prelocking_strategy@entry=0x7f71a435ad20) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_base.cc:5233
#13 0x00000000006b4041 in open_normal_and_derived_tables (thd=thd@entry=0x7f7191f3f000, tables=0x7f716cc1f4d8, flags=flags@entry=0) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_base.cc:5933
#14 0x000000000057e84e in execute_sqlcom_select (thd=thd@entry=0x7f7191f3f000, all_tables=<optimized out>) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_parse.cc:5604
#15 0x00000000006f86a4 in mysql_execute_command (thd=thd@entry=0x7f7191f3f000) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_parse.cc:2989
#16 0x00000000006fd2d8 in mysql_parse (thd=thd@entry=0x7f7191f3f000, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7f71a435c270) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_parse.cc:6919
#17 0x00000000006fea49 in dispatch_command (command=<optimized out>, thd=0x7f7191f3f000, packet=0x7f718b7b3001 "SELECT FROM_BASE64(TO_BASE64(dt1)) FROM t1", packet_length=<optimized out>) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_parse.cc:1434
#18 0x00000000007007a9 in do_command (thd=<optimized out>) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_parse.cc:1051
#19 0x00000000006cc392 in do_handle_one_connection (thd_arg=thd_arg@entry=0x7f7191f3f000) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_connect.cc:1532
#20 0x00000000006cc480 in handle_one_connection (arg=arg@entry=0x7f7191f3f000) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_connect.cc:1443
#21 0x0000000000afd6b3 in pfs_spawn_thread (arg=0x7f719d33f6a0) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/storage/perfschema/pfs.cc:1860
#22 0x00007f71a3da7df3 in start_thread () from /lib64/libpthread.so.0
#23 0x00007f71a2a711ad in clone () from /lib64/libc.so.6

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

PFA testcase info. To reproduce this bug please change 1422858155_mybase to PS base path, then init > start > cl (to verify it's up) > run. But testcase above should work fine.

tags: added: set-statement
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.