[MDEV-10784] Server crashes in Time_and_counter_tracker::incr_loops / subselect_single_select_engine::exec Created: 2016-09-09  Updated: 2016-09-21  Resolved: 2016-09-21

Status: Closed
Project: MariaDB Server
Component/s: Optimizer
Affects Version/s: 10.2
Fix Version/s: 10.2.2

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: regression-10.2


 Description   

Stack trace from 10.2 1168e2fa54d2b7

#3  <signal handler called>
#4  0x00007f37ead64668 in Time_and_counter_tracker::incr_loops (this=0x80) at /data/src/10.2/sql/sql_analyze_stmt.h:97
#5  0x00007f37ead2a6f3 in JOIN::exec (this=0x7f37df9252a8) at /data/src/10.2/sql/sql_select.cc:3163
#6  0x00007f37eaff3931 in subselect_single_select_engine::exec (this=0x7f37df868400) at /data/src/10.2/sql/item_subselect.cc:3788
#7  0x00007f37eafe9d58 in Item_subselect::exec (this=0x7f37df868270) at /data/src/10.2/sql/item_subselect.cc:711
#8  0x00007f37eafec618 in Item_exists_subselect::val_int (this=0x7f37df868270) at /data/src/10.2/sql/item_subselect.cc:1581
#9  0x00007f37eaf6f417 in Arg_comparator::compare_int_signed (this=0x7f37df92aa08) at /data/src/10.2/sql/item_cmpfunc.cc:970
#10 0x00007f37eaf8133c in Arg_comparator::compare (this=0x7f37df92aa08) at /data/src/10.2/sql/item_cmpfunc.h:88
#11 0x00007f37eaf71605 in Item_func_eq::val_int (this=0x7f37df92a948) at /data/src/10.2/sql/item_cmpfunc.cc:1742
#12 0x00007f37eaf7ee96 in Item_equal::add_const (this=0x7f37df924e90, thd=0x7f37df816070, c=0x7f37df8667b0) at /data/src/10.2/sql/item_cmpfunc.cc:6125
#13 0x00007f37eaf7f3bd in Item_equal::update_const (this=0x7f37df924e90, thd=0x7f37df816070) at /data/src/10.2/sql/item_cmpfunc.cc:6383
#14 0x00007f37ead45614 in update_const_equal_items (thd=0x7f37df816070, cond=0x7f37df924e90, tab=0x7f37df929190, const_key=true) at /data/src/10.2/sql/sql_select.cc:13904
#15 0x00007f37ead51062 in join_read_const_table (thd=0x7f37df816070, tab=0x7f37df929190, pos=0x7f37df929760) at /data/src/10.2/sql/sql_select.cc:18819
#16 0x00007f37ead2c95c in make_join_statistics (join=0x7f37df868910, tables_list=..., keyuse_array=0x7f37df868bf0) at /data/src/10.2/sql/sql_select.cc:3875
#17 0x00007f37ead24678 in JOIN::optimize_inner (this=0x7f37df868910) at /data/src/10.2/sql/sql_select.cc:1437
#18 0x00007f37ead23344 in JOIN::optimize (this=0x7f37df868910) at /data/src/10.2/sql/sql_select.cc:1076
#19 0x00007f37ead2b798 in mysql_select (thd=0x7f37df816070, tables=0x7f37df865598, wild_num=1, fields=..., conds=0x7f37df8685b0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f37df8688f0, unit=0x7f37df819b18, select_lex=0x7f37df81a250) at /data/src/10.2/sql/sql_select.cc:3535
#20 0x00007f37ead20ea1 in handle_select (thd=0x7f37df816070, lex=0x7f37df819a50, result=0x7f37df8688f0, setup_tables_done_option=0) at /data/src/10.2/sql/sql_select.cc:373
#21 0x00007f37eacf0938 in execute_sqlcom_select (thd=0x7f37df816070, all_tables=0x7f37df865598) at /data/src/10.2/sql/sql_parse.cc:6345
#22 0x00007f37eace676e in mysql_execute_command (thd=0x7f37df816070) at /data/src/10.2/sql/sql_parse.cc:3376
#23 0x00007f37eacf40d7 in mysql_parse (thd=0x7f37df816070, rawbuf=0x7f37df864088 "SELECT * FROM ( SELECT DISTINCT * FROM t1 ) AS sq\nWHERE i IN ( SELECT j FROM t2 WHERE i IN ( EXISTS ( SELECT j FROM t2 ) ) )", length=124, parser_state=0x7f37ebc42dd0, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7774
#24 0x00007f37eace24c5 in dispatch_command (command=COM_QUERY, thd=0x7f37df816070, packet=0x7f37df858071 "SELECT * FROM ( SELECT DISTINCT * FROM t1 ) AS sq\nWHERE i IN ( SELECT j FROM t2 WHERE i IN ( EXISTS ( SELECT j FROM t2 ) ) )", packet_length=124, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1805
#25 0x00007f37eace0ef6 in do_command (thd=0x7f37df816070) at /data/src/10.2/sql/sql_parse.cc:1365
#26 0x00007f37eae1c7ba in do_handle_one_connection (connect=0x7f37e7c6d410) at /data/src/10.2/sql/sql_connect.cc:1354
#27 0x00007f37eae1c547 in handle_one_connection (arg=0x7f37e7c6d410) at /data/src/10.2/sql/sql_connect.cc:1260
#28 0x00007f37eb12ab26 in pfs_spawn_thread (arg=0x7f37e7c519f0) at /data/src/10.2/storage/perfschema/pfs.cc:1862
#29 0x00007f37ea3650a4 in start_thread (arg=0x7f37ebc44300) at pthread_create.c:309
#30 0x00007f37e851d87d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111

CREATE TABLE t1 (i INT) engine=MyISAM;
INSERT INTO t1 VALUES (2),(5);
CREATE TABLE t2 (j INT) engine=MyISAM;
INSERT INTO t2 VALUES (8);
 
SELECT * FROM ( SELECT DISTINCT * FROM t1 ) AS sq
WHERE i IN ( SELECT j FROM t2 WHERE i IN ( EXISTS ( SELECT j FROM t2 ) ) );

The problem started happening after recent merges, but I can't point at the exact commit which caused it.



 Comments   
Comment by Elena Stepanova [ 2016-09-21 ]

Disappeared from 10.2 after this commit:

commit 3630a00e258273ada7f783a514600aafcd3f13f9
Author: Igor Babaev <igor@askmonty.org>
Date:   Mon Sep 12 00:07:02 2016 -0700
 
    Fixed bug mdev-10782.
    This bug in the code of Item_ref::build_clone could
    cause corruption of items in where conditions.
    Also made sure that equality predicates extracted
    from multiple equality items to be pushed into
    materialized views were cloned.

Generated at Thu Feb 08 07:44:53 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.