近期mysql服务经常断掉,求高手帮忙看看是什么原因造成的,附数据库错误日志,十分感谢!
02:12:32 UTC - mysqld got exception 0xc0000005 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
Thread pointer: 0x25926354d80
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...
7ff7fbe95a58 mysqld.exe!Item_splocal::this_item()[item.cc:1740]
7ff7fbe98ad6 mysqld.exe!Item_sp_variable::val_int()[item.cc:1649]
7ff7fbdd06ec mysqld.exe!Arg_comparator::compare_int_signed()[item_cmpfunc.cc:1783]
7ff7fbde12a1 mysqld.exe!Item_func_eq::val_int()[item_cmpfunc.cc:2442]
7ff7fbe97360 mysqld.exe!Item::val_bool()[item.cc:213]
7ff7fbde09ac mysqld.exe!Item_cond_and::val_int()[item_cmpfunc.cc:5754]
7ff7fbe97360 mysqld.exe!Item::val_bool()[item.cc:213]
7ff7fc1a7f70 mysqld.exe!sp_instr_jump_if_not::exec_core()[sp_instr.cc:1145]
7ff7fc1aa539 mysqld.exe!sp_lex_instr::reset_lex_and_exec_core()[sp_instr.cc:407]
7ff7fc1aae05 mysqld.exe!sp_lex_instr::validate_lex_and_execute_core()[sp_instr.cc:730]
7ff7fbf73ef9 mysqld.exe!sp_head::execute()[sp_head.cc:2222]
7ff7fbf75474 mysqld.exe!sp_head::execute_trigger()[sp_head.cc:2491]
7ff7fc194a80 mysqld.exe!Trigger::execute()[trigger.cc:421]
7ff7fc26b15b mysqld.exe!Trigger_chain::execute_triggers()[trigger_chain.cc:143]
7ff7fc143c45 mysqld.exe!Table_trigger_dispatcher::process_triggers()[table_trigger_dispatcher.cc:556]
7ff7fc256dc5 mysqld.exe!write_record()[sql_insert.cc:2167]
7ff7fc2532be mysqld.exe!Sql_cmd_insert_values::execute_inner()[sql_insert.cc:633]
7ff7fc09b0b8 mysqld.exe!Sql_cmd_dml::execute()[sql_select.cc:725]
7ff7fbf97201 mysqld.exe!mysql_execute_command()[sql_parse.cc:4471]
7ff7fbf97dc1 mysqld.exe!mysql_parse()[sql_parse.cc:4967]
7ff7fbf9181b mysqld.exe!dispatch_command()[sql_parse.cc:1788]
7ff7fbf927de mysqld.exe!do_command()[sql_parse.cc:1310]
7ff7fbe05188 mysqld.exe!handle_connection()[connection_handler_per_thread.cc:301]
7ff7fd1beef1 mysqld.exe!pfs_spawn_thread()[pfs.cc:2883]
7ff7fcd9fefc mysqld.exe!win_thread_start()[my_thread.cc:53]
7ffe68666c0c ucrtbase.dll!_recalloc()
7ffe697e54e0 KERNEL32.DLL!BaseThreadInitThunk()
7ffe6b04485b ntdll.dll!RtlUserThreadStart()
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (2592630cea8): INSERT INTO `danzhenji_sync_pc` (`id`, `Time`, `Device_ID`, `Power`, `Run`, `Alarm`, `Alarm_CODE`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `Pattern`, `RecordTime`) VALUES (121913, '2022-10-11 10:12:31', 23, 1, 1, 0, '姝e父杩愯', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '缇婄緮缁?绗?DAT', '2022-10-11 10:12:31')
Connection ID (thread ID): 62
Status: NOT_KILLED