handle_fatal_signal (sig=11) in well_formed_copy_nchars | sql/sql_string.cc:913

Bug #1417372 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

** Startup

--plugin-load=audit_log=audit_log.so --audit_log_strategy=PERFORMANCE --audit_log_flush=ON --audit_log_buffer_size=1G --audit_log_format=NEW --audit_log_rotate_on_size=20 --audit_log_rotations=10 --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/1422932788/error.log.out --event-scheduler=ON

** Testcase

DROP DATABASE test;CREATE DATABASE test;USE test;
CREATE TEMPORARY TABLE t1(id int);
create TABLE t1(a int,val char)engine=InnoDB;
SET @@global.log_output="TABLE";
SET GLOBAL slow_query_log=1;
SET tx_read_only=1;
SELECT t1.c1,t6.c1 FROM t1 STRAIGHT_JOIN t1 ON t1.c1=t6.c1;
handler t1 open;
SET STATEMENT max_join_size=1000000000000 FOR SELECT * FROM t1;

** GDB info

#0 0x00007f04bb794771 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 0x00000000008ced2a in my_charset_same (cs1=0x0, cs2=<optimized out>) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/mysys/charset.c:36
#4 0x000000000073f318 in well_formed_copy_nchars (to_cs=0x1366480 <my_charset_utf8_general_ci>, to=to@entry=0x7f045b481060 "", to_length=75, from_cs=from_cs@entry=0x0, from=from@entry=0x7f04bbd49f00 "root[root] @ localhost []", from_length=from_length@entry=25, nchars=nchars@entry=25, well_formed_error_pos=well_formed_error_pos@entry=0x7f04bbd494b0, cannot_convert_error_pos=cannot_convert_error_pos@entry=0x7f04bbd494c0, from_end_pos=from_end_pos@entry=0x7f04bbd494d0) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_string.cc:913
#5 0x00000000007cc4f8 in Field_blob::store_internal (this=0x7f045b49a4f8, from=0x7f04bbd49f00 "root[root] @ localhost []", length=<optimized out>, cs=0x0) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/field.cc:7810
#6 0x000000000066251f in Log_to_csv_event_handler::log_slow (this=<optimized out>, thd=0x7f04a8f39000, current_utime=<optimized out>, query_start_arg=1422936673, user_host=0x7f04bbd49f00 "root[root] @ localhost []", user_host_len=25, query_utime=22, lock_utime=0, is_command=false, sql_text=0x7f045b41f010 "SET STATEMENT max_join_size=1", '0' <repeats 12 times>, " FOR SELECT * FROM t1", sql_text_len=62) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/log.cc:621
#7 0x0000000000660773 in LOGGER::slow_log_print (this=this@entry=0x137aa70 <logger>, thd=0x7f04a8f39000, query=0x7f045b41f010 "SET STATEMENT max_join_size=1", '0' <repeats 12 times>, " FOR SELECT * FROM t1", query_length=62) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/log.cc:1125
#8 0x0000000000664c09 in slow_log_print (thd=<optimized out>, query=<optimized out>, query_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/log.cc:2351
#9 0x00000000006f1c1e in log_slow_statement (thd=thd@entry=0x7f04a8f39000) 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:2135
#10 0x00000000006fdd12 in dispatch_command (command=<optimized out>, thd=0x7f04a8f39000, packet=<optimized out>, 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:1872
#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=0x7f04a8f39000) 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=0x7f04a8f39000) 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=0x7f04b4f3f060) 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 0x00007f04bb78fdf3 in start_thread () from /lib64/libpthread.so.0
#16 0x00007f04ba4591ad 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 1422932788_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.