MariaDB 사용 중 서비스가 간혹 꺼집니다.

Question

안녕하세요.간혹가다가 어느 테이블을 조회하게 된다면 서비스가 간혹가다 내려갑니다.도대체 왜 이런지 모르겠습니다.쿼리가 문제여서 잘못 되었다면 쿼리를 수정 할텐데요...에러메세지 입니다.0xc0000005 에러를 찾아봐도 다음과 같은 것은 찾아 볼 수가 없었습니다.도대체 무슨 에러길래... 마리아DB의 서비스가 내려가는 걸까요..도와주시면 감사하겠습니다...ㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡ230808 1:00:09 [ERROR] mysqld got exception 0xc0000005 ;This could be because you hit a bug. It is also possible that this binaryor one of the libraries it was linked against is corrupt, improperly built,or misconfigured. This error can also be caused by malfunctioning hardware.To report this bug, see https://mariadb.com/kb/en/reporting-bugsWe will try our best to scrape up some info that will hopefully helpdiagnose the problem, but since we have already crashed, something is definitely wrong and this may fail.Server version: 10.3.14-MariaDBkey_buffer_size&#61;134217728read_buffer_size&#61;131072max_used_connections&#61;23max_threads&#61;65537thread_count&#61;24It is possible that mysqld could use up to key_buffer_size &#43; (read_buffer_size &#43; sort_buffer_size)*max_threads &#61; 136183 K bytes of memoryHope that's ok; if not, decrease some variables in the equation.Thread pointer: 0x20030864028Attempting backtrace. You can use the following information to find outwhere mysqld died. If you see no messages after this, something wentterribly wrong...mysqld.exe!ha_partition::compare_number_of_records()[ha_partition.cc:8040]mysqld.exe!my_qsort2()[mf_qsort.c:154]mysqld.exe!ha_partition::info()[ha_partition.cc:8314]mysqld.exe!ha_partition::open()[ha_partition.cc:3654]mysqld.exe!handler::ha_open()[handler.cc:2733]mysqld.exe!ha_partition::clone()[ha_partition.cc:3752]mysqld.exe!QUICK_RANGE_SELECT::init_ror_merged_scan()[opt_range.cc:1503]mysqld.exe!QUICK_ROR_INTERSECT_SELECT::init_ror_merged_scan()[opt_range.cc:1608]mysqld.exe!QUICK_ROR_INTERSECT_SELECT::reset()[opt_range.cc:1643]mysqld.exe!join_init_read_record()[sql_select.cc:20317]mysqld.exe!sub_select()[sql_select.cc:19393]mysqld.exe!do_select()[sql_select.cc:18936]mysqld.exe!JOIN::exec_inner()[sql_select.cc:4040]mysqld.exe!JOIN::exec()[sql_select.cc:3835]mysqld.exe!mysql_select()[sql_select.cc:4241]mysqld.exe!handle_select()[sql_select.cc:373]mysqld.exe!execute_sqlcom_select()[sql_parse.cc:6548]mysqld.exe!mysql_execute_command()[sql_parse.cc:3821]mysqld.exe!mysql_parse()[sql_parse.cc:8096]mysqld.exe!dispatch_command()[sql_parse.cc:1859]mysqld.exe!do_command()[sql_parse.cc:1402]mysqld.exe!threadpool_process_request()[threadpool_common.cc:358]mysqld.exe!tp_callback()[threadpool_common.cc:186]ntdll.dll!TpCallbackIndependent()ntdll.dll!RtlInitializeResource()KERNEL32.DLL!BaseThreadInitThunk()ntdll.dll!RtlUserThreadStart()Trying to get some variables.Some pointers may be invalid and cause the dump to abort.Query (0x2003aa86090): select log.name as Name, format(avg(nullif(log.queue, 0)), 2) as Queue, format(avg(nullif(log.queue_max, 0)), 2) as Queue_Max from info_24hour partition(p_info_24hour_20230808) log where Log.Cap_Date &#61; '2023-08-08 00:45:00' group by log.cross_id, log.direction order by queue descConnection ID (thread ID): 376Status: NOT_KILLEDOptimizer switch: index_merge&#61;on,index_merge_union&#61;on,index_merge_sort_union&#61;on,index_merge_intersection&#61;on,index_merge_sort_intersection&#61;off,engine_condition_pushdown&#61;off,index_condition_pushdown&#61;on,derived_merge&#61;on,derived_with_keys&#61;on,firstmatch&#61;on,loosescan&#61;on,materialization&#61;on,in_to_exists&#61;on,semijoin&#61;on,partial_match_rowid_merge&#61;on,partial_match_table_scan&#61;on,subquery_cache&#61;on,mrr&#61;off,mrr_cost_based&#61;off,mrr_sort_keys&#61;off,outer_join_with_cache&#61;on,semijoin_with_cache&#61;on,join_cache_incremental&#61;on,join_cache_hashed&#61;on,join_cache_bka&#61;on,optimize_join_buffer_size&#61;off,table_elimination&#61;on,extended_keys&#61;on,exists_to_in&#61;on,orderby_uses_equalities&#61;on,condition_pushdown_for_derived&#61;on,split_materialized&#61;onThe manual page at http://dev.mysql.com/doc/mysql/en/crashing.html containsinformation that should help you find out what is causing the crash.

캐티 · Accepted Answer

0xc0000005 오류는 윈도우에서 구동하여 난것이나요.어떤 분은 centos 7 에서도 이런 오류가 생겼다고 하는데 버전과 오류 코드를 검색하면 이슈를 알 수 있어요.MariaDB 10.3.10 Changelog - MariaDB Knowledge Base어쩌면 버전을 바꿔야 할 것 같은데 버전을 변경하게 되면 data파일의 구조가 바뀌어서 마이그레이션이 필요하고 이렇게 되면 db를 백업한 다음 모두 옮기거나 ..

roggue2 · Answer

아무래도 설치된 MariaDB가 잘못 설치되었거나 라이브러리가 손상된 것 같아 보입니다.재설치를 해보시는게 맞을 듯 합니다.

밍밍맨 · Answer

확인 감사 드립니다.재설치 후 정상 작동 확인 했어요.아직 더 지켜는 봐야 할것 같습니다.

MariaDB 사용 중 서비스가 간혹 꺼집니다.

3개의 답변

Q&A 목록