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

Server crashes in best_access_path with materialization+semijoin and big_tables=ON

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 5.3.12, 5.5.36, 10.0.9
    • Fix Version/s: 5.5.37, 10.0.10, 5.3.13
    • Component/s: None
    • Labels:
      None

      Description

      SET optimizer_switch = 'materialization=on,semijoin=on';
      SET big_tables = ON;
       
      CREATE TABLE t1 (a INT);
      INSERT INTO t1 VALUES (1),(2);
       
      CREATE TABLE t2 (b INT);
      INSERT INTO t2 VALUES (3),(4);
       
      SELECT * FROM t1 AS t1_1, t1 AS t1_2 
        WHERE ( t1_1.a, t1_2.a ) IN ( SELECT MAX(b), MIN(b) FROM t2 );

      #3  <signal handler called>
      #4  0x0000000000735f36 in best_access_path (join=0x397d768, s=0x39f4bd0, remaining_tables=6, idx=1, disable_jbuf=false, record_count=2, pos=0x39f4ff8, loose_scan_pos=0x7f48972b1da0) at sql_select.cc:5477
      #5  0x0000000000738f1c in best_extension_by_limited_search (join=0x397d768, remaining_tables=6, idx=1, record_count=2, read_time=2.4034179687499999, search_depth=61, prune_level=1) at sql_select.cc:6777
      #6  0x00000000007392b9 in best_extension_by_limited_search (join=0x397d768, remaining_tables=7, idx=0, record_count=1, read_time=0, search_depth=62, prune_level=1) at sql_select.cc:6838
      #7  0x00000000007383ee in greedy_search (join=0x397d768, remaining_tables=7, search_depth=62, prune_level=1) at sql_select.cc:6394
      #8  0x0000000000737a50 in choose_plan (join=0x397d768, join_tables=7) at sql_select.cc:5982
      #9  0x0000000000731443 in make_join_statistics (join=0x397d768, tables_list=..., conds=0x3984878, keyuse_array=0x397da48) at sql_select.cc:3694
      #10 0x000000000072847c in JOIN::optimize (this=0x397d768) at sql_select.cc:1165
      #11 0x000000000072ee2d in mysql_select (thd=0x38c6b88, rref_pointer_array=0x38c9878, tables=0x394ab58, wild_num=1, fields=..., conds=0x397d520, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147764992, result=0x397d748, unit=0x38c9118, select_lex=0x38c9620) at sql_select.cc:2993
      #12 0x0000000000725929 in handle_select (thd=0x38c6b88, lex=0x38c9078, result=0x397d748, setup_tables_done_option=0) at sql_select.cc:288
      #13 0x00000000006b457c in execute_sqlcom_select (thd=0x38c6b88, all_tables=0x394ab58) at sql_parse.cc:5172
      #14 0x00000000006ab718 in mysql_execute_command (thd=0x38c6b88) at sql_parse.cc:2305
      #15 0x00000000006b6ee3 in mysql_parse (thd=0x38c6b88, rawbuf=0x394a8c0 "SELECT * FROM t1 AS t1_1, t1 AS t1_2 WHERE ( t1_1.a, t1_2.a ) IN ( SELECT MAX(b), MIN(b) FROM t2 )", length=98, found_semicolon=0x7f48972b3cb8) at sql_parse.cc:6173
      #16 0x00000000006a8ef8 in dispatch_command (command=COM_QUERY, thd=0x38c6b88, packet=0x3941459 "SELECT * FROM t1 AS t1_1, t1 AS t1_2 WHERE ( t1_1.a, t1_2.a ) IN ( SELECT MAX(b), MIN(b) FROM t2 )", packet_length=98) at sql_parse.cc:1243
      #17 0x00000000006a81e4 in do_command (thd=0x38c6b88) at sql_parse.cc:923
      #18 0x00000000006a5075 in handle_one_connection (arg=0x38c6b88) at sql_connect.cc:1231
      #19 0x00007f48a0aa2b50 in start_thread (arg=<optimized out>) at pthread_create.c:304
      #20 0x00007f489fe45a7d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112

      Stack trace from:

      revision-id: sanja@montyprogram.com-20140307115707-poaet8iwv9d55azm
      date: 2014-03-07 13:57:07 +0200
      build-date: 2014-03-10 21:21:12 +0400
      revno: 3767
      branch-nick: 5.3

      EXPLAIN also crashes.

        Attachments

          Activity

            People

            Assignee:
            psergey Sergei Petrunia
            Reporter:
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: