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

handle_fatal_signal (sig=11) in subselect_hash_sj_engine::cleanup

Series 5.6
Bug #1622992

Bug #1622992 reported by Roel Van de Paar on 2016-09-13

This bug affects 1 person

	Status	Importance	Assigned to	Milestone
MySQL Server	Unknown	Unknown	mysql-bugs #82967
Percona Server moved to https://jira.percona.com/projects/PS	Status tracked in 5.7
5.6	Fix Released	High	Unassigned	Percona Server moved to https://jira.percona.com/projects/PS 5.6.37-82.2
5.7	Invalid	Undecided	Unassigned

Bug Description

Core was generated by `/sda/PS130916-percona-server-5.6.31-77.0-linux-x86_64-debug/bin/mysqld --no-def'.
Program terminated with signal 11, Segmentation fault.
#0 0x00007f6655fb2741 in __pthread_kill (threadid=<optimized out>, signo=11) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
61 val = INTERNAL_SYSCALL (tgkill, err, 3, THREAD_GETMEM (THREAD_SELF, pid),
(gdb) bt
+bt
#0 0x00007f6655fb2741 in __pthread_kill (threadid=<optimized out>, signo=11) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
#1 0x0000000000ac0ea2 in my_write_core (sig=11) at /sda/compression3_dbg/mysys/stacktrace.c:422
#2 0x00000000007360ff in handle_fatal_signal (sig=11) at /sda/compression3_dbg/sql/signal_handler.cc:236
#3 <signal handler called>
#4 0x000000000095cf75 in subselect_hash_sj_engine::cleanup (this=0x7f6606d7aed8) at /sda/compression3_dbg/sql/item_subselect.cc:3726
#5 0x00000000009532f5 in Item_in_subselect::finalize_materialization_transform (this=0x7f6606d75010, join=0x7f6606d75f50) at /sda/compression3_dbg/sql/item_subselect.cc:298
#6 0x00000000009e1a9e in JOIN::decide_subquery_strategy (this=0x7f6606d75f50) at /sda/compression3_dbg/sql/sql_optimizer.cc:9593
#7 0x00000000009d3354 in make_join_statistics (join=0x7f6606d75f50, tables_arg=0x7f6606c20810, conds=0x0, keyuse_array=0x7f6606d76178, first_optimization=true) at /sda/compression3_dbg/sql/sql_optimizer.cc:3794
#8 0x00000000009ca429 in JOIN::optimize (this=0x7f6606d75f50) at /sda/compression3_dbg/sql/sql_optimizer.cc:384
#9 0x000000000095aed7 in subselect_single_select_engine::exec (this=0x7f6606c20f08) at /sda/compression3_dbg/sql/item_subselect.cc:2772
#10 0x00000000009542e9 in Item_subselect::exec (this=0x7f6606d75010) at /sda/compression3_dbg/sql/item_subselect.cc:643
#11 0x00000000009547ca in Item_in_subselect::exec (this=0x7f6606d75010) at /sda/compression3_dbg/sql/item_subselect.cc:768
#12 0x0000000000956516 in Item_in_subselect::val_bool (this=0x7f6606d75010) at /sda/compression3_dbg/sql/item_subselect.cc:1401
#13 0x000000000065677d in Item::val_bool_result (this=0x7f6606d75010) at /sda/compression3_dbg/sql/item.h:1203
#14 0x0000000000686812 in Item_in_optimizer::val_int (this=0x7f6606d76878) at /sda/compression3_dbg/sql/item_cmpfunc.cc:2099
#15 0x00000000007baa02 in evaluate_join_record (join=0x7f6606d75158, join_tab=0x7f6606d7b018) at /sda/compression3_dbg/sql/sql_executor.cc:1464
#16 0x00000000007ba427 in sub_select (join=0x7f6606d75158, join_tab=0x7f6606d7b018, end_of_records=false) at /sda/compression3_dbg/sql/sql_executor.cc:1279
#17 0x00000000007b9d0a in do_select (join=0x7f6606d75158) at /sda/compression3_dbg/sql/sql_executor.cc:936
#18 0x00000000007b7ca9 in JOIN::exec (this=0x7f6606d75158) at /sda/compression3_dbg/sql/sql_executor.cc:194
#19 0x000000000081b4ff in mysql_execute_select (thd=0x7f662bb4a000, select_lex=0x7f662bb4c8d8, free_join=true) at /sda/compression3_dbg/sql/sql_select.cc:1101
#20 0x000000000081b7f1 in mysql_select (thd=0x7f662bb4a000, tables=0x7f6606c1f268, wild_num=1, fields=..., conds=0x7f6606d75010, order=0x7f662bb4caa0, group=0x7f662bb4c9d8, having=0x0, select_options=2147748608, result=0x7f6606c20fe0, unit=0x7f662bb4c290, select_lex=0x7f662bb4c8d8) at /sda/compression3_dbg/sql/sql_select.cc:1222
#21 0x00000000008198ea in handle_select (thd=0x7f662bb4a000, result=0x7f6606c20fe0, setup_tables_done_option=0) at /sda/compression3_dbg/sql/sql_select.cc:110
#22 0x00000000007f1dea in execute_sqlcom_select (thd=0x7f662bb4a000, all_tables=0x7f6606c1f268) at /sda/compression3_dbg/sql/sql_parse.cc:5717
#23 0x00000000007ea118 in mysql_execute_command (thd=0x7f662bb4a000) at /sda/compression3_dbg/sql/sql_parse.cc:3016
#24 0x00000000007f4ab1 in mysql_parse (thd=0x7f662bb4a000, rawbuf=0x7f6606c1f010 "SELECT * FROM t1 WHERE(a,b)=ANY (SELECT a,max(b) FROM t1 GROUP BY a)", length=68, parser_state=0x7f665659f500) at /sda/compression3_dbg/sql/sql_parse.cc:7002
#25 0x00000000007e6768 in dispatch_command (command=COM_QUERY, thd=0x7f662bb4a000, packet=0x7f6625fd8001 "", packet_length=68) at /sda/compression3_dbg/sql/sql_parse.cc:1450
#26 0x00000000007e5609 in do_command (thd=0x7f662bb4a000) at /sda/compression3_dbg/sql/sql_parse.cc:1058
#27 0x00000000007acbad in do_handle_one_connection (thd_arg=0x7f662bb4a000) at /sda/compression3_dbg/sql/sql_connect.cc:1541
#28 0x00000000007ac62d in handle_one_connection (arg=0x7f662bb4a000) at /sda/compression3_dbg/sql/sql_connect.cc:1444
#29 0x0000000000e1ef49 in pfs_spawn_thread (arg=0x7f663bbff240) at /sda/compression3_dbg/storage/perfschema/pfs.cc:1860
#30 0x00007f6655faddc5 in start_thread (arg=0x7f66565a0700) at pthread_create.c:308
#31 0x00007f665440aced in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113

DROP DATABASE test;CREATE DATABASE test;USE test;
CREATE TABLE t1(a CHAR (255),b varchar(255) character set utf8,c varchar(255) character set utf8,d varchar(255) character set utf8,e varchar(255) character set utf8,f varchar(4) character set utf8,KEY (a),KEY (b,c,d,e,f)) ENGINE=innodb;
SET @@big_tables=TRUE;
INSERT INTO t1(a,b)VALUES ('1001 MySQL Tricks','1. Never run mysqld as root. 2. q ...'),('MySQL vs. YourSQL use','In the following database comparison ...'),('MySQL Security','When run configured properly,MySQL ...');
SELECT * FROM t1 WHERE(a,b)=ANY (SELECT a,max(b) FROM t1 GROUP BY a);

Seems to appear only in column compression build. May as yet prove upstream or generic PS issue.

Tags:

Roel Van de Paar (roel11) on 2016-09-13

tags:

added: column-compression qa