Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-10784

Server crashes in Time_and_counter_tracker::incr_loops / subselect_single_select_engine::exec

    XMLWordPrintable

    Details

      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.

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.