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.