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

[Draft] Assertion `nest->counter > 0' failed in restore_prev_nj_state

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.3
    • None
    • Optimizer
    • None

    Description

      https://api.travis-ci.org/v3/job/378823570/log.txt

      10.3 4a5e23e257e229b548599133dbed5162af9df6d9

      mysqld: /home/travis/src/sql/sql_select.cc:15599: void restore_prev_nj_state(JOIN_TAB*): Assertion `nest->counter > 0' failed.
      180514 20:12:24 [ERROR] mysqld got signal 6 ;
       
      Query (0x7f15c808ace8): SELECT alias1.`col_varchar_10_latin1_key` AS field1, alias1.`pk` AS field2 FROM E AS alias1 LEFT JOIN C AS alias2 LEFT JOIN A AS alias3 ON alias2.`col_varchar_1024_latin1_key` = alias3.`col_varchar_1024_utf8_key` ON alias1.`pk` = alias3.`pk` WHERE alias1.`col_int` > 3 AND alias1.`col_int` <= ( 5 + 0 )  /* QNO 2626 CON_ID 21 */  /* QNO 2695 CON_ID 21 */
      Connection ID (thread ID): 21
      Status: NOT_KILLED
      Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on
      

      #6  0x00007f160ede8bf6 in __assert_fail_base (fmt=0x7f160ef3d058 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x55b1f9abe17e "nest->counter > 0", file=file@entry=0x55b1f9abcc90 "/home/travis/src/sql/sql_select.cc", line=line@entry=15599, function=function@entry=0x55b1f9ac0c40 <restore_prev_nj_state(st_join_table*)::__PRETTY_FUNCTION__> "void restore_prev_nj_state(JOIN_TAB*)") at assert.c:92
      #7  0x00007f160ede8ca2 in __GI___assert_fail (assertion=0x55b1f9abe17e "nest->counter > 0", file=0x55b1f9abcc90 "/home/travis/src/sql/sql_select.cc", line=15599, function=0x55b1f9ac0c40 <restore_prev_nj_state(st_join_table*)::__PRETTY_FUNCTION__> "void restore_prev_nj_state(JOIN_TAB*)") at assert.c:101
      #8  0x000055b1f8fb464c in restore_prev_nj_state (last=0x7f15c8168698) at /home/travis/src/sql/sql_select.cc:15599
      #9  0x000055b1f8fa3d77 in best_extension_by_limited_search (join=0x7f15c808b268, remaining_tables=7, idx=0, record_count=1, read_time=0, search_depth=62, prune_level=1, use_cond_selectivity=1) at /home/travis/src/sql/sql_select.cc:8727
      #10 0x000055b1f8fa1c1c in greedy_search (join=0x7f15c808b268, remaining_tables=7, search_depth=62, prune_level=1, use_cond_selectivity=1) at /home/travis/src/sql/sql_select.cc:7852
      #11 0x000055b1f8fa10f6 in choose_plan (join=0x7f15c808b268, join_tables=7) at /home/travis/src/sql/sql_select.cc:7430
      #12 0x000055b1f8f99e9a in make_join_statistics (join=0x7f15c808b268, tables_list=..., keyuse_array=0x7f15c808b558) at /home/travis/src/sql/sql_select.cc:4929
      #13 0x000055b1f8f8eebe in JOIN::optimize_inner (this=0x7f15c808b268) at /home/travis/src/sql/sql_select.cc:1852
      #14 0x000055b1f8f8d72f in JOIN::optimize (this=0x7f15c808b268) at /home/travis/src/sql/sql_select.cc:1433
      #15 0x000055b1f8f96f73 in mysql_select (thd=0x7f15c800b550, tables=0x7f15c814f5f0, wild_num=0, fields=..., conds=0x7f15c808aeb0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=551903563520, result=0x7f15c808b248, unit=0x7f15c808cf20, select_lex=0x7f15c808d698) at /home/travis/src/sql/sql_select.cc:4157
      #16 0x000055b1f8f892f2 in handle_select (thd=0x7f15c800b550, lex=0x7f15c808ce58, result=0x7f15c808b248, setup_tables_done_option=0) at /home/travis/src/sql/sql_select.cc:382
      #17 0x000055b1f8f53ca9 in execute_sqlcom_select (thd=0x7f15c800b550, all_tables=0x7f15c814f5f0) at /home/travis/src/sql/sql_parse.cc:6545
      #18 0x000055b1f8f4a332 in mysql_execute_command (thd=0x7f15c800b550) at /home/travis/src/sql/sql_parse.cc:3768
      #19 0x000055b1f8e77156 in sp_instr_stmt::exec_core (this=0x7f15c81886c0, thd=0x7f15c800b550, nextp=0x7f15f80b56ac) at /home/travis/src/sql/sp_head.cc:3601
      #20 0x000055b1f8e7654b in sp_lex_keeper::reset_lex_and_exec_core (this=0x7f15c8188710, thd=0x7f15c800b550, nextp=0x7f15f80b56ac, open_tables=false, instr=0x7f15c81886c0) at /home/travis/src/sql/sp_head.cc:3317
      #21 0x000055b1f8e76d09 in sp_instr_stmt::execute (this=0x7f15c81886c0, thd=0x7f15c800b550, nextp=0x7f15f80b56ac) at /home/travis/src/sql/sp_head.cc:3504
      #22 0x000055b1f8e70aa2 in sp_head::execute (this=0x7f15c814dd48, thd=0x7f15c800b550, merge_da_on_success=true) at /home/travis/src/sql/sp_head.cc:1354
      #23 0x000055b1f8e7344f in sp_head::execute_procedure (this=0x7f15c814dd48, thd=0x7f15c800b550, args=0x7f15c8010168) at /home/travis/src/sql/sp_head.cc:2293
      #24 0x000055b1f8f47d0a in do_execute_sp (thd=0x7f15c800b550, sp=0x7f15c814dd48) at /home/travis/src/sql/sql_parse.cc:2944
      #25 0x000055b1f8f4887e in Sql_cmd_call::execute (this=0x7f15c801e420, thd=0x7f15c800b550) at /home/travis/src/sql/sql_parse.cc:3186
      #26 0x000055b1f8f52b97 in mysql_execute_command (thd=0x7f15c800b550) at /home/travis/src/sql/sql_parse.cc:6283
      #27 0x000055b1f8f57958 in mysql_parse (thd=0x7f15c800b550, rawbuf=0x7f15c801e2b8 "CALL stored_proc_25044 /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 2697 CON_ID 21 */", length=87, parser_state=0x7f15f80b75f0, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:8019
      #28 0x000055b1f8f44ddc in dispatch_command (command=COM_QUERY, thd=0x7f15c800b550, packet=0x7f15c8015af1 "CALL stored_proc_25044 /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 2697 CON_ID 21 */ ", packet_length=88, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:1846
      #29 0x000055b1f8f4380d in do_command (thd=0x7f15c800b550) at /home/travis/src/sql/sql_parse.cc:1391
      #30 0x000055b1f90a961f in do_handle_one_connection (connect=0x55b1fd7f8310) at /home/travis/src/sql/sql_connect.cc:1402
      #31 0x000055b1f90a93a3 in handle_one_connection (arg=0x55b1fd7f8310) at /home/travis/src/sql/sql_connect.cc:1308
      #32 0x00007f160f9aa184 in start_thread (arg=0x7f15f80b8700) at pthread_create.c:312
      #33 0x00007f160eeb703d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
      

      experimental 6c40fc679d99de2a34ba7e3b6ac807b84be5942a

      perl /home/travis/rqg/runall-new.pl --duration=350 --threads=6 --seed=1526328716 --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --transformers=ConvertSubqueriesToViews,ConvertTablesToDerived,Count,DisableOptimizations,Distinct,EnableOptimizations,ExecuteAsCTE,ExecuteAsDeleteReturning,ExecuteAsDerived,ExecuteAsExcept,ExecuteAsExecuteImmediate,ExecuteAsInsertSelect,ExecuteAsIntersect,ExecuteAsSelectItem,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView,ExecuteAsWhereSubquery,Having,InlineSubqueries,OrderBy,StraightJoin,ExecuteAsPreparedTwice,ExecuteAsTrigger,ExecuteAsSPTwice,ExecuteAsFunctionTwice --redefine=conf/mariadb/general-workarounds.yy --mysqld=--log_output=FILE --mysqld=--log_bin_trust_function_creators=1 --mysqld=--log-bin --mysqld=--max-statement-time=30 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --views --redefine=conf/mariadb/versioning.yy --basedir=/home/travis/server --grammar=conf/optimizer/range_access.yy --gendata=conf/optimizer/range_access.zz --engine=MyISAM --mysqld=--default-storage-engine=MyISAM --vardir=/home/travis/logs/vardir1_3
      

      Not reproducible so far.

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:

                Git Integration

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