Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.3
-
None
-
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
- is duplicated by
-
MDEV-16120 [draft] Assertion `nest->counter > 0' failed, sql_select.cc:15582 restore_prev_nj_state(JOIN_TAB*):
- Closed