none
SQL Server crashes

    Question

  • Lately I have many SQL Server crashes (service stop). I have analyzed the dmpm and I find this dump.
    Version: 10.50.6529.0  SP3 Standard Edition (64-bit)
     
    This dump file has an exception of interest stored in it.
    The stored exception information can be accessed via .ecxr.
    (c728.5cbc): Access violation - code c0000005 (first/second chance not available)
    ntdll!ZwWaitForSingleObject+0xa:
    00000000`77a2d9fa c3              ret
    0:000> lmvm sqlservr
    Browse full module list
    start             end                 module name
    00000000`000e0000 00000000`03d00000   sqlservr   (deferred)             
        Image path: D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Binn\sqlservr.exe
        Image name: sqlservr.exe
        Browse all global symbols  functions  data
        Timestamp:        Thu Mar 19 23:41:39 2015 (550B50A3)
        CheckSum:         03B73CDA
        ImageSize:        03C20000
        File version:     2009.100.6529.0
        Product version:  10.50.6529.0
        File flags:       0 (Mask 3F)
        File OS:          40000 NT Base
        File type:        1.0 App
        File date:        00000000.00000000
        Translations:     0000.04b0 0000.04e4 0409.04b0 0409.04e4
    0:000> .ecxr
    rax=00000000f0e0d0c0 rbx=000006ad3714fb40 rcx=000000ffffffffff
    rdx=0000000000000000 rsi=0000000000000000 rdi=0000000000000000
    rip=0000000077a30e91 rsp=000000006ea5c830 rbp=000000002048fd90
     r8=000000002048fd80  r9=0000000000000000 r10=0000000884880410
    r11=31006e7d0006000b r12=0000000004170000 r13=0000000000000000
    r14=000000006ea5dc00 r15=0000000000000000
    iopl=0         nv up ei pl nz na pe nc
    cs=0033  ss=002b  ds=002b  es=002b  fs=0053  gs=002b             efl=00010202
    ntdll!RtlFreeHeap+0x1a5:
    00000000`77a30e91 488b7b08        mov     rdi,qword ptr [rbx+8] ds:000006ad`3714fb48=????????????????
    0:000> kC  1000
     # Call Site
    00 ntdll!RtlFreeHeap
    01 rpcrt4!LRPC_BINDING_HANDLE::`scalar deleting destructor'
    02 rpcrt4!LRPC_CCALL::`vector deleting destructor'
    03 rpcrt4!LRPC_CCALL::FreeBuffer
    04 rpcrt4!Ndr64pClientFinally
    05 rpcrt4!NdrpClientCall3
    06 rpcrt4!NdrClientCall3
    07 sechost!LsaLookupClose
    08 sechost!LookupAccountSidInternal
    09 sechost!LookupAccountSidLocalW
    *** WARNING: Unable to verify timestamp for sqlservr.exe
    0a advapi32!LookupAccountSidW
    0b sqlservr!FInterrogateLogin
    0c sqlservr!FindLogin
    0d sqlservr!login
    0e sqlservr!process_login
    0f sqlservr!process_commands
    10 sqlservr!SOS_Task::Param::Execute
    11 sqlservr!SOS_Scheduler::RunTask
    12 sqlservr!SOS_Scheduler::ProcessTasks
    13 sqlservr!SchedulerManager::WorkerEntryPoint
    14 sqlservr!SystemThread::RunWorker
    15 sqlservr!SystemThreadDispatcher::ProcessWorker
    *** WARNING: Unable to verify timestamp for msvcr80.dll
    16 sqlservr!SchedulerManager::ThreadEntryPoint
    17 msvcr80!_callthreadstartex
    18 0x0
    19 0x0
    1a 0x0
    Saturday, April 29, 2017 6:45 PM

Answers

All replies

  • More Data:

    0:000> ~*kL 20

    .  0  Id: 930.7f44 Suspend: 0 Teb: 000007ff`ffe98000 Unfrozen
     # Child-SP          RetAddr           Call Site
    00 00000000`77047bd8 000007fe`fd4510dc ntdll!ZwWaitForSingleObject+0xa
    01 00000000`77047be0 00000000`02de0929 KERNELBASE!WaitForSingleObjectEx+0x79
    02 00000000`77047c80 00000000`02de02eb sqlservr!CDmpDump::DumpInternal+0x4d9
    03 00000000`77047d80 00000000`02313ed8 sqlservr!CDmpDump::Dump+0x3b
    04 00000000`77047dd0 00000000`02314a34 sqlservr!SQLDumperLibraryInvoke+0x1a0
    05 00000000`77047e00 00000000`02305f3d sqlservr!CImageHelper::DoMiniDump+0x3d4
    06 00000000`77048000 00000000`02305708 sqlservr!ContextDumpNoStackOverflow+0x449
    07 00000000`77048870 00000000`02304d46 sqlservr!ContextDump+0x7f8
    08 00000000`770491e0 00000000`0274a298 sqlservr!stackTraceExceptionFilter+0x24a
    09 00000000`77049230 00000000`00d70445 sqlservr!SOS_OS::ExecuteDumpExceptionHandlerRoutine+0x28
    0a 00000000`770494c0 00000000`7395b5c6 sqlservr!CallProtectorImpl::CallWithSEH<IWrapInterface<IRowset>::CallTraitsFpuPre,long,MethodCallBinder_5<long,IRowset,long (__cdecl IRowset::*)(unsigned __int64,__int64,__int64,unsigned __int64 * __ptr64,unsigned __int64 * __ptr64 * __ptr64) __ptr64,unsigned __int64,__int64,__int64,unsigned __int64 * __ptr64,unsigned __int64 * __ptr64 * __ptr64> const >+0x8a
    0b 00000000`77049500 00000000`77049840 msvcr80!__C_specific_handler+0x96
    0c 00000000`77049508 00000000`00000001 0x77049840
    0d 00000000`77049510 00000000`800c3390 0x1
    0e 00000000`77049518 00000000`00000000 0x800c3390



    • Edited by SysAdm.MAC Saturday, April 29, 2017 7:50 PM
    Saturday, April 29, 2017 7:48 PM
  • Only Microsoft Support can analyze such dump file, so raise a Support case.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Proposed as answer by Naomi NModerator Sunday, April 30, 2017 4:07 AM
    • Marked as answer by SysAdm.MAC Sunday, April 30, 2017 6:09 PM
    Sunday, April 30, 2017 4:05 AM