none
SQL SERVER 2017에서 갑자기 미니 덤프파일이 생성됩니다. RRS feed

  • 질문

  • 안녕하세요 

    미니 덤프파일이 생성되는 이유에 대해서 문의 드립니다.

    SQL SERVER 2017에서 갑자기 미니 덤프파일이 생성됩니다.

    짧게는 몇십초에서 길게는 몇분 사이에 미니 덤프파일이 생성됩니다.

    아래는 미니 덤프파일에 대한 내용입니다.

    봐도 정확한 원인을 확인하기가 너무 어렵네요

    무엇이 문제일까요???

    0:000> !analyze -v
    *******************************************************************************
    *                                                                             *
    *                        Exception Analysis                                   *
    *                                                                             *
    *******************************************************************************
    
    
    KEY_VALUES_STRING: 1
    
        Key  : Analysis.CPU.mSec
        Value: 5155
    
        Key  : Analysis.DebugAnalysisProvider.CPP
        Value: Create: 8007007e on SJCOM
    
        Key  : Analysis.DebugData
        Value: CreateObject
    
        Key  : Analysis.DebugModel
        Value: CreateObject
    
        Key  : Analysis.Elapsed.mSec
        Value: 6799
    
        Key  : Analysis.Memory.CommitPeak.Mb
        Value: 298
    
        Key  : Analysis.System
        Value: CreateObject
    
        Key  : CLR.BuiltBy
        Value: NET472REL1LAST_C
    
        Key  : CLR.Engine
        Value: CLR
    
        Key  : CLR.Version
        Value: 4.7.3661.0
    
        Key  : Timeline.OS.Boot.DeltaSec
        Value: 1440
    
        Key  : Timeline.Process.Start.DeltaSec
        Value: 1241
    
        Key  : WER.Process.Version
        Value: 12.0.6828.0
    
    
    ADDITIONAL_XML: 1
    
    OS_BUILD_LAYERS: 1
    
    COMMENT:  Stack Trace
    
    NTGLOBALFLAG:  0
    
    PROCESS_BAM_CURRENT_THROTTLED: 0
    
    PROCESS_BAM_PREVIOUS_THROTTLED: 0
    
    CONTEXT:  (.ecxr)
    rax=0000000000000000 rbx=0000000080004005 rcx=000000f0883dcae0
    rdx=000000f0883dc700 rsi=0000000000040440 rdi=00007ff679e62ca0
    rip=00007ffaed329689 rsp=000000f0883dd0f0 rbp=000000006b262e5b
     r8=00007ffaed3136e5  r9=000000f000000090 r10=000000f0883dc370
    r11=00000000883d0000 r12=00007ffad509e268 r13=000000006b262e5b
    r14=0000000000003534 r15=00007ff679e62ca0
    iopl=0         nv up ei pl nz na pe nc
    cs=0033  ss=002b  ds=002b  es=002b  fs=0053  gs=002b             efl=00000202
    KERNELBASE!RaiseException+0x69:
    00007ffa`ed329689 0f1f440000      nop     dword ptr [rax+rax]
    Resetting default scope
    
    EXCEPTION_RECORD:  (.exr -1)
    ExceptionAddress: 00007ffad34998ad (sqllang!SQLDumperLibraryInvoke+0x00000000000001cd)
       ExceptionCode: 000042ac
      ExceptionFlags: 00000000
    NumberParameters: 0
    
    PROCESS_NAME:  sqlservr.exe
    
    ERROR_CODE: (NTSTATUS) 0x42ac - <Unable to get error code text>
    
    EXCEPTION_CODE_STR:  42ac
    
    MISSING_CLR_SYMBOL: 0
    
    STACK_TEXT:  
    000000f0`883dd0f0 00007ff6`79e0ffac     : 00000000`00010000 00007fff`fffeffff 000000f0`883dd244 00007ffa`e0653c10 : KERNELBASE!RaiseException+0x69
    000000f0`883dd1d0 00007ffa`d34998ad     : 00007ff6`79e62ca0 00007ff6`79e10ae1 000000f0`883cc000 00007ffa`f0e59880 : sqlservr!CDmpDump::Dump+0x4c
    000000f0`883dd210 00007ffa`d416d481     : 00007ff6`79e62ca0 00000000`00040440 00000000`00000000 00007ff6`79e62b38 : sqllang!SQLDumperLibraryInvoke+0x1cd
    000000f0`883dd250 00007ffa`d416df34     : 00000000`00025160 0000024b`cd953330 00000000`00000000 00000000`00000000 : sqllang!SQLLangDumperLibraryInvoke+0x171
    000000f0`883dd310 00007ffa`d413760e     : 000000f0`883feed0 0000024b`cd953330 000000f0`883feed0 0000024b`cd953330 : sqllang!CImageHelper::DoMiniDump+0x4a5
    000000f0`883dd520 00007ffa`d34999e9     : 00000000`00000000 000000f0`883df000 00000000`000000ff 00000000`0000083f : sqllang!stackTrace+0x99e
    000000f0`883def50 00007ffa`d2cfbe62     : 00000000`00000035 00000000`0000012c 0000024e`5a282160 0000023c`58800450 : sqllang!stackTraceCallBack+0x99
    000000f0`883defa0 00007ffa`d2cbd968     : 0000024e`5a282160 0000024a`00000001 0000024a`ffffffff 0000024e`5a080048 : sqldk!ex_dump_if_requested+0x142
    000000f0`883df240 00007ffa`d2cbd7ca     : 00000000`0000012c 00000000`0000002d 00000000`00000011 00000000`00000035 : sqldk!ex_raise2+0x2de
    000000f0`883df570 00007ffa`d3917ba6     : 0000024a`c1827aa0 00000000`ffff9e9d 0000024a`c181e040 00007ffa`00000035 : sqldk!ex_raise+0xc4
    000000f0`883df5f0 00007ffa`d38cb4ef     : 00000000`00000000 00000000`00767357 00000000`000007b6 00000000`0000bd98 : sqllang!CCompLv2Compressor::WriteRecord+0x86
    000000f0`883df640 00007ffa`d38ce36c     : 0000024a`c181e040 00000000`00000000 000000f0`883df730 000000f0`883df730 : sqllang!CCompFragW::WriteNextLogicalAtLevelTwo+0x4f
    000000f0`883df670 00007ffa`d38ff8e7     : 00000000`00000001 00000000`0076735b 00000000`00000000 0001024b`cd95d800 : sqllang!CCompFragMerge<Level2Batch,CLevel2Decompressor>::Merge+0x1cc
    000000f0`883df700 00007ffa`d38fe769     : 0000024b`cd95d660 0000024e`4a6641f0 0000024a`c1827970 0000024b`00001db3 : sqllang!IFTSMergeIndex<Level2Batch,CLevel2Decompressor>+0x248
    000000f0`883df9c0 00007ffa`d38f8dd3     : 0000024b`cd95d660 0000024a`c1827970 00000000`00000000 00000000`00000000 : sqllang!CFTRangeMergeXactUnit::DoUnitWorkDecompressor<Level2Batch,CLevel2Decompressor>+0x289
    000000f0`883dfa80 00007ffa`d38f34b0     : 000000f0`883fd510 0000024e`00000000 0000024b`cd95d290 00000000`00000000 : sqllang!CFTRangeMergeXactUnit::DoUnitWork+0x53
    000000f0`883dfb30 00007ffa`d38fc7d4     : 0000024e`50c31950 000000f0`883dfcb0 00000000`00000000 00000000`00000000 : sqllang!CFTWIRetryUnit::Go+0x100
    000000f0`883dfbb0 00007ffa`d391eea7     : 0000024e`50c31950 0000024e`50c31950 00000000`00000004 0000024e`4a6641f0 : sqllang!CFTWIMerge::ExecuteImpl+0x845
    000000f0`883fd620 00007ffa`d392e329     : 0000024e`50c66100 0000024e`50c66100 00000000`00000000 00000000`00000005 : sqllang!CFTWICrawl::FireMergeTask+0x377
    000000f0`883fd750 00007ffa`d3920334     : 0000024e`00000000 000000f0`883fd7c8 0000024e`4a6641f0 00007ffa`d502a2d0 : sqllang!CFTWICleanup::ExecuteImpl+0x469
    000000f0`883fdaf0 00007ffa`d392cd24     : 0000024e`50c31f00 0000024e`50c31f00 00000000`00000000 0000024e`50c31d40 : sqllang!CFTWICrawl::Close+0xea4
    000000f0`883fdf80 00007ffa`d393eead     : 00000000`00000101 0000024e`50c31d40 0000024e`50c31f00 000000f0`883fe030 : sqllang!CFTWIBatchComplete::ExecuteImpl+0xb5
    000000f0`883fdfd0 00007ffa`d31a45fa     : 000000f0`883f0018 00000000`00000000 00000000`00000001 00000000`000001e9 : sqllang!IFTSWorkerTask+0x2cd
    000000f0`883fe140 00007ffa`d2ca6fc5     : 0000024e`5a282160 0000024e`5a0270c8 0000024e`5a282160 00007ffa`d2ca2d10 : sqllang!SystemTaskEntryPoint+0x3d2
    000000f0`883fefb0 00007ffa`d2ca62fd     : 0000024e`00000000 0000024e`00000000 0000024e`5a0270c8 00000000`00000000 : sqldk!SOS_Scheduler::SystemTimerEntryPoint+0x134
    000000f0`883ff030 00007ffa`d2ca6a08     : 0000024e`5a0270c8 0000024e`5a027088 0000024e`5a027110 0000024e`00000000 : sqldk!SOS_Task::Param::Execute+0x231
    000000f0`883ff630 00007ffa`d2ca67fd     : 0000024e`5a027858 0000024e`5a220040 0000024e`5a220040 0000024e`5a282160 : sqldk!SOS_Scheduler::RunTask+0xad
    000000f0`883ff6a0 00007ffa`d2ccf938     : 0000024e`5a282160 0000024e`5a282160 0000024e`5a282160 00000000`00000000 : sqldk!SOS_Scheduler::ProcessTasks+0x3cd
    000000f0`883ff790 00007ffa`d2ccfa40     : 0000024e`5a282160 00000000`00000000 00000000`7d32662d 00000000`7d32662d : sqldk!SchedulerManager::WorkerEntryPoint+0x2a1
    000000f0`883ff860 00007ffa`d2ccf1a7     : 0000023c`587ea0c0 000000f0`883ff8f0 0000024e`5a080270 0000024e`5a080250 : sqldk!SystemThread::RunWorker+0x8f
    000000f0`883ff890 00007ffa`d2ccf6f9     : 0000024e`5a080230 00000000`00000000 00000000`00000000 0000024e`5a080170 : sqldk!SystemThreadDispatcher::ProcessWorker+0x2e7
    000000f0`883ff930 00007ffa`efea7974     : 00000000`00000000 00000000`00000000 0000023c`587ea0c0 0000023c`587ea0c0 : sqldk!SchedulerManager::ThreadEntryPoint+0x1d8
    000000f0`883ff9e0 00007ffa`f0e6a271     : 00000000`00000000 00000000`00000000 00000000`00000000 00000000`00000000 : kernel32!BaseThreadInitThunk+0x14
    000000f0`883ffa10 00000000`00000000     : 00000000`00000000 00000000`00000000 00000000`00000000 00000000`00000000 : ntdll!RtlUserThreadStart+0x21
    
    
    SYMBOL_NAME:  sqllang!SQLDumperLibraryInvoke+1cd
    
    MODULE_NAME: sqllang
    
    IMAGE_NAME:  sqllang.dll
    
    STACK_COMMAND:  ~0s ; .ecxr ; kb
    
    FAILURE_BUCKET_ID:  APPLICATION_FAULT_42ac_sqllang.dll!SQLDumperLibraryInvoke
    
    OSPLATFORM_TYPE:  x64
    
    OSNAME:  Windows 8
    
    IMAGE_VERSION:  2017.140.3335.7
    
    FAILURE_ID_HASH:  {ab1e43e2-da46-c388-f696-a374d74f9a5d}
    
    Followup:     MachineOwner
    ---------
    



    2020년 9월 1일 화요일 오전 10:43

모든 응답

  • 안녕하세요

    MSDN 포럼은 덤프 분석을 지윈하지 않습니다. 덤프 분석을 원하신다면 Microsoft 지원센터를 통해 지원 받아보시는 것을 권장해 드립니다.

    MSDN Community Support Ricky

    다른 커뮤니티 멤버에게 도움이 될 수 있게 문제를 해결 한 답변을 '답변으로 표시'를 클릭하시고 그렇지 않은 경우 '답변으로 표시 취소'를 클릭하시기 바랍니다. MSDN 서포트에 대한 의견이나 불만이 있을 경우 MSDNFSF@microsoft.com 으로 연락하시기 바랍니다.


    2020년 9월 2일 수요일 오전 3:16
    중재자