Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.5.9, 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5
Description
When the stored procedure that does nothing but passing few parameters to complex SELECT with several CTEs is called for the second time:
MariaDB [(none)]> CALL db.P_NAME4('ALL','ALL','something','20210427','20210428','ALL');
|
...
|
4 rows in set (3.102 sec)
|
|
Query OK, 0 rows affected (3.102 sec)
|
|
MariaDB [(none)]> CALL db.P_NAME4(NULL,NULL,NULL,NULL,NULL,NULL);
|
ERROR 2013 (HY000): Lost connection to MySQL server during query
|
it crashes, with the following stack trace:
|
210429 14:37:00 [ERROR] mysqld got signal 11 ;
|
This could be because you hit a bug. It is also possible that this binary
|
or one of the libraries it was linked against is corrupt, improperly built,
|
or misconfigured. This error can also be caused by malfunctioning hardware.
|
|
To report this bug, see https://mariadb.com/kb/en/reporting-bugs
|
|
We will try our best to scrape up some info that will hopefully help
|
diagnose the problem, but since we have already crashed,
|
something is definitely wrong and this may fail.
|
|
Server version: 10.5.9-6-MariaDB-enterprise-log
|
key_buffer_size=1073741824
|
read_buffer_size=2097152
|
max_used_connections=84
|
max_threads=65537
|
thread_count=101
|
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 940638017 K bytes of memory
|
Hope that's ok; if not, decrease some variables in the equation.
|
|
Thread pointer: 0x7ef374005508
|
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 = 0x7f069a4dabf8 thread_stack 0x49000
|
??:0(my_print_stacktrace)[0x55d75f1c8c0e]
|
??:0(handle_fatal_signal)[0x55d75eba0207]
|
sigaction.c:0(__restore_rt)[0x7f4725938630]
|
??:0(find_field_in_tables(THD*, Item_ident*, TABLE_LIST*, TABLE_LIST*, Item**, find_item_error_report_type, bool, bool))[0x55d75e9377c2]
|
??:0(Item_cond::add_key_fields(JOIN*, KEY_FIELD**, unsigned int*, unsigned long long, SARGABLE_PARAM**))[0x55d75e9c3cc1]
|
??:0(setup_order(THD*, Bounds_checked_array<Item*>, TABLE_LIST*, List<Item>&, List<Item>&, st_order*, bool))[0x55d75e9d864e]
|
??:0(setup_windows(THD*, Bounds_checked_array<Item*>, TABLE_LIST*, List<Item>&, List<Item>&, List<Window_spec>&, List<Item_window_func>&))[0x55d75eb067c5]
|
??:0(JOIN::prepare(TABLE_LIST*, Item*, unsigned int, st_order*, bool, st_order*, Item*, st_order*, st_select_lex*, st_select_lex_unit*))[0x55d75e9e42cf]
|
??:0(st_select_lex_unit::prepare_join(THD*, st_select_lex*, select_result*, unsigned long long, bool))[0x55d75ea40e3d]
|
??:0(st_select_lex_unit::prepare(TABLE_LIST*, select_result*, unsigned long long))[0x55d75ea453e6]
|
??:0(TABLE_LIST::find_derived_handler(THD*))[0x55d75e9584b7]
|
??:0(mysql_handle_single_derived(LEX*, TABLE_LIST*, unsigned int))[0x55d75e9574f4]
|
??:0(st_select_lex::handle_derived(LEX*, unsigned int))[0x55d75e9728e7]
|
??:0(JOIN::prepare(TABLE_LIST*, Item*, unsigned int, st_order*, bool, st_order*, Item*, st_order*, st_select_lex*, st_select_lex_unit*))[0x55d75e9e39e6]
|
??:0(mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x55d75e9f8c9f]
|
??:0(handle_select(THD*, LEX*, select_result*, unsigned long))[0x55d75e9f8ff4]
|
/usr/sbin/mariadbd(+0x634643)[0x55d75e85a643]
|
??:0(mysql_execute_command(THD*))[0x55d75e99c784]
|
??:0(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x55d75e8f36c6]
|
??:0(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x55d75e8fbfca]
|
??:0(sp_instr_stmt::execute(THD*, unsigned int*))[0x55d75e8fca3c]
|
??:0(sp_head::execute(THD*, bool))[0x55d75e8f7698]
|
??:0(sp_head::execute_procedure(THD*, List<Item>*))[0x55d75e8f8c4f]
|
??:0(comp_ne_creator(bool))[0x55d75e98ee7a]
|
??:0(Sql_cmd_call::execute(THD*))[0x55d75e992d5a]
|
??:0(mysql_execute_command(THD*))[0x55d75e99b6a1]
|
??:0(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55d75e99f9ba]
|
??:0(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55d75e9a1af3]
|
??:0(do_command(THD*))[0x55d75e9a366b]
|
??:0(tp_callback(TP_connection*))[0x55d75eb22d2f]
|
??:0(get_event(worker_thread_t*, thread_group_t*, timespec*))[0x55d75ed3dcf0]
|
??:0(MyCTX_nopad::finish(unsigned char*, unsigned int*))[0x55d75ee15c1d]
|
pthread_create.c:0(start_thread)[0x7f4725930ea5]
|
??:0(__clone)[0x7f4723ac98dd]
|
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x7efab000f990): WITH GET_INFO AS
|
(
|
SELECT something <complex query here>
|
|
...
|
|
FROM ALL_DATA_final
|
WHERE ( NAME_CONST('var',NULL) = 'ALL' OR NAME_CONST('var',NULL) <> 'ALL' AND col1 = NAME_CONST('var',NULL))
|
Attachments
Issue Links
- relates to
-
MDEV-13170 Database service (MySQL) stops after update with trigger
- Closed
-
MDEV-25766 Unused CTE lead to a crash in find_field_in_tables/find_order_in_list
- Closed