MySQL Forums
Forum List  »  General

MySQL Service Exception
Posted by: Sascha Klein
Date: August 31, 2017 08:14AM

Dear all,
during the last two weeks we had to stops of our MySQL service due to an unclear exception. I'm a little bit helpless because I have no idea how to prevent this.
Is there any significant information I can get from the attached logfiles?

***
19:36:01 UTC - mysqld got exception 0xc0000005 ;
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.
Attempting to collect some information that could help diagnose the problem.
As this is a crash and something is definitely wrong, the information
collection process might fail.
key_buffer_size=8388608
read_buffer_size=65536
max_used_connections=273
max_threads=400
thread_count=86
connection_count=86
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 141054 K  bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
Thread pointer: 0x8c6a93e070
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...
7ff78370d880    mysqld.exe!my_hash_sort_bin()
7ff7833955d1    mysqld.exe!_my_hash_init()
7ff7833963d2    mysqld.exe!my_hash_update()
7ff7833958d3    mysqld.exe!my_hash_delete()
7ff782cddbcc    mysqld.exe!?free_query@Query_cache@@IEAAXPEAUQuery_cache_block@@@Z()
7ff782cddb9f    mysqld.exe!?free_old_query@Query_cache@@IEAADXZ()
7ff782cdcf05    mysqld.exe!?allocate_block@Query_cache@@IEAAPEAUQuery_cache_block@@_KD0@Z()
7ff782cdd01a    mysqld.exe!?allocate_data_chain@Query_cache@@IEAADPEAPEAUQuery_cache_block@@KPEAU2@D@Z()
7ff782ce21eb    mysqld.exe!?write_result_data@Query_cache@@IEAADPEAPEAUQuery_cache_block@@KPEAEPEAU2@W4block_type@2@@Z()
7ff782cdd2b9    mysqld.exe!?append_result_data@Query_cache@@IEAADPEAPEAUQuery_cache_block@@KPEAEPEAU2@@Z()
7ff782cdeb53    mysqld.exe!?insert@Query_cache@@QEAAXPEAUQuery_cache_tls@@PEBDKI@Z()
7ff782ce08b5    mysqld.exe!?query_cache_insert@@YAXPEBDKI@Z()
7ff782c24296    mysqld.exe!net_write_packet()
7ff782c23a22    mysqld.exe!?sort_buffer@Filesort_buffer@@QEAAXPEBVSort_param@@I@Z()
7ff782c23fb4    mysqld.exe!my_net_write()
7ff782d8df3c    mysqld.exe!?end_row@Protocol_classic@@UEAA_NXZ()
7ff7831efebb    mysqld.exe!?do_sj_dups_weedout@@YAHPEAVTHD@@PEAVSJ_TMP_TABLE@@@Z()
7ff7831f0e3d    mysqld.exe!?end_write_group@@YA?AW4enum_nested_loop_state@@PEAVJOIN@@PEAVQEP_TAB@@_N@Z()
7ff7831f4967    mysqld.exe!?sub_select@@YA?AW4enum_nested_loop_state@@PEAVJOIN@@PEAVQEP_TAB@@_N@Z()
7ff7831efb31    mysqld.exe!?create_intermediate_table@JOIN@@AEAA_NPEAVQEP_TAB@@PEAV?$List@VItem@@@@AEAVORDER_with_src@1@_N@Z()
7ff7831f14eb    mysqld.exe!?exec@JOIN@@QEAAXXZ()
7ff782e001b1    mysqld.exe!?handle_query@@YA_NPEAVTHD@@PEAULEX@@PEAVQuery_result@@_K3@Z()
7ff782c73f17    mysqld.exe!?execute_init_command@@YAXPEAVTHD@@PEAUst_mysql_lex_string@@PEAUst_mysql_rwlock@@@Z()
7ff782c75e46    mysqld.exe!?mysql_execute_command@@YAHPEAVTHD@@_N@Z()
7ff782c798a3    mysqld.exe!?mysql_parse@@YAXPEAVTHD@@PEAVParser_state@@@Z()
7ff782c72953    mysqld.exe!?dispatch_command@@YA_NPEAVTHD@@PEBTCOM_DATA@@W4enum_server_command@@@Z()
7ff782c7398a    mysqld.exe!?do_command@@YA_NPEAVTHD@@@Z()
7ff782c1a4dc    mysqld.exe!handle_connection()
7ff7836743a2    mysqld.exe!?reserve@?$vector@EV?$allocator@E@std@@@std@@QEAAX_K@Z()
7ff78338743c    mysqld.exe!my_thread_once()
7ffc91b44f7f    MSVCR120.dll!_beginthreadex()
7ffc91b45126    MSVCR120.dll!_endthreadex()
7ffc997613d2    KERNEL32.DLL!BaseThreadInitThunk()
7ffc9a0b54e4    ntdll.dll!RtlUserThreadStart()
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (8c68e2da60): SELECT * FROM mailservice ORDER BY sent asc
Connection ID (thread ID): 7969
Status: NOT_KILLED
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.

