Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.5.13
Description
It happens occasionally.
The crash happens during trigger execution on the last select.
The result of the select is NULL
230421 9:27:23 [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.13-MariaDB-log |
key_buffer_size=16777216 |
read_buffer_size=131072 |
max_used_connections=67 |
max_threads=2002 |
thread_count=61 |
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 4423714 K bytes of memory |
Hope that's ok; if not, decrease some variables in the equation. |
|
Thread pointer: 0x7f310815b2f8 |
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 = 0x7f3af0128c90 thread_stack 0x49000 |
/usr/sbin/mariadbd(my_print_stacktrace+0x2e)[0x5629ee889d6e] |
/usr/sbin/mariadbd(handle_fatal_signal+0x307)[0x5629ee28c367] |
/lib64/libpthread.so.0(+0xf630)[0x7f3af6438630] |
/usr/sbin/mariadbd(+0xb747a6)[0x5629ee47d7a6] |
/usr/sbin/mariadbd(+0xb71243)[0x5629ee47a243] |
??:0(_ma_state_info_write)[0x5629ee477c26] |
??:0(_ma_state_info_write)[0x5629ee291c88] |
??:0(_ma_state_info_write)[0x5629ee0c3f97] |
??:0(handler::ha_index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function))[0x5629ee0b7aca] |
??:0(cp_buffer_from_ref(THD*, TABLE*, st_table_ref*))[0x5629ee0e7002] |
??:0(sub_select(JOIN*, st_join_table*, bool))[0x5629ee0e73e3] |
??:0(JOIN::exec_inner())[0x5629ee12f84c] |
??:0(JOIN::exec())[0x5629ee0420ea] |
??:0(st_select_lex_unit::exec())[0x5629ee041b5d] |
??:0(TABLE_LIST::fill_recursive(THD*))[0x5629ee0b77c9] |
??:0(mysql_handle_single_derived(LEX*, TABLE_LIST*, unsigned int))[0x5629ee0b7a98] |
??:0(st_join_table::preread_init())[0x5629ee0e7002] |
??:0(JOIN::exec_inner())[0x5629ee0e73e3] |
??:0(JOIN::exec())[0x5629ee0e526e] |
??:0(handle_select(THD*, LEX*, select_result*, unsigned long))[0x5629ee0e5e34] |
/usr/sbin/mariadbd(+0x63b749)[0x5629edf44749] |
??:0(mysql_execute_command(THD*))[0x5629ee08987d] |
??:0(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x5629edfdc696] |
??:0(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x5629edfe542e] |
??:0(sp_instr_stmt::execute(THD*, unsigned int*))[0x5629edfe5f3c] |
??:0(sp_head::execute(THD*, bool))[0x5629edfe06e2] |
??:0(sp_head::execute_trigger(THD*, st_mysql_const_lex_string const*, st_mysql_const_lex_string const*, st_grant_info*))[0x5629edfe1636] |
??:0(Table_triggers_list::process_triggers(THD*, trg_event_type, trg_action_time_type, bool))[0x5629ee127ea5] |
??:0(fill_record_n_invoke_before_triggers(THD*, TABLE*, List<Item>&, List<Item>&, bool, trg_event_type))[0x5629ee01d5ad] |
??:0(mysql_insert(THD*, TABLE_LIST*, List<Item>&, List<List<Item> >&, List<Item>&, List<Item>&, enum_duplicates, bool, select_result*))[0x5629ee053564] |
??:0(mysql_execute_command(THD*))[0x5629ee08975e] |
??:0(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x5629ee08bd15] |
??:0(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x5629ee08e5e5] |
??:0(do_command(THD*))[0x5629ee08fd7f] |
??:0(do_handle_one_connection(CONNECT*, bool))[0x5629ee17c689] |
??:0(handle_one_connection)[0x5629ee17c934] |
??:0(MyCTX_nopad::finish(unsigned char*, unsigned int*))[0x5629ee4db91d] |
/lib64/libpthread.so.0(+0x7ea5)[0x7f3af6430ea5] |
/lib64/libc.so.6(clone+0x6d)[0x7f3af594b96d] |
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x7f310818dd80): SELECT MIN(removeDate) INTO v_removeDate FROM ( |
SELECT lockedDate AS removeDate FROM rsi_zalock rz WHERE voucherSerialNum = NEW.voucherSerialNum
|
UNION ALL
|
SELECT transactionDate AS removeDate FROM rsi_zasal_input WHERE voucherSerialNum = NEW.voucherSerialNum AND transactionType IN (0,99) |
UNION ALL
|
SELECT purchaseDate AS removeDate FROM rsi_zapur_pks rzp WHERE referenceId = NEW.referenceId AND transactionType = 61 |
) rfs
|
|