none
windows server 2008 r2下sqlserver添加数据库文件时无响应 RRS feed

  • 常规讨论


  • windows server 2008 r2 enterprise服务器,使用sqlserver2008 企业版(sp3)去attach一个53G的数据库文件时,在定位数据库文件时无响应,都没有到最后的OK步骤;同时,打开数据库文件的文件夹也无响应了。等待约2分钟左右,强制杀掉了进程,重新操作,没有问题。

    因是线上服务器,不能轻易放过任何一个问题,故找了一下event的信息,找到一些错误和error report,分析windbg结果如下,请大虾帮忙分析是什么原因,非常感谢!

    Microsoft (R) Windows Debugger Version 6.12.0002.633 AMD64
    Copyright (c) Microsoft Corporation. All rights reserved.


    Loading Dump File [D:\key\Kernel_0_0_cab_029bfdfe\WERDC4F.tmp.hdmp]
    User Mini Dump File: Only registers, stack and portions of memory are available

    Symbol search path is: SRV*c:\temp*http://msdl.microsoft.com/download/symbols
    Executable search path is: 
    Windows 7 Version 7601 (Service Pack 1) MP (24 procs) Free x64
    Product: Server, suite: Enterprise TerminalServer SingleUserTS
    Machine Name:
    Debug session time: Sat Sep 14 03:41:29.000 2013 (UTC + 8:00)
    System Uptime: 0 days 0:56:44.425
    Process Uptime: 0 days 0:53:53.000
    ................................................................
    ..........................................................
    Loading unloaded module list
    ..
    This dump file has an exception of interest stored in it.
    The stored exception information can be accessed via .ecxr.
    (11e4.1278): Unknown exception - code dfffffff (first/second chance not available)
    ntdll!ZwQueryFullAttributesFile+0xa:
    00000000`7743241a c3              ret
    0:000> !analyze -v
    *******************************************************************************
    *                                                                             *
    *                        Exception Analysis                                   *
    *                                                                             *
    *******************************************************************************

    Unable to load image C:\Windows\assembly\NativeImages_v2.0.50727_64\mscorlib\153b26757235403c4dfd6cb47876ca75\mscorlib.ni.dll, Win32 error 0n2
    *** WARNING: Unable to verify checksum for mscorlib.ni.dll
    Unable to load image C:\Windows\assembly\NativeImages_v2.0.50727_64\Microsoft.Windows.S#\a33c938699e3af689b7913b797433b0f\Microsoft.Windows.ServerManager.ni.dll, Win32 error 0n2
    *** WARNING: Unable to verify checksum for Microsoft.Windows.ServerManager.ni.dll
    GetPageUrlData failed, server returned HTTP status 404
    URL requested: http://watson.microsoft.com/StageOne/mmc_exe/6_1_7600_16385/4a5bc808/unknown/0_0_0_0/bbbbbbb4/dfffffff/00000000.htm?Retriage=1

    FAULTING_IP: 
    +4d4ab0
    00000000`00000000 ??              ???

    EXCEPTION_RECORD:  ffffffffffffffff -- (.exr 0xffffffffffffffff)
    ExceptionAddress: 0000000000000000
       ExceptionCode: dfffffff
      ExceptionFlags: 00000001
    NumberParameters: 0

    BUGCHECK_STR:  dfffffff

    PROCESS_NAME:  mmc.exe

    ERROR_CODE: (NTSTATUS) 0xdfffffff - <Unable to get error code text>

    EXCEPTION_CODE: (NTSTATUS) 0xdfffffff - <Unable to get error code text>

    MOD_LIST: <ANALYSIS/>

    NTGLOBALFLAG:  0

    APPLICATION_VERIFIER_FLAGS:  0

    MANAGED_STACK: !dumpstack -EE
    No export dumpstack found

    DERIVED_WAIT_CHAIN:  

    Dl Eid Cid     WaitType
    -- --- ------- --------------------------
       0   11e4.1278 Unknown                

    WAIT_CHAIN_COMMAND:  ~0s;k;;

    BLOCKING_THREAD:  0000000000001278

    DEFAULT_BUCKET_ID:  APPLICATION_HANG_WRONG_SYMBOLS

    PRIMARY_PROBLEM_CLASS:  APPLICATION_HANG_WRONG_SYMBOLS

    LAST_CONTROL_TRANSFER:  from 000007fefd3e810d to 000000007743241a

    FAULTING_THREAD:  0000000000000000

    STACK_TEXT:  
    00000000`2035e618 000007fe`fd3e810d : 00000000`0558eff0 00000000`0594da00 00000000`2035e688 000007fe`fa4d55e0 : ntdll!ZwQueryFullAttributesFile+0xa
    00000000`2035e620 000007fe`fa01cc57 : 00000000`0594bb28 00000000`00000000 00000000`00000050 00000000`2035ea08 : KERNELBASE!GetFileAttributesExW+0x9d
    00000000`2035e6f0 000007fe`f805d098 : 00000000`056fa290 000007fe`f7d696d0 00000000`0594d670 00000000`00000000 : mscorwks!DoNDirectCall__PatchGetThreadCall+0x7b
    00000000`2035e790 000007fe`f805cd7c : 00000000`001a6c70 00000000`2035ea60 00000000`00000001 00000000`0594bb28 : mscorlib_ni+0x36d098
    00000000`2035e910 000007fe`f80059a8 : 00000000`0594bb28 00000000`2035ea60 00000000`00000005 00000000`0594b501 : mscorlib_ni+0x36cd7c
    00000000`2035ea40 000007fe`efa2bed1 : 00000000`00000010 000007fe`f7fdbae0 00000000`00000000 00000000`056f9e10 : mscorlib_ni+0x3159a8
    00000000`2035eaa0 000007fe`ef9e2804 : 00000000`0004f900 00000000`00000000 00000000`2035eb40 00000000`0562c200 : Microsoft_Windows_ServerManager_ni+0x90bed1
    00000000`2035eb50 000007fe`ef9e23ab : 00000000`05e0de30 00000000`0562c198 00000000`05e0df90 000007fe`f80230ce : Microsoft_Windows_ServerManager_ni+0x8c2804
    00000000`2035eb90 000007fe`ef9ba70c : 00000000`058a7b08 00000000`00000000 00000000`00000000 00000000`05e0d3c8 : Microsoft_Windows_ServerManager_ni+0x8c23ab
    00000000`2035ec80 000007fe`ef9b9ce1 : 000007fe`00000010 88d07f13`559ed4ef 00000000`00000000 00000000`056afe80 : Microsoft_Windows_ServerManager_ni+0x89a70c
    00000000`2035ecd0 000007fe`f7fe2bbb : 00000000`0562c198 000007fe`fa3cf565 00000000`2035ee60 00000000`001a6c70 : Microsoft_Windows_ServerManager_ni+0x899ce1
    00000000`2035ee20 000007fe`f80575d1 : 00000000`2035ecf8 000007fe`f9f0b7a3 00000000`00000001 00000000`00000000 : mscorlib_ni+0x2f2bbb
    00000000`2035ee70 000007fe`f805740f : 00000000`00000000 00000000`2035f048 00000000`0000000a 00000000`2035ef28 : mscorlib_ni+0x3675d1
    00000000`2035eec0 000007fe`fa01d432 : 00000000`00000000 000007fe`f9f0b656 00000000`2035f098 00000000`00000000 : mscorlib_ni+0x36740f
    00000000`2035ef10 000007fe`f9f0b7a3 : 00000000`2035efa0 000007ff`0001a119 00000000`00000000 00000000`00000000 : mscorwks!CallDescrWorker+0x82
    00000000`2035ef60 000007fe`f9f0b656 : 00000000`2035f180 00000000`001a6c01 00000000`00000001 00000000`001a6c70 : mscorwks!CallDescrWorkerWithHandler+0xd3
    00000000`2035f000 000007fe`f9f4618f : 00000000`00000001 00000000`001a6c70 00000000`00000000 00000000`0563d5c8 : mscorwks!DispatchCallDebuggerWrapper+0x3e
    00000000`2035f060 000007fe`f9f93237 : 00000000`2035f630 00000000`001a6c70 00000000`00000001 00000000`001a6c70 : mscorwks!DispatchCallNoEH+0x5f
    00000000`2035f0e0 000007fe`f9e4e4b4 : 00000000`001a6c70 00000000`00000000 00000000`00000000 000007fe`f9ef197e : mscorwks!QueueUserWorkItemManagedCallback+0x83
    00000000`2035f170 000007fe`f9f3ab15 : 00000000`00000000 000007fe`f9e93acd 00000000`00000000 00000000`2035f630 : mscorwks!ManagedThreadCallState::IsAppDomainEqual+0x4c
    00000000`2035f1c0 000007fe`f9f6d125 : 00000000`0411e150 00000000`001a6c70 00000000`2035f230 00000000`00000000 : mscorwks!List<CNgenDependentBind * __ptr64>::AddTail+0x175
    00000000`2035f290 000007fe`f9e40d3d : 00000000`2035f630 00000000`2035f398 00000000`001a6c70 00000000`001a6c70 : mscorwks!CMiniMdTemplate<CMiniMdRW>::getEventTypeOfEvent+0x65
    00000000`2035f2d0 000007fe`f9e4e151 : 00000000`0411e150 00000000`001a6c70 00000000`001a6c00 00000000`001a6c70 : mscorwks!ILCodeStream::EmitLDTOKEN+0x29
    00000000`2035f300 000007fe`f9e4e4d9 : 00000000`00000000 000007fe`fa29d400 00000000`ffffffff 000007fe`f9ef197e : mscorwks!Thread::DoADCallBack+0x145
    00000000`2035f470 000007fe`f9f3ab15 : 00000000`2035f450 00000000`00000000 00000000`00000000 00000000`2035f630 : mscorwks!ManagedThreadCallState::IsAppDomainEqual+0x71
    00000000`2035f4c0 000007fe`f9f6d125 : ffffffff`fffffffe 00000000`001a6c70 00000000`2035f530 00000000`04115f80 : mscorwks!List<CNgenDependentBind * __ptr64>::AddTail+0x175
    00000000`2035f590 000007fe`f9f640d3 : 00000000`2035f630 ffffffff`ffffffff 00000000`001a6c70 00000000`04115f80 : mscorwks!CMiniMdTemplate<CMiniMdRW>::getEventTypeOfEvent+0x65
    00000000`2035f5d0 000007fe`f9e9a0ea : 00000000`00000003 00000000`001a6c70 00000000`00000001 00000000`00000001 : mscorwks!ManagedPerAppDomainTPCount::DispatchWorkItem+0x12b
    00000000`2035f6b0 000007fe`f9e4b6a4 : 00000000`00000000 00000000`00000000 00000000`2035faf0 00000000`00000000 : mscorwks!ThreadpoolMgr::WorkerThreadStart+0x1ba
    00000000`2035f750 00000000`772d652d : 00000000`00000000 00000000`00000000 00000000`00000000 00000000`00000000 : mscorwks!Thread::intermediateThreadProc+0x78
    00000000`2035fb20 00000000`7740c541 : 00000000`00000000 00000000`00000000 00000000`00000000 00000000`00000000 : kernel32!BaseThreadInitThunk+0xd
    00000000`2035fb50 00000000`00000000 : 00000000`00000000 00000000`00000000 00000000`00000000 00000000`00000000 : ntdll!RtlUserThreadStart+0x1d


    FOLLOWUP_IP: 
    ntdll!ZwQueryFullAttributesFile+a
    00000000`7743241a c3              ret

    SYMBOL_STACK_INDEX:  0

    SYMBOL_NAME:  ntdll!ZwQueryFullAttributesFile+a

    FOLLOWUP_NAME:  MachineOwner

    MODULE_NAME: ntdll

    IMAGE_NAME:  ntdll.dll

    DEBUG_FLR_IMAGE_TIMESTAMP:  51dba4e7

    STACK_COMMAND:  ~0s ; kb

    BUCKET_ID:  X64_dfffffff_ntdll!ZwQueryFullAttributesFile+a

    FAILURE_BUCKET_ID:  APPLICATION_HANG_WRONG_SYMBOLS_dfffffff_ntdll.dll!ZwQueryFullAttributesFile

    WATSON_STAGEONE_URL:  http://watson.microsoft.com/StageOne/mmc_exe/6_1_7600_16385/4a5bc808/unknown/0_0_0_0/bbbbbbb4/dfffffff/00000000.htm?Retriage=1

    Followup: MachineOwner
    ---------

    0:000> ~0s
    ntdll!ZwQueryFullAttributesFile+0xa:
    00000000`7743241a c3              ret
    0:000> kb
    RetAddr           : Args to Child                                                           : Call Site
    000007fe`fd3e810d : 00000000`0558eff0 00000000`0594da00 00000000`2035e688 000007fe`fa4d55e0 : ntdll!ZwQueryFullAttributesFile+0xa
    000007fe`fa01cc57 : 00000000`0594bb28 00000000`00000000 00000000`00000050 00000000`2035ea08 : KERNELBASE!GetFileAttributesExW+0x9d
    000007fe`f805d098 : 00000000`056fa290 000007fe`f7d696d0 00000000`0594d670 00000000`00000000 : mscorwks!DoNDirectCall__PatchGetThreadCall+0x7b
    000007fe`f805cd7c : 00000000`001a6c70 00000000`2035ea60 00000000`00000001 00000000`0594bb28 : mscorlib_ni+0x36d098
    000007fe`f80059a8 : 00000000`0594bb28 00000000`2035ea60 00000000`00000005 00000000`0594b501 : mscorlib_ni+0x36cd7c
    000007fe`efa2bed1 : 00000000`00000010 000007fe`f7fdbae0 00000000`00000000 00000000`056f9e10 : mscorlib_ni+0x3159a8
    000007fe`ef9e2804 : 00000000`0004f900 00000000`00000000 00000000`2035eb40 00000000`0562c200 : Microsoft_Windows_ServerManager_ni+0x90bed1
    000007fe`ef9e23ab : 00000000`05e0de30 00000000`0562c198 00000000`05e0df90 000007fe`f80230ce : Microsoft_Windows_ServerManager_ni+0x8c2804
    000007fe`ef9ba70c : 00000000`058a7b08 00000000`00000000 00000000`00000000 00000000`05e0d3c8 : Microsoft_Windows_ServerManager_ni+0x8c23ab
    000007fe`ef9b9ce1 : 000007fe`00000010 88d07f13`559ed4ef 00000000`00000000 00000000`056afe80 : Microsoft_Windows_ServerManager_ni+0x89a70c
    000007fe`f7fe2bbb : 00000000`0562c198 000007fe`fa3cf565 00000000`2035ee60 00000000`001a6c70 : Microsoft_Windows_ServerManager_ni+0x899ce1
    000007fe`f80575d1 : 00000000`2035ecf8 000007fe`f9f0b7a3 00000000`00000001 00000000`00000000 : mscorlib_ni+0x2f2bbb
    000007fe`f805740f : 00000000`00000000 00000000`2035f048 00000000`0000000a 00000000`2035ef28 : mscorlib_ni+0x3675d1
    000007fe`fa01d432 : 00000000`00000000 000007fe`f9f0b656 00000000`2035f098 00000000`00000000 : mscorlib_ni+0x36740f
    000007fe`f9f0b7a3 : 00000000`2035efa0 000007ff`0001a119 00000000`00000000 00000000`00000000 : mscorwks!CallDescrWorker+0x82
    000007fe`f9f0b656 : 00000000`2035f180 00000000`001a6c01 00000000`00000001 00000000`001a6c70 : mscorwks!CallDescrWorkerWithHandler+0xd3
    000007fe`f9f4618f : 00000000`00000001 00000000`001a6c70 00000000`00000000 00000000`0563d5c8 : mscorwks!DispatchCallDebuggerWrapper+0x3e
    000007fe`f9f93237 : 00000000`2035f630 00000000`001a6c70 00000000`00000001 00000000`001a6c70 : mscorwks!DispatchCallNoEH+0x5f
    000007fe`f9e4e4b4 : 00000000`001a6c70 00000000`00000000 00000000`00000000 000007fe`f9ef197e : mscorwks!QueueUserWorkItemManagedCallback+0x83
    000007fe`f9f3ab15 : 00000000`00000000 000007fe`f9e93acd 00000000`00000000 00000000`2035f630 : mscorwks!ManagedThreadCallState::IsAppDomainEqual+0x4c
    000007fe`f9f6d125 : 00000000`0411e150 00000000`001a6c70 00000000`2035f230 00000000`00000000 : mscorwks!List<CNgenDependentBind * __ptr64>::AddTail+0x175
    000007fe`f9e40d3d : 00000000`2035f630 00000000`2035f398 00000000`001a6c70 00000000`001a6c70 : mscorwks!CMiniMdTemplate<CMiniMdRW>::getEventTypeOfEvent+0x65
    000007fe`f9e4e151 : 00000000`0411e150 00000000`001a6c70 00000000`001a6c00 00000000`001a6c70 : mscorwks!ILCodeStream::EmitLDTOKEN+0x29
    000007fe`f9e4e4d9 : 00000000`00000000 000007fe`fa29d400 00000000`ffffffff 000007fe`f9ef197e : mscorwks!Thread::DoADCallBack+0x145
    000007fe`f9f3ab15 : 00000000`2035f450 00000000`00000000 00000000`00000000 00000000`2035f630 : mscorwks!ManagedThreadCallState::IsAppDomainEqual+0x71
    000007fe`f9f6d125 : ffffffff`fffffffe 00000000`001a6c70 00000000`2035f530 00000000`04115f80 : mscorwks!List<CNgenDependentBind * __ptr64>::AddTail+0x175
    000007fe`f9f640d3 : 00000000`2035f630 ffffffff`ffffffff 00000000`001a6c70 00000000`04115f80 : mscorwks!CMiniMdTemplate<CMiniMdRW>::getEventTypeOfEvent+0x65
    000007fe`f9e9a0ea : 00000000`00000003 00000000`001a6c70 00000000`00000001 00000000`00000001 : mscorwks!ManagedPerAppDomainTPCount::DispatchWorkItem+0x12b
    000007fe`f9e4b6a4 : 00000000`00000000 00000000`00000000 00000000`2035faf0 00000000`00000000 : mscorwks!ThreadpoolMgr::WorkerThreadStart+0x1ba
    00000000`772d652d : 00000000`00000000 00000000`00000000 00000000`00000000 00000000`00000000 : mscorwks!Thread::intermediateThreadProc+0x78
    00000000`7740c541 : 00000000`00000000 00000000`00000000 00000000`00000000 00000000`00000000 : kernel32!BaseThreadInitThunk+0xd
    00000000`00000000 : 00000000`00000000 00000000`00000000 00000000`00000000 00000000`00000000 : ntdll!RtlUserThreadStart+0x1d
    0:000> 

    2013年9月18日 8:30

全部回复