***

16:54:56 UTC - mysqld got exception 0xc0000005 ;
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.
Attempting to collect some information that could help diagnose the problem.
As this is a crash and something is definitely wrong, the information
collection process might fail.
key_buffer_size=8388608
read_buffer_size=65536
max_used_connections=265
max_threads=400
thread_count=48
connection_count=48
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 141051 K  bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
Thread pointer: 0xe16e505ab0
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...
7ff6095be856    mysqld.exe!?invalidate_query_block_list@Query_cache@@IEAAXPEAVTHD@@PEAUQuery_cache_block_table@@@Z()
7ff6095beaa9    mysqld.exe!?invalidate_table_internal@Query_cache@@AEAAXPEAVTHD@@PEAE_K@Z()
7ff6095be9cb    mysqld.exe!?invalidate_table@Query_cache@@IEAAXPEAVTHD@@PEAE_K@Z()
7ff6095be980    mysqld.exe!?invalidate_single@Query_cache@@QEAAXPEAVTHD@@PEAUTABLE_LIST@@D@Z()
7ff609af3222    mysqld.exe!?mysql_update@@YA_NPEAVTHD@@AEAV?$List@VItem@@@@1_KW4enum_duplicates@@PEA_K4@Z()
7ff609af47a0    mysqld.exe!?try_single_table_update@Sql_cmd_update@@AEAA_NPEAVTHD@@PEA_N@Z()
7ff609af0aea    mysqld.exe!?execute@Sql_cmd_update@@UEAA_NPEAVTHD@@@Z()
7ff609556bf5    mysqld.exe!?mysql_execute_command@@YAHPEAVTHD@@_N@Z()
7ff6095594f3    mysqld.exe!?mysql_parse@@YAXPEAVTHD@@PEAVParser_state@@@Z()
7ff6095524ed    mysqld.exe!?dispatch_command@@YA_NPEAVTHD@@PEBTCOM_DATA@@W4enum_server_command@@@Z()
7ff6095534fa    mysqld.exe!?do_command@@YA_NPEAVTHD@@@Z()
7ff6095182d4    mysqld.exe!handle_connection()
7ff609f3d422    mysqld.exe!?reserve@?$vector@EV?$allocator@E@std@@@std@@QEAAX_K@Z()
7ff609c5a9ab    mysqld.exe!my_thread_once()
7ff609ffe97f    mysqld.exe!my_wildcmp_mb()
7ff609ffebca    mysqld.exe!my_wildcmp_mb()
7ffc546d13d2    KERNEL32.DLL!BaseThreadInitThunk()
7ffc549954e4    ntdll.dll!RtlUserThreadStart()
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (e15b1f0bf0): UPDATE eingehende_musterauftraege SET schreibschutz_user = "XXX", schreibschutz_zeitstempel = now() WHERE ideingehende_musterauftraege = 53808
Connection ID (thread ID): 12118
Status: NOT_KILLED
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.

Options: ReplyQuote


Subject
Written By
Posted
MySQL Service Exception
August 31, 2017 08:14AM
August 31, 2017 11:42AM
September 01, 2017 12:49AM
September 01, 2017 10:56AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.