handle_fatal_signal (sig=11) in decimal_add | strings/decimal.c:2036

Bug #1384658 reported by Ramesh Sivaraman on 2014-10-23
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL Server
Unknown
Unknown
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
5.7
Fix Released
High
Unassigned

Bug Description

** GDB info

#0 0x00007fcd9e7cd771 in pthread_kill () from /lib64/libpthread.so.0
#1 0x0000000000ab7586 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 0x000000000072f9ff 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 0x0000000000e96713 in decimal_add (from1=0x0, from2=0x7fcd803f5db0, to=0x7fcd803f5f30) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/labe
l_exp/centos6-64/percona-server-5.6.21-69.0/strings/decimal.c:2036
#5 0x000000000067121a in my_decimal_add (mask=28, res=0x7fcd803f5f30, a=0x0, b=0x7fcd803f5db0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl
/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/my_decimal.h:457
#6 0x00000000006b13aa in Item_func_plus::decimal_op (this=0x7fcd440067c8, decimal_value=0x7fcd803f5f30) at /mnt/workspace/percona-server-5.6-binaries-de
bug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/item_func.cc:1397
#7 0x00000000006b00a7 in Item_func_numhybrid::val_decimal (this=0x7fcd440067c8, decimal_value=0x7fcd803f5f30) at /mnt/workspace/percona-server-5.6-binar
ies-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/item_func.cc:1022
#8 0x000000000064f57e in Item::val_decimal_result (this=0x7fcd440067c8, val=0x7fcd803f5f30) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/la
bel_exp/centos6-64/percona-server-5.6.21-69.0/sql/item.h:1190
#9 0x0000000000939433 in make_sortkey (param=0x7fcd803f62f0, to=0x7fcd44936528 '\217' <repeats 3304 times>, ref_pos=0x7fcd44886418 "") at /mnt/workspace
/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/filesort.cc:1094
#10 0x0000000000938738 in find_all_keys (param=0x7fcd803f62f0, select=0x7fcd4489e598, fs_info=0x7fcd803f6280, buffpek_pointers=0x7fcd803f6490, tempfile=0
x7fcd803f6370, pq=0x0, found_rows=0x7fcd803f6710) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/filesort.cc:817
#11 0x0000000000936ef1 in filesort (thd=0x2d48530, table=0x7fcd448d5250, filesort=0x7fcd4489ed70, sort_positions=false, examined_rows=0x7fcd803f6718, found_rows=0x7fcd803f6710) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/filesort.cc:339
#12 0x00000000007b8257 in create_sort_index (thd=0x2d48530, join=0x7fcd440069a8, tab=0x7fcd4489df98) 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:3346
#13 0x00000000007b5d09 in st_join_table::sort_table (this=0x7fcd4489df98) 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:2511
#14 0x00000000007b57d9 in join_init_read_record (tab=0x7fcd4489df98) 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:2385
#15 0x00000000007b3083 in sub_select (join=0x7fcd440069a8, join_tab=0x7fcd4489df98, end_of_records=false) 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:1256
#16 0x00000000007b2a6d in do_select (join=0x7fcd440069a8) 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:933
#17 0x00000000007b09c9 in JOIN::exec (this=0x7fcd440069a8) 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:194
#18 0x000000000081401b in mysql_execute_select (thd=0x2d48530, select_lex=0x2d4b190, 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
#19 0x0000000000814317 in mysql_select (thd=0x2d48530, tables=0x7fcd44006098, wild_num=0, fields=..., conds=0x0, order=0x2d4b358, group=0x2d4b290, having=0x0, select_options=2349075200, result=0x7fcd44006980, unit=0x2d4ab48, select_lex=0x2d4b190) 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
#20 0x00000000008123a6 in handle_select (thd=0x2d48530, result=0x7fcd44006980, 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
#21 0x00000000007ea892 in execute_sqlcom_select (thd=0x2d48530, all_tables=0x7fcd44006098) 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
#22 0x00000000007e2de9 in mysql_execute_command (thd=0x2d48530) 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
#23 0x00000000007ed193 in mysql_parse (thd=0x2d48530, rawbuf=0x7fcd440050a0 "SELECT (SELECT t1.a) aa, COUNT(DISTINCT b) FROM t1 GROUP BY aa+0", length=64, parser_state=0x7fcd803f7e30) 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
#24 0x00000000007df5fc in dispatch_command (command=COM_QUERY, thd=0x2d48530, packet=0x3545e51 "", packet_length=65) 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
#25 0x00000000007de528 in do_command (thd=0x2d48530) 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
#26 0x00000000007a64e5 in do_handle_one_connection (thd_arg=0x2d48530) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_connect.cc:1532
#27 0x00000000007a5fed in handle_one_connection (arg=0x2d48530) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_connect.cc:1443
#28 0x0000000000dc5bac in pfs_spawn_thread (arg=0x34b9070) 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
#29 0x00007fcd9e7c8df3 in start_thread () from /lib64/libpthread.so.0
#30 0x00007fcd9d49201d in clone () from /lib64/libc.so.6

** Crashing query

 SELECT (SELECT t1.a) aa, COUNT(DISTINCT b) FROM t1 GROUP BY aa+0

tags: added: qa
Ramesh Sivaraman (rameshvs02) wrote :

Core, GDB, error log etc

There was no master (single threaded, single mysqld run)

Ramesh Sivaraman (rameshvs02) wrote :

s/There was no master (single threaded, single mysqld run)/Single threaded run, single mysqld involved/

description: updated
Ramesh Sivaraman (rameshvs02) wrote :

This is an upstream bug : http://bugs.mysql.com/bug.php?id=74619

****** Testcase

DROP DATABASE test;CREATE DATABASE test;USE test;
CREATE TABLE t1(a DECIMAL(0,0));
ALTER TABLE t1 ADD b INT,ADD c TIME(6);
ALTER TABLE t1 MODIFY a DATETIME(5);
INSERT INTO t1 SET a=0;
SET sql_mode='NO_ZERO_DATE';
SELECT(SELECT t1.a)aa,COUNT(DISTINCT b) FROM t1 GROUP BY aa+0;

tags: added: upstream

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-837

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.