June 19, 2015 at 12:25 pm
Hello,
Today morning we noticed that our SQL Server started crashing and noticed the below error from Event Log / SQL Error Log:
SQL Server is not ready to accept new client connections. Wait a few minutes before trying again. If you have access to the error log, look for the informational message that indicates that SQL Server is ready before trying to connect again.
We are on SQL Server 2014 SP1, I am checking online to see if I can get any useful information for troubleshooting.
Any help would be greatly appreciated.
Thanks!
June 24, 2015 at 4:10 am
Do you have any other error messages in the log? This is a generic message which comes when SQL is starting and is not ready to accept connections.
Please check the SQL Error log and there should be some more relevant error messages.
June 24, 2015 at 5:42 am
It just means that someone was trying to connect while SQL was still starting up. It's not an error.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 24, 2015 at 8:54 am
This is not an error. You must dig for the causes that leaded to the SQL Server restart on the previous errorlog and in the eventviewer.
If the database instance is in cluster, check also the events in the cluster administrator.
June 24, 2015 at 9:19 am
Thanks much for looking into this, I also found few other errors from SQLLog (preciously from SQLDump0001.mdmp).
MISSING_CLR_METADATA_42ac_sqllang.dll!SQLDumperLibraryInvoke
DEFAULT_BUCKET_ID: MISSING_CLR_METADATA
PROCESS_NAME: sqlservr.exe
OVERLAPPED_MODULE: Address regions for 'ssdebugps' and 'sqlboot.dll' overlap
ERROR_CODE: (NTSTATUS) 0x42ac - <Unable to get error code text>
EXCEPTION_CODE: (Win32) 0x42ac (17068) - <Unable to get error code text>
NTGLOBALFLAG: 0
APP: sqlservr.exe
ANALYSIS_VERSION: 6.13.0016.2229 (debuggers(dbg).140401-1942) amd64fre
MANAGED_STACK: !dumpstack -EE
OS Thread Id: 0x4f78 (0)
Current frame:
Child-SP RetAddr Caller, Callee
FAULTING_THREAD: 0000000000004f78
BUGCHECK_STR: APPLICATION_FAULT_MISSING_CLR_METADATA
PRIMARY_PROBLEM_CLASS: MISSING_CLR_METADATA
LAST_CONTROL_TRANSFER: from 00007ff799e568f5 to 00007ffd72308b9c
STACK_TEXT:
000001b8`ae14c940 00007ff7`99e568f5 : 00000000`04018664 000631bb`0005aec0 000001b8`ae14ca90 00007ffd`7230b177 : KERNELBASE!RaiseException+0x68
000001b8`ae14ca20 00007ffd`62825624 : 00000000`00000000 000001b8`ae14cca8 00007ff7`99e97680 00007ff7`99e55e18 : sqlservr!CDmpDump::Dump+0x65
000001b8`ae14cb20 00007ffd`632866ae : 00007ff7`99e977e8 00000000`00000440 00000000`00000000 00007ff7`99e55e98 : sqllang!SQLDumperLibraryInvoke+0x1e4
000001b8`ae14cb60 00007ffd`63287086 : 00000000`00025160 000001b8`ae14e8c0 00000000`00000000 00007ffd`64424900 : sqllang!SQLLangDumperLibraryInvoke+0x15e
000001b8`ae14cc00 00007ffd`6324f605 : 00000000`00000000 00000000`00000000 000001b8`ae14e8c0 00000000`00000000 : sqllang!CImageHelper::DoMiniDump+0x426
000001b8`ae14cdf0 00007ffd`628257a2 : 000001b8`ae14e898 000001b8`ae14e8c0 00000010`0000439f 00000001`0000003f : sqllang!stackTrace+0x9d5
000001b8`ae14e840 00007ffd`6164a085 : 00000000`c0000005 000001b8`ae14fb00 00000000`00000001 000001b8`ae14ec40 : sqllang!stackTraceCallBack+0xd2
000001b8`ae14e890 00007ffd`723e1c72 : 00000000`00000000 00000000`00000000 00000000`00000000 00000000`00000000 : sqldk!ex_handle_except+0x125
000001b8`ae14eae0 00007ffd`7517fb33 : 00000000`00000000 00007ffd`723e1ad0 00000000`00000000 00007ffd`6b34ceb9 : KERNELBASE!UnhandledExceptionFilter+0x1a2
000001b8`ae14ebd0 00007ffd`75162896 : 00007ffd`7520db20 00007ffd`75135ec5 00000000`00000000 00000000`d7dbf613 : ntdll!RtlUserThreadStart$filt$0+0x3e
000001b8`ae14ec10 00007ffd`75173f0d : 00000000`00000000 000001b8`ae14edb0 000001b8`ae14f870 000001b8`ae14f870 : ntdll!__C_specific_handler+0x96
000001b8`ae14ec80 00007ffd`75134887 : 00000000`00000001 00007ffd`750e0000 00000000`00000000 00007ffd`7521309c : ntdll!RtlpExecuteHandlerForException+0xd
000001b8`ae14ecb0 00007ffd`7517309a : 00000000`00000000 00000000`00000000 000001b8`ad950000 00000000`00000000 : ntdll!RtlDispatchException+0x197
000001b8`ae14f380 00007ffd`751a793a : 00000000`00000000 00000000`00000000 00000000`00000000 00000000`00000000 : ntdll!KiUserExceptionDispatch+0x3a
000001b8`ae14faa0 00007ffd`72f413d2 : 00007ffd`751a7920 00000000`00000000 00000000`00000000 00000000`00000000 : ntdll!RtlpQueryProcessDebugInformationRemote+0x1a
000001b8`ae14fad0 00007ffd`750f5444 : 00007ffd`72f413b0 00000000`00000000 00000000`00000000 00000000`00000000 : kernel32!BaseThreadInitThunk+0x22
000001b8`ae14fb00 00000000`00000000 : 00000000`00000000 00000000`00000000 00000000`00000000 00000000`00000000 : ntdll!RtlUserThreadStart+0x34
FOLLOWUP_IP:
sqllang!SQLDumperLibraryInvoke+1e4 [d:\b\s1\sources\sqltdbms\common\dump\common_stack.cpp @ 807]
00007ffd`62825624 448bf0 mov r14d,eax
FAULTING_SOURCE_LINE: d:\b\s1\sources\sqltdbms\common\dump\common_stack.cpp
FAULTING_SOURCE_FILE: d:\b\s1\sources\sqltdbms\common\dump\common_stack.cpp
FAULTING_SOURCE_LINE_NUMBER: 807
SYMBOL_STACK_INDEX: 2
SYMBOL_NAME: sqllang!SQLDumperLibraryInvoke+1e4
FOLLOWUP_NAME: wintriag
MODULE_NAME: sqllang
IMAGE_NAME: sqllang.dll
DEBUG_FLR_IMAGE_TIMESTAMP: 5535c9a9
STACK_COMMAND: .cxr 1b8ae14f380 ; kb ; .ecxr ; kb
FAILURE_BUCKET_ID: MISSING_CLR_METADATA_42ac_sqllang.dll!SQLDumperLibraryInvoke
BUCKET_ID: APPLICATION_FAULT_MISSING_CLR_METADATA_sqllang!SQLDumperLibraryInvoke+1e4
ANALYSIS_SOURCE: UM
FAILURE_ID_HASH_STRING: um:missing_clr_metadata_42ac_sqllang.dll!sqldumperlibraryinvoke
FAILURE_ID_HASH: {453f891f-76a2-c3a2-9b1e-62aad36b9582}
FAILURE_ID_REPORT_LINK: http://telreports/_layouts/ReportServer/RSViewerPage.aspx?rv:RelativeReportUrl=/reports/failurev2.rdl&rp:FailureHash=453f891f-76a2-c3a2-9b1e-62aad36b9582
Followup: wintriag
---------
Though I couldn't quite follow this error message, please let me know if that helps.
Thanks again for looking into this.
February 24, 2016 at 11:13 am
I am also getting similar error from crash dump and SQL is restarting after very 30 minutes
*******************************************************************************
* *
* Exception Analysis *
* *
*******************************************************************************
Debugger CompCtrlDb Connection::Open failed 80004005
Cannot access CompCentralDB. You may need to request access: http://windows/access
*** WARNING: Unable to verify checksum for mscorlib.ni.dll
Debugger Dbgportaldb Connection::Open failed 80004005
Database Dbgportaldb not connected
FAULTING_IP:
sqllang!SQLDumperLibraryInvoke+2e4 [e:\sql11_main_t\sqltdbms\msql\utils\watson.cpp @ 573]
000007fd`6a5c5a94 8bd8 mov ebx,eax
EXCEPTION_RECORD: ffffffffffffffff -- (.exr 0xffffffffffffffff)
ExceptionAddress: 000007fd6a5c5a94 (sqllang!SQLDumperLibraryInvoke+0x00000000000002e4)
ExceptionCode: 000042ac
ExceptionFlags: 00000000
NumberParameters: 0
CONTEXT: 0000000000000000 -- (.cxr 0x0;r)
rax=000000000000003f rbx=0000000000000000 rcx=0000000000000043
rdx=0000000066b05ce0 rsi=0000000000000064 rdi=0000000000001ecc
rip=000007fd8fba2bea rsp=000000006777c358 rbp=000000006777d630
r8=0000000000000000 r9=0000000000000000 r10=0000000000000004
r11=0000000000000007 r12=0000000000000000 r13=0000000000000000
r14=000000006777c388 r15=0000000000000000
iopl=0 nv up ei ng nz na po cy
cs=0033 ss=002b ds=002b es=002b fs=0053 gs=002b efl=00000287
ntdll!ZwWaitForSingleObject+0xa:
000007fd`8fba2bea c3 ret
PROCESS_NAME: sqlservr.exe
ERROR_CODE: (NTSTATUS) 0x42ac - <Unable to get error code text>
EXCEPTION_CODE: (Win32) 0x42ac (17068) - <Unable to get error code text>
NTGLOBALFLAG: 0
APP: sqlservr.exe
ANALYSIS_VERSION: 6.13.0016.1867 (debuggers(dbg).130603-1717) amd64fre
MANAGED_STACK: !dumpstack -EE
OS Thread Id: 0x4708 (0)
Current frame:
Child-SP RetAddr Caller, Callee
FAULTING_THREAD: 0000000000004708
BUGCHECK_STR: APPLICATION_FAULT_APPLICATION_FAULT_MISSING_CLR_METADATA
PRIMARY_PROBLEM_CLASS: APPLICATION_FAULT_MISSING_CLR_METADATA
DEFAULT_BUCKET_ID: APPLICATION_FAULT_MISSING_CLR_METADATA
LAST_CONTROL_TRANSFER: from 000007f62b26f32c to 000007fd8ce36ac0
STACK_TEXT:
00000000`6777d530 000007f6`2b26f32c : 000007fd`6b300fc0 000007f6`2b26db14 00000000`6777d650 000007fd`69b55b80 : KERNELBASE!RaiseException+0x68
00000000`6777d610 000007fd`6a5c5a94 : 000007f6`2b27a668 00000000`00000004 00000000`0258f5a0 000007fd`6aa4fb49 : sqlservr!CDmpDump::Dump+0x4c
00000000`6777d650 000007fd`6a5c64b6 : 00000000`00000000 00000000`6777f610 00000000`00000000 000007fd`6b2f39b0 : sqllang!SQLDumperLibraryInvoke+0x2e4
00000000`6777d8f0 000007fd`6a58d14b : 0000000e`c20f2040 00000000`6777f610 0000000e`c20f2040 0000000e`c20f30c0 : sqllang!CImageHelper::DoMiniDump+0x426
00000000`6777dae0 000007fd`6a58c54a : 00000000`000000ff 000007fd`6caa2286 00000000`6777f580 0000001b`0000083f : sqllang!stackTrace+0xbdb
00000000`6777f520 000007fd`74b54bdd : 000007fd`74b23bf0 00000000`6777f660 00000000`00000034 00000000`008a6fb0 : sqllang!stackTraceCallBack+0xca
00000000`6777f560 000007fd`74b37639 : 00000000`6777f8b0 00000000`6777f880 00000000`12af6cc0 00000000`6777f960 : sqldk!ex_raise2+0x340
00000000`6777f870 000007fd`6caa2286 : 0000000e`10500000 0000000e`c20e2218 00000008`0000016c 0000000e`00000009 : sqldk!ex_raise+0xf0
00000000`6777f8f0 000007fd`6b7246df : 00000000`00000000 00000000`67780130 00000000`00000000 0000000e`c20d7a70 : sqlmin!RaiseInconsistencyError+0x316
00000000`6777fc20 000007fd`6b5219e8 : ffffffff`fffffffe 0000001c`2af33540 00000000`00000004 00000000`00000000 : sqlmin!IndexPageManager::GetPageForLinkModification+0x1ecc
00000000`677800c0 000007fd`6b51378c : 0000000e`c20d7a60 00000000`00000000 0000000e`c20d7a60 00000000`00000000 : sqlmin!SplitPage+0x3a9
00000000`67780b90 000007fd`6b515f23 : 00000000`00000000 0000000e`00000000 0000000c`d0493350 0000000e`c20c0001 : sqlmin!IndexDataSetSession::InsertSmallRecord+0x1b5c
00000000`67788eb0 000007fd`6b5161d6 : 000169e2`45361ac4 000007fd`6b52e8bb 00000000`00000000 0000000e`104ec630 : sqlmin!IndexDataSetSession::InsertRowInternal+0x2d11
00000000`6778b130 000007fd`6b516066 : 0000000e`c20c5d58 0000000e`c209aca8 0000000e`c20c5d20 000007fd`55c40000 : sqlmin!DatasetSession::InsertRow+0x163
00000000`6778b200 000007fd`6b51c26b : 0000000e`c20d4f30 000007fd`55c474ab 0000000e`0010be60 00000000`00000000 : sqlmin!RowsetNewSS::InsertRow+0x26
00000000`6778b230 000007fd`55c47f27 : 0000000e`c20d4f30 000007fd`00000004 00000000`6778b330 0000000e`c209aca8 : sqlmin!CValRowMult::SetDataX+0x194
00000000`6778b300 000007fd`6b51cb23 : 0000000e`c209b7b0 00000000`00000004 00000000`00000004 0000000e`c209ac60 : sqltses!CEsExec::GeneralEval+0x1a9
00000000`6778b420 000007fd`6b51ca96 : 0000000e`c209ac60 0000000e`c209b570 0000000e`c209b570 00000000`00000004 : sqlmin!CQScanUpdateNew::GetRow+0x3f7
00000000`6778b4c0 000007fd`6b4c671f : 0000000e`c209a150 00000000`00000000 0000000e`c209ad50 0000000d`eb790d80 : sqlmin!CQScanUpdateNew::GetRow+0x76
00000000`6778b560 000007fd`69432051 : 7fffffff`ffffffff 00000000`00000000 00000000`6778bf38 ffffffff`ffffffff : sqlmin!CQueryScan::GetRow+0x81
00000000`6778b590 000007fd`6945cb9d : 0000000e`c209a150 0000000e`c20f2040 0000000e`c209a100 00000000`00000000 : sqllang!CXStmtQuery::ErsqExecuteQuery+0x54a
00000000`6778b720 000007fd`6945c9a9 : 0000000e`c209a201 00000000`0499cc00 00000000`00000000 0000000e`c20f2001 : sqllang!CXStmtDML::XretDMLExecute+0x2f3
00000000`6778b800 000007fd`694103b1 : 00000000`00000000 0000000e`c20a0430 00000000`6778b8f9 0000000e`c209a150 : sqllang!CXStmtDML::XretExecute+0xad
00000000`6778b830 000007fd`6942a58b : 0000000e`c20a0810 00000000`00000000 ffffffff`fffffffe 00000000`00000000 : sqllang!CMsqlExecContext::ExecuteStmts<1,1>+0x400
00000000`6778b950 000007fd`69429cc4 : 0000000e`c20a0150 0000000e`c20f2040 00000000`6778be00 0000000d`60526da8 : sqllang!CMsqlExecContext::FExecute+0xa33
00000000`6778bb40 000007fd`6a286f33 : 0000000d`60526da8 0000000d`60526da8 0000000d`60526da8 00000000`00000000 : sqllang!CSQLSource::Execute+0x866
00000000`6778bd00 000007fd`6a28f132 : 00000000`00000000 00000000`00000000 00000000`00000000 0000000d`eb790d90 : sqllang!ExecuteSql+0x863
00000000`6778c7c0 000007fd`6a28e73c : 0000000e`c20f2040 0000000d`60526da8 0000000e`c20f3040 000007fd`6a2ecd00 : sqllang!CSpecProc::ExecuteSpecial+0x2a2
00000000`6778c8f0 000007fd`6995a588 : 0000000d`00000000 0000000e`c20f2040 0000000d`60526998 0000000d`60526998 : sqllang!CXProc::Execute+0x16c
00000000`6778cd60 000007fd`6a2bca51 : 00000000`00000000 00000000`00000000 0000000d`60526da8 000007fd`00000000 : sqllang!CSQLSource::Execute+0x9a8
00000000`6778cf20 000007fd`6a2bc4c5 : 0000000d`60526998 0000000d`60526998 00000000`00000000 00000000`04976160 : sqllang!CStmtExecProc::XretLocalExec+0x201
00000000`6778cfa0 000007fd`6a2b9dc8 : 00000000`00000000 000007fd`6a2ec738 0000000d`605268e0 00000019`b8b31020 : sqllang!CStmtExecProc::XretExecExecute+0x4d5
00000000`6778d740 000007fd`694103b1 : 0000000d`65056430 0000000e`c20f2040 0000000e`c20f2040 0000000d`60526060 : sqllang!CXStmtExecProc::XretExecute+0x38
00000000`6778d780 000007fd`6942a58b : 00000022`13974785 00000000`00000000 0000000e`c20f3170 000007fd`6945369a : sqllang!CMsqlExecContext::ExecuteStmts<1,1>+0x400
00000000`6778d8a0 000007fd`69429cc4 : 0000000d`65056150 0000000e`c20f2040 0000000e`c20ee200 0000000e`c20ee628 : sqllang!CMsqlExecContext::FExecute+0xa33
00000000`6778da90 000007fd`6a2bca51 : 00000000`00000000 00000000`00000000 0000000e`c20ee628 00000019`00000000 : sqllang!CSQLSource::Execute+0x866
00000000`6778dc50 000007fd`6a2bc4c5 : 0000000e`c20ee218 0000000e`c20ee218 00000000`00000000 00000000`6778dd28 : sqllang!CStmtExecProc::XretLocalExec+0x201
00000000`6778dcd0 000007fd`6a2b9dc8 : 00000000`00000000 000007fd`6a2ec738 0000000e`c20ee160 00000019`b86950b0 : sqllang!CStmtExecProc::XretExecExecute+0x4d5
00000000`6778e470 000007fd`694103b1 : 0000000e`c20b4430 0000000e`c20f2040 0000000e`c20f2040 0000000e`c2083f10 : sqllang!CXStmtExecProc::XretExecute+0x38
00000000`6778e4b0 000007fd`6942a58b : 00000022`13973e12 00000000`00000000 0000000e`c20f3170 000007fd`6945369a : sqllang!CMsqlExecContext::ExecuteStmts<1,1>+0x400
00000000`6778e5d0 000007fd`69429cc4 : 0000000e`c20b4150 0000000e`c20f2040 0000000e`c20f8000 0000000e`c20f6100 : sqllang!CMsqlExecContext::FExecute+0xa33
00000000`6778e7c0 000007fd`6944ee4c : 0000000e`c20f1da0 0000000e`c20f1da0 0000000e`c20f6100 00000000`00000000 : sqllang!CSQLSource::Execute+0x866
00000000`6778e980 000007fd`69444827 : 00000000`00000000 00000000`00000000 00000000`00000001 00000000`00000000 : sqllang!process_request+0x73c
00000000`6778f050 000007fd`74b13740 : 0000001b`ff8a0f40 00000000`00000000 ffffffff`ffffffff 00000000`6778f440 : sqllang!process_commands+0x51c
00000000`6778f310 000007fd`74b13be4 : 0000001b`ff8a0f58 00000000`00000200 00000000`0499ccf8 00000000`00000000 : sqldk!SOS_Task::Param::Execute+0x21e
00000000`6778f910 000007fd`74b139e7 : 0000001b`ff8a0040 00000000`0499ccf8 0000001b`ff8a0040 00000000`00000000 : sqldk!SOS_Scheduler::RunTask+0xa8
00000000`6778f980 000007fd`74b41d3f : 0000001b`ff300158 00000000`04976160 00000000`04976160 00000000`04976160 : sqldk!SOS_Scheduler::ProcessTasks+0x29a
00000000`6778fa00 000007fd`74b424a0 : 00000000`04976160 00000021`9dc8ba4f 00000000`04976160 00000000`000dbba0 : sqldk!SchedulerManager::WorkerEntryPoint+0x261
00000000`6778faa0 000007fd`74b432eb : 000007f6`2a215508 00000000`6778fb40 0000001b`ff300258 00000000`00001338 : sqldk!SystemThread::RunWorker+0x8f
00000000`6778fad0 000007fd`74b41b68 : 00000000`00000000 000007f6`2a215508 00000000`00000000 00000000`00000000 : sqldk!SystemThreadDispatcher::ProcessWorker+0x3c8
00000000`6778fb80 000007fd`8fa61842 : 00000000`00000000 00000000`00000000 000007f6`2a215508 00000000`00000000 : sqldk!SchedulerManager::ThreadEntryPoint+0x236
00000000`6778fc20 000007fd`8fbddf11 : 00000000`00000000 00000000`00000000 00000000`00000000 00000000`00000000 : kernel32!BaseThreadInitThunk+0x1a
00000000`6778fc50 00000000`00000000 : 00000000`00000000 00000000`00000000 00000000`00000000 00000000`00000000 : ntdll!RtlUserThreadStart+0x1d
STACK_COMMAND: ~0s; .ecxr ; kb
FOLLOWUP_IP:
sqllang!SQLDumperLibraryInvoke+2e4 [e:\sql11_main_t\sqltdbms\msql\utils\watson.cpp @ 573]
000007fd`6a5c5a94 8bd8 mov ebx,eax
FAULTING_SOURCE_LINE: e:\sql11_main_t\sqltdbms\msql\utils\watson.cpp
FAULTING_SOURCE_FILE: e:\sql11_main_t\sqltdbms\msql\utils\watson.cpp
FAULTING_SOURCE_LINE_NUMBER: 573
SYMBOL_STACK_INDEX: 2
SYMBOL_NAME: sqllang!SQLDumperLibraryInvoke+2e4
FOLLOWUP_NAME: wintriag
MODULE_NAME: sqllang
IMAGE_NAME: sqllang.dll
DEBUG_FLR_IMAGE_TIMESTAMP: 513ae1d6
FAILURE_BUCKET_ID: APPLICATION_FAULT_MISSING_CLR_METADATA_42ac_sqllang.dll!SQLDumperLibraryInvoke
BUCKET_ID: APPLICATION_FAULT_APPLICATION_FAULT_MISSING_CLR_METADATA_sqllang!SQLDumperLibraryInvoke+2e4
ANALYSIS_SOURCE: UM
FAILURE_ID_HASH_STRING: um:application_fault_missing_clr_metadata_42ac_sqllang.dll!sqldumperlibraryinvoke
FAILURE_ID_HASH: {d3e12259-659c-ce4a-0698-f422925e8301}
Followup: wintriag
---------
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply