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