Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
None
-
None
Description
mysqld: /home/alice/git/10.3/sql/sql_select.cc:15582: void restore_prev_nj_state(JOIN_TAB*): Assertion `nest->counter > 0' failed.
|
180507 12:24:21 [ERROR] mysqld got signal 6 ;
|
|
Server version: 10.3.7-MariaDB-debug-log
|
Thread pointer: 0x7f8348000b00
|
Attempting backtrace. You can use the following information to find out
|
where mysqld died. If you see no messages after this, something went
|
terribly wrong...
|
stack_bottom = 0x7f83f8140ec0 thread_stack 0x49000
|
mysys/stacktrace.c:269(my_print_stacktrace)[0x56286e741ae1]
|
sql/signal_handler.cc:168(handle_fatal_signal)[0x56286df8af12]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x11390)[0x7f8416a32390]
|
linux/raise.c:54(__GI_raise)[0x7f8415deb428]
|
stdlib/abort.c:91(__GI_abort)[0x7f8415ded02a]
|
assert/assert.c:92(__assert_fail_base)[0x7f8415de3bd7]
|
/lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7f8415de3c82]
|
sql/sql_select.cc:15584(restore_prev_nj_state(st_join_table*))[0x56286dd14e55]
|
sql/sql_select.cc:8708(best_extension_by_limited_search(JOIN*, unsigned long long, unsigned int, double, double, unsigned int, unsigned int, unsigned int))[0x56286dd046d5]
|
sql/sql_select.cc:7832(greedy_search(JOIN*, unsigned long long, unsigned int, unsigned int, unsigned int))[0x56286dd025d0]
|
sql/sql_select.cc:7410(choose_plan(JOIN*, unsigned long long))[0x56286dd01ab8]
|
sql/sql_select.cc:4909(make_join_statistics(JOIN*, List<TABLE_LIST>&, st_dynamic_array*))[0x56286dcfa99f]
|
sql/sql_select.cc:1848(JOIN::optimize_inner())[0x56286dcefac5]
|
sql/sql_select.cc:1431(JOIN::optimize())[0x56286dcee38d]
|
sql/sql_select.cc:4140(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x56286dcf7aaa]
|
sql/sql_select.cc:382(handle_select(THD*, LEX*, select_result*, unsigned long))[0x56286dcea0dd]
|
sql/sql_parse.cc:6539(execute_sqlcom_select(THD*, TABLE_LIST*))[0x56286dcb5310]
|
sql/sql_parse.cc:3768(mysql_execute_command(THD*))[0x56286dcab7a2]
|
sql/sp_head.cc:3600(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x56286dbd9f18]
|
sql/sp_head.cc:3316(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x56286dbd932e]
|
sql/sp_head.cc:3503(sp_instr_stmt::execute(THD*, unsigned int*))[0x56286dbd9acf]
|
sql/sp_head.cc:1354(sp_head::execute(THD*, bool))[0x56286dbd389c]
|
sql/sp_head.cc:2292(sp_head::execute_procedure(THD*, List<Item>*))[0x56286dbd623b]
|
sql/sql_parse.cc:2944(do_execute_sp(THD*, sp_head*))[0x56286dca9167]
|
sql/sql_parse.cc:3186(Sql_cmd_call::execute(THD*))[0x56286dca9ce4]
|
sql/sql_parse.cc:6282(mysql_execute_command(THD*))[0x56286dcb3f98]
|
sql/sql_parse.cc:8001(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x56286dcb8cd5]
|
sql/sql_parse.cc:1848(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x56286dca61f9]
|
sql/sql_parse.cc:1391(do_command(THD*))[0x56286dca4c31]
|
sql/sql_connect.cc:1402(do_handle_one_connection(CONNECT*))[0x56286de075df]
|
sql/sql_connect.cc:1309(handle_one_connection)[0x56286de0735f]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f8416a286ba]
|
x86_64/clone.S:111(clone)[0x7f8415ebd41d]
|
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x7f834807e9b8): SELECT table1.`col_varchar_nokey` AS field1, CONCAT( table2.`col_varchar_nokey`, table2.`col_varchar_nokey` ) AS field2 FROM ( C AS table1 LEFT JOIN ( ( CC AS table2 STRAIGHT_JOIN A AS table3 ON (( table3.`col_varchar_key` > table2.`col_varchar_key` ) AND ( table3.`col_varchar_key` = table2.`col_varchar_nokey` ) ) ) ) ON (table3.`col_varchar_key` >= table2.`col_varchar_key` ) )
|
Connection ID (thread ID): 36
|
Status: NOT_KILLED
|
|
Attachments
Issue Links
- duplicates
-
MDEV-16184 [Draft] Assertion `nest->counter > 0' failed in restore_prev_nj_state
- Open