|
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)
|