Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
10.7.7
-
None
-
Windows 64.
NVMe SSD SK Hynix p41.
AMD CPU
Description
Hi.
By observing long term experiences,
as the report subject "Repeated C,U,D(especially INSERT with duplicated update) with ZERO SELECT" makes unexpected crash which very repeated symptom/crash.
Thing is that, usually, by the batch process (doesn't matter internal schduler or external script by connector), any of tables keep repeatly re-newed(delete all & insert by select. or insert with duplicated update).
After repeated update without selection several times(sometime, only dozen of times. sometime, several hundred times within short period time)
it makes crash as below log.
Doesn't matter which kind of table.
(also, seems it drain db internal buffer)
So please look into the error. which is very serious.
(Have no idea it related to SSD. But please resolve the issue some how.)
---------------------------------
server.dll!Item_sum_max::add()[item_sum.cc:2571]
server.dll!Frame_scan_cursor::compute_values_for_current_row()[sql_window.cc:2263]
server.dll!compute_window_func()[sql_window.cc:2901]
server.dll!Window_funcs_sort::exec()[sql_window.cc:3057]
server.dll!Window_funcs_computation::exec()[sql_window.cc:3184]
server.dll!AGGR_OP::end_send()[sql_select.cc:29767]
server.dll!sub_select_postjoin_aggr()[sql_select.cc:21051]
server.dll!do_select()[sql_select.cc:20887]
server.dll!JOIN::exec_inner()[sql_select.cc:4793]
server.dll!mysql_select()[sql_select.cc:5051]
server.dll!mysql_derived_fill()[sql_derived.cc:1294]
server.dll!mysql_handle_single_derived()[sql_derived.cc:200]
server.dll!st_join_table::preread_init()[sql_select.cc:14225]
server.dll!sub_select()[sql_select.cc:21302]
server.dll!do_select()[sql_select.cc:20885]
server.dll!JOIN::exec_inner()[sql_select.cc:4793]
server.dll!mysql_select()[sql_select.cc:5051]
server.dll!mysql_derived_fill()[sql_derived.cc:1294]
server.dll!mysql_handle_single_derived()[sql_derived.cc:200]
server.dll!st_join_table::preread_init()[sql_select.cc:14225]
server.dll!sub_select()[sql_select.cc:21302]
server.dll!evaluate_join_record()[sql_select.cc:21573]
server.dll!sub_select()[sql_select.cc:21342]
server.dll!evaluate_join_record()[sql_select.cc:21573]
server.dll!sub_select()[sql_select.cc:21381]
server.dll!evaluate_join_record()[sql_select.cc:21573]
server.dll!sub_select()[sql_select.cc:21342]
server.dll!do_select()[sql_select.cc:20885]
server.dll!JOIN::exec_inner()[sql_select.cc:4793]
server.dll!JOIN::exec()[sql_select.cc:4572]
server.dll!st_select_lex_unit::exec()[sql_union.cc:2248]
server.dll!mysql_derived_fill()[sql_derived.cc:1307]
server.dll!mysql_handle_single_derived()[sql_derived.cc:200]
server.dll!st_join_table::preread_init()[sql_select.cc:14225]
server.dll!sub_select()[sql_select.cc:21302]
server.dll!do_select()[sql_select.cc:20885]
server.dll!JOIN::exec_inner()[sql_select.cc:4793]
server.dll!mysql_select()[sql_select.cc:5051]
server.dll!mysql_derived_fill()[sql_derived.cc:1294]
server.dll!mysql_handle_single_derived()[sql_derived.cc:200]
server.dll!st_join_table::preread_init()[sql_select.cc:14225]
server.dll!sub_select()[sql_select.cc:21302]
server.dll!do_select()[sql_select.cc:20885]
server.dll!JOIN::exec_inner()[sql_select.cc:4793]
server.dll!mysql_select()[sql_select.cc:5051]
server.dll!handle_select()[sql_select.cc:554]
server.dll!mysql_execute_command()[sql_parse.cc:4716]
server.dll!sp_instr_stmt::exec_core()[sp_head.cc:3801]
server.dll!sp_lex_keeper::reset_lex_and_exec_core()[sp_head.cc:3524]
server.dll!sp_instr_stmt::execute()[sp_head.cc:3705]
server.dll!sp_head::execute()[sp_head.cc:1458]
server.dll!sp_head::execute_procedure()[sp_head.cc:2472]
server.dll!do_execute_sp()[sql_parse.cc:3023]
server.dll!Sql_cmd_call::execute()[sql_parse.cc:3269]
server.dll!mysql_execute_command()[sql_parse.cc:6001]
server.dll!sp_instr_stmt::exec_core()[sp_head.cc:3801]
server.dll!sp_lex_keeper::reset_lex_and_exec_core()[sp_head.cc:3524]
server.dll!sp_instr_stmt::execute()[sp_head.cc:3705]
server.dll!sp_head::execute()[sp_head.cc:1458]
server.dll!sp_head::execute_procedure()[sp_head.cc:2472]
server.dll!do_execute_sp()[sql_parse.cc:3023]
server.dll!Sql_cmd_call::execute()[sql_parse.cc:3269]
server.dll!mysql_execute_command()[sql_parse.cc:6001]
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0x23a2b8605f0): INSERT INTO xxxxxxxxxxxxxxxxxx (skip)
Attachments
Issue Links
- relates to
-
MDEV-24684 Aggregate functions min max over a partition have quadratic complexity
- Confirmed
-
MDEV-30517 On windows 11, difference of innodb_flush_method=O_DIRECT vs. innodb_flush_method=unbuffered
- Closed