handle_fatal_signal (sig=11) in set_var::check | sql/set_var.cc:606

Bug #1417028 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
Triaged
High
Unassigned
5.1
New
Undecided
Unassigned
5.5
New
Undecided
Unassigned
5.6
Triaged
High
Unassigned

Bug Description

** Testcase

DROP DATABASE test;CREATE DATABASE test;USE test;
SET lc_messages=sr_YU;
use INFORMATION_SCHEMA;
SET SESSION TRANSACTION ISOLATION LEVEL SERIALIZABLE,READ ONLY;
SET DEBUG_SYNC='now WAIT_FOR c0e_created';
CREATE TABLE t0(c0 DATE,c0 CHAR,c0 INT,c0 CHAR KEY,c0 DATE UNIQUE KEY,c0 FIXED(0,0)DEFAULT 0.0);
SET STATEMENT myisam_sort_buffer_size=0,myisam_repair_threads=0,sort_buffer_size=0,binlog_format=row,keep_files_on_create=OFF,max_join_size=0 FOR DROP FUNCTION myProc;
set global performance_schema_events_stages_history_long_size=0;

** Startup

 --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/1422862720/error.log.out --event-scheduler=ON

** GDB info

#0 0x00007ff8be41a771 in pthread_kill () from /lib64/libpthread.so.0
#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=1238) 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=1238, 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 0x00000000006763d3 in set_var::check (this=0x7ff88701f1f8, thd=0x7ff8ac33f000) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/set_var.cc:606
#7 0x00000000006769d9 in sql_set_variables (thd=thd@entry=0x7ff8ac33f000, var_list=var_list@entry=0x7ff8ac3421d8) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/set_var.cc:572
#8 0x00000000006f887a in mysql_execute_command (thd=thd@entry=0x7ff8ac33f000) 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:4156
#9 0x00000000006fd2d8 in mysql_parse (thd=thd@entry=0x7ff8ac33f000, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7ff8be9ca270) 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
#10 0x00000000006fea49 in dispatch_command (command=<optimized out>, thd=0x7ff8ac33f000, packet=0x7ff8a5bb2001 "set global performance_schema_events_stages_history_long_size=0", 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
#11 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
#12 0x00000000006cc392 in do_handle_one_connection (thd_arg=thd_arg@entry=0x7ff8ac33f000) 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
#13 0x00000000006cc480 in handle_one_connection (arg=arg@entry=0x7ff8ac33f000) 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
#14 0x0000000000afd6b3 in pfs_spawn_thread (arg=0x7ff8b7b3f6a0) 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
#15 0x00007ff8be415df3 in start_thread () from /lib64/libpthread.so.0
#16 0x00007ff8bd0df1ad 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 1422862720_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.