Feil #: 213819 (Innholdsvedlikehold) VSTS:3424685
Symptomer
Når du utfører en parallell spørring som involverer en flette bli med i Microsoft SQL Server-2014, oppstår en påstand unntak, og du mottar følgende feilmelding fra SQL Server-feilloggen:
<Dato><tid> spid <ID> bruke 'dbghelp.dll' versjon '4.0.5'
<Dato><tid> spid <ID> ** Dump tråd - spid = <ID> EC = 0x0000007F8608E160
<Dato><tid> spid <ID> *** stakk Dump sendes til <Navn på disken>: \Programfiler\Microsoft SQL Server\MSSQL12. MSSQLSERVER\MSSQL\LOG\SQLDump0002.txt
<Date> <Time> spid<ID> * *******************************************************************************
<Date> <Time> spid<ID> *
<Dato><tid> spid <ID> * BEGYNNE BUNKE DUMP:
<Dato><tid> spid <ID> * <dato><tid> spid <ID>
<Date> <Time> spid<ID> *
<Dato><tid> spid <ID> * plassering: qxcntxt.cpp:1143
<Dato><tid> spid <ID> * uttrykk:! " Ingen unntak bør være hevet koden"
<Dato><tid> spid <ID> * SPID: <ID>
<Dato><tid> spid <ID> * prosess-ID: 3556
<Date> <Time> spid<ID> *
<Dato><tid> spid <ID> * Input Buffer 37 byte -
<Dato><tid> spid <ID> * 16 00 00 00 12 00 00 00 02 00 00 00 00 00 00 00 00 00
<Dato><tid> spid <ID> * ÿÿ & 01 00 00 00 ff ff 0 c 00 00 00 00 00 26 04 04 05 00 00
<Dato><tid> spid <ID> * 00
<Date> <Time> spid<ID> *
<Date> <Time> spid<ID> *
...
<Dato><tid> spid <ID> stakk signatur for dump er 0x000000014202549F
<Dato><tid> spid <ID> [INFO] identitet Begin End | Feil tilstand resultatet Speculate forberedt LazyCommit ReadOnly | Transaksjonen databasen ThreadId | ReadSet WriteSet ScanSet et lagringspunkt LogSizeRq | CommitDep TotalComm avhengige 0 avhengige 1 avhengige 2 avhengige 3 avhengige 4 avhengige 5 avhengige 6 avhengige 7 | Områdeplassering |
<Dato><tid> spid <ID> tidsavbrudd under venting på eksterne dump prosessen 11800.
<Dato><tid> spid <ID> feil: 17066, alvorlighetsgrad: 16 tilstand: 1.
<Dato><tid> spid <ID> SQL Server påstand: fil: < qxcntxt.cpp > linje = 1143 mislyktes påstand = '! " Ingen unntak bør være hevet koden"'. Denne feilen kan være relatert til timing. Hvis feilen vedvarer etter å kjøre oppgaven, bruke DBCC CHECKDB til å kontrollere databasen for strukturelle integritet eller restarte serveren for å sikre i minnets datastrukturer ikke er skadet.
Oppløsning
Dette problemet ble først løst i den følgende kumulative oppdateringen av SQL Server.
Kumulativ oppdatering 5 for SQLServer 2014/en-us/help/3011055
Om kumulative oppdateringer for SQL Server
Hver nye kumulative oppdateringen for SQL Server inneholder alle hurtigreparasjonene og alle sikkerhetsreparasjoner som fulgte med den forrige kumulative oppdateringen. Sjekk ut de nyeste kumulative oppdateringene for SQL Server:
Hvis du vil ha mer informasjon
KallstakkStack Thread 199======================================
0:199> kp
*** Stack trace for last set context - .thread/.cxr resets it
Child-SP RetAddr Call Site
00000036`da2a8880 000007f6`63366455 KERNELBASE!RaiseException(unsigned long dwExceptionCode = <Value unavailable error>, unsigned long dwExceptionFlags = <Value unavailable error>, unsigned long nNumberOfArguments = <Value unavailable error>, unsigned int64 * lpArguments = <Value unavailable error>)+0x68 [d:\win8_gdr\minkernel\kernelbase\xcpt.c @ 820]
00000036`da2a8960 000007f8`e7559dd4 sqlservr!CDmpDump::Dump(void)+0x65 [d:\sql12_main_t\sql\ntdbms\storeng\util\sqldumper\lib\dmpdump.cpp @ 1050]
00000036`da2a8a60 000007f8`e7fc0a5e sqllang!SQLDumperLibraryInvoke(struct IDmpDump * pDump = 0x000007f6`633a6808, unsigned long ulThreadId = 0x33b4, unsigned int64 stackSignature = 0, struct _CONTEXT * pContext = 0x000007f8`e7767f50, struct _EXCEPTION_RECORD * pExceptionRecord = 0x00000000`00000000, wchar_t * pExceptionName = 0x00000036`da2aa7d0 "Location:. qxcntxt.cpp:1143.Expression:. !"No exceptions should be raised by this code".SPID:.. 65.Process ID:. 3556", wchar_t * pDumpFileName = 0x000007f8`e9143ca0 "C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\LOG\SQLDump0002.txt", wchar_t * pDumpInfo = 0x000007f8`e8b78228 "Stack Trace", wchar_t * logDirectory = 0x000007f8`e9156d3c "C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\LOG\", wchar_t * appImageName = 0x00000000`00000000 "", unsigned long dumpFlagsTurnOn = 0x8040, unsigned long dumpFlagsTurnOff = 0, unsigned long miniDumpFlagsTurnOn = 0x29160, unsigned long miniDumpFlagsTurnOff = 0, unsigned long * pExitCode = 0x00000036`da2a8bd0, wchar_t * errorMessageBuffer = 0x000007f8`e9144880 "")+0x1e4 [d:\sql12_main_t\sql\ntdbms\common\dump\common_stack.cpp @ 807]
00000036`da2a8aa0 000007f8`e7fc1446 sqllang!SQLLangDumperLibraryInvoke(struct IDmpDump * pDump = 0x000007f6`633a6808, unsigned long ulThreadId = 0x33b4, unsigned int64 stackSignature = 0x00000001`4202549f, struct _CONTEXT * pContext = 0x00000000`00000000, struct _EXCEPTION_RECORD * pExceptionRecord = 0x00000000`00000000, wchar_t * pExceptionName = 0x00000036`da2aa7d0 "Location:. qxcntxt.cpp:1143.Expression:. !"No exceptions should be raised by this code".SPID:.. 65.Process ID:. 3556", wchar_t * pDumpFileName = 0x000007f8`e9143ca0 "C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\LOG\SQLDump0002.txt", wchar_t * pDumpInfo = 0x000007f8`e8b78228 "Stack Trace", unsigned long dumpFlagsTurnOn = 0x8040, unsigned long dumpFlagsTurnOff = 0, unsigned long miniDumpFlagsTurnOn = 0x29160, unsigned long miniDumpFlagsTurnOff = 0, unsigned long * pExitCode = 0x00000036`da2a8bd0, wchar_t * errorMessageBuffer = 0x000007f8`e9144880 "")+0x15e [d:\sql12_main_t\sql\ntdbms\msql\utils\watson.cpp @ 197]
00000036`da2a8b40 000007f8`e7f899c5 sqllang!CImageHelper::DoMiniDump(unsigned long ulThreadId = 0x33b4, unsigned int64 stackSignature = 0x00000001`4202549f, struct _CONTEXT * pContext = 0x00000000`00000000, struct _EXCEPTION_RECORD * pExceptionRecord = 0x00000000`00000000, wchar_t * pExceptionName = 0x00000036`da2aa7d0 "Location:. qxcntxt.cpp:1143.Expression:. !"No exceptions should be raised by this code".SPID:.. 65.Process ID:. 3556", wchar_t * pDumpFileName = 0x000007f8`e9143ca0 "C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\LOG\SQLDump0002.txt", wchar_t * pDumpInfo = 0x000007f8`e8b78228 "Stack Trace", int multiThreaded = 0n0, unsigned long inputDumpFlags = 0x400)+0x426 [d:\sql12_main_t\sql\ntdbms\msql\utils\watson.cpp @ 752]
00000036`da2a8d30 000007f8`e7fcb0c7 sqllang!stackTrace(class SOS_Task * inputTask = 0x00000000`00000000, class ExecutionContext * inputEc = 0x00000036`da2aa8c0, wchar_t * pwszDumpMsg = 0x00000036`da2aa7d0 "Location:. qxcntxt.cpp:1143.Expression:. !"No exceptions should be raised by this code".SPID:.. 65.Process ID:. 3556", unsigned long dwDumpOptions = 0x3f, StackTraceClass dumpClass = STACK_TRACE_ASSERT (0n25), class CDStream * pInDstream = 0x00000000`00000000, WatsonBucketHint bucketHint = WBH_CONTEXT (0n0))+0x9d5 [d:\sql12_main_t\sql\ntdbms\msql\utils\stack.cpp @ 5140]
00000036`da2aa780 000007f8`e6279825 sqllang!utassert_fail_imp(unsigned int assert_type = 1, char * failing_expression = 0x000007f8`ed0a69e8 "!"No exceptions should be raised by this code"", char * filename = 0x000007f8`ed08d9f0 "qxcntxt.cpp", int line_number = 0n1143, char * szDescFormatted = 0x00000036`da2ab230 "", int cbDescFormatted = 0n512)+0x617 [d:\sql12_main_t\sql\ntdbms\msql\utils\sqlasert.cpp @ 440]
00000036`da2aaf80 000007f8`ec63f168 sqldk!utassert_fail(unsigned int assert_type = 1, char * failing_expression = 0x000007f8`ed0a69e8 "!"No exceptions should be raised by this code"", char * filename = 0x000007f8`ed08d9f0 "qxcntxt.cpp", int line_number = 0n1143, char * szDesc = 0x00000000`00000000 "")+0x2a5 [d:\sql12_main_t\sql\ntdbms\dk\sqldk\src\sqldkcallbacks.cpp @ 183]
00000036`da2ab480 00000000`59138a40 sqlmin!`CQueryExecContext::~CQueryExecContext'::`1'::catch$3+0x68 [d:\sql12_main_t\sql\ntdbms\query\qecore\qxcntxt.cpp @ 1143]
00000036`da2ab4c0 00000000`59130463 msvcr100!_CallSettingFrame(void)+0x20 [f:\dd\vctools\crt_bld\SELF_64_amd64\crt\prebuild\eh\amd64\handlers.asm @ 44]
00000036`da2ab4f0 000007f8`f65a50d3 msvcr100!__CxxCallCatchBlock(struct _EXCEPTION_RECORD * pExcept = 0x00000036`da2ac260)+0xeb [f:\dd\vctools\crt_bld\self_64_amd64\crt\prebuild\eh\frame.cpp @ 1337]
00000036`da2ab5b0 000007f8`e93c374b ntdll!RcFrameConsolidation(void)+0x3 [d:\win8_gdr\minkernel\ntos\rtl\amd64\capture.asm @ 547]
(Inline Function) --------`-------- sqlmin!CSingleLinkedPtrs<IUnknown>::ReleasePtr+0x6 [d:\sql12_main_t\sql\ntdbms\query\qecore\qxcntxt.h @ 430]
(Inline Function) --------`-------- sqlmin!CSingleLinkedPtrs<IUnknown>::PopAndDestroy+0x6e [d:\sql12_main_t\sql\ntdbms\query\qeexec\qetempl.h @ 1187]
00000036`da2ade40 000007f8`e940128d sqlmin!CQueryExecContext::~CQueryExecContext(void)+0x2db [d:\sql12_main_t\sql\ntdbms\query\qecore\qxcntxt.cpp @ 1134]
00000036`da2ae040 000007f8`e94000a2 sqlmin!FnProducerThreadExternalCleanup(class CXProducerDesc ** hxproddesc = 0x000000ae`dbc1e2a0, class IMemObj ** hmo = 0x00000036`da2ae110)+0x4d [d:\sql12_main_t\sql\ntdbms\query\qeexec\qsxchng.cpp @ 2453]
00000036`da2ae070 000007f8`e940094f sqlmin!FnProducerThread(void * pv = 0x00000036`da2ae4b0)+0x9c5 [d:\sql12_main_t\sql\ntdbms\query\qeexec\qsxchng.cpp @ 2307]
00000036`da2ae3d0 000007f8`e6224a00 sqlmin!SubprocEntrypoint(void * param = 0x00000019`78cbac80)+0xa7f [d:\sql12_main_t\sql\ntdbms\storeng\dfs\process\subproc.cpp @ 444]
00000036`da2af100 000007f8`e62247e4 sqldk!SOS_Task::Param::Execute(class SOS_Task * pTask = 0x000000fb`8f521088, void ** ppExitValue = 0x000000fb`8f521110)+0x21e [d:\sql12_main_t\sql\common\dk\sos\include\sos.inl @ 8769]
00000036`da2af700 000007f8`e62244b6 sqldk!SOS_Scheduler::RunTask(class Worker * pWorker = 0x000000b1`4861c160)+0xa8 [d:\sql12_main_t\sql\common\dk\sos\src\scheduler.cpp @ 995]
00000036`da2af770 000007f8`e624442f sqldk!SOS_Scheduler::ProcessTasks(class SOS_Scheduler * pScheduler = 0x00000019`7f5a0040, class Worker * pCurrentWorker = 0x000000b1`4861c160)+0x279 [d:\sql12_main_t\sql\common\dk\sos\src\scheduler.cpp @ 871]
00000036`da2af7f0 000007f8`e6244bc0 sqldk!SchedulerManager::WorkerEntryPoint(class Worker * pWorker = 0x000000b1`4861c160)+0x24c [d:\sql12_main_t\sql\common\dk\sos\src\node.cpp @ 1854]
00000036`da2af890 000007f8`e6244a86 sqldk!SystemThread::RunWorker(class Worker * pWorker = 0x000000b1`4861c160)+0x8f [d:\sql12_main_t\sql\common\dk\sos\include\worker.inl @ 828]
00000036`da2af8c0 000007f8`e6244869 sqldk!SystemThreadDispatcher::ProcessWorker(class SystemThread * pSysThread = 0x000007f6`62d57508)+0x3ab [d:\sql12_main_t\sql\common\dk\sos\src\node.cpp @ 449]
00000036`da2af970 000007f8`f4631842 sqldk!SchedulerManager::ThreadEntryPoint(void * pParams = 0x00000019`7f480158)+0x226 [d:\sql12_main_t\sql\common\dk\sos\src\node.cpp @ 2067]
00000036`da2afa10 000007f8`f65fd609 kernel32!BaseThreadInitThunk(unsigned long RunProcessInit = <Value unavailable error>, <function> * StartAddress = <Value unavailable error>, void * Argument = <Value unavailable error>)+0x1a [d:\win8_gdr\base\win32\client\thread.c @ 65]
00000036`da2afa40 00000000`00000000 ntdll!RtlUserThreadStart(<function> * StartAddress = 0x00000000`00000000, void * Argument = 0x00000000`00000000)+0x1d [d:\win8_gdr\minkernel\ntdll\rtlstrt.c @ 1021]
Stack Thread 216
=======================================
0:216> kL
Child-SP RetAddr Call Site
000000b4`d3f2d818 000007f8`f35910ea ntdll!ZwWaitForSingleObject+0xa
000000b4`d3f2d820 000007f8`e622184e KERNELBASE!WaitForSingleObjectEx+0x92
000000b4`d3f2d8c0 000007f8`e6221ccd sqldk!SOS_Scheduler::SwitchContext+0x323
000000b4`d3f2db60 000007f8`e6223894 sqldk!SOS_Scheduler::SuspendNonPreemptive+0xd2
(Inline Function) --------`-------- sqldk!SOS_Scheduler::Suspend+0x20
000000b4`d3f2dba0 000007f8`e624a3e4 sqldk!EventInternal<SuspendQueueSLock>::Wait+0x2be
(Inline Function) --------`-------- sqldk!SOS_WaitableAddress::Wait+0x12
000000b4`d3f2dbf0 000007f8`e940fa00 sqldk!SOS_Task::WaitForDone+0xa0
000000b4`d3f2dc80 000007f8`e942242c sqlmin!SubprocessMgr::AbortAndWaitForSubprocs+0x17e
000000b4`d3f2dd10 000007f8`e9422392 sqlmin!CQueryInstance::AbortSubprocsAndWait+0x9d
000000b4`d3f2dd50 000007f8`e9422b4e sqlmin!CQueryInstance::AbortSubprocess+0x164
000000b4`d3f2ddb0 000007f8`e9422f74 sqlmin!CQueryInstance::ShutdownParallel+0x2e
000000b4`d3f2de10 000007f8`e71c3ca1 sqlmin!CQueryScan::DestroyQuery+0x72
000000b4`d3f2de60 000007f8`e70a319b sqllang!CXStmtQuery::ShutdownNormal+0xf3
000000b4`d3f2de90 000007f8`e70a3a4d sqllang!CXStmtQuery::ErsqExecuteQuery+0xcf7
(Inline Function) --------`-------- sqllang!CXStmtSelect::XretDoExecute+0xb3
000000b4`d3f2e020 000007f8`e709dad8 sqllang!CXStmtSelect::XretExecute+0x2e7
(Inline Function) --------`-------- sqllang!CExecStmtLoopVars::ExecuteXStmtAndSetXretReturn+0xf
000000b4`d3f2e0f0 000007f8`e709eaab sqllang!CMsqlExecContext::ExecuteStmts<1,1>+0x427
000000b4`d3f2e230 000007f8`e709e1de sqllang!CMsqlExecContext::FExecute+0xa33
000000b4`d3f2e420 000007f8`e70a80e7 sqllang!CSQLSource::Execute+0x86c
000000b4`d3f2e5f0 000007f8`e70b6607 sqllang!process_request+0xa57
000000b4`d3f2edb0 000007f8`e6224a00 sqllang!process_commands+0x4a3
000000b4`d3f2f0d0 000007f8`e62247e4 sqldk!SOS_Task::Param::Execute+0x21e
000000b4`d3f2f6d0 000007f8`e62244b6 sqldk!SOS_Scheduler::RunTask+0xa8
000000b4`d3f2f740 000007f8`e624442f sqldk!SOS_Scheduler::ProcessTasks+0x279
000000b4`d3f2f7c0 000007f8`e6244bc0 sqldk!SchedulerManager::WorkerEntryPoint+0x24c
000000b4`d3f2f860 000007f8`e6244a86 sqldk!SystemThread::RunWorker+0x8f
000000b4`d3f2f890 000007f8`e6244869 sqldk!SystemThreadDispatcher::ProcessWorker+0x3ab
000000b4`d3f2f940 000007f8`f4631842 sqldk!SchedulerManager::ThreadEntryPoint+0x226
000000b4`d3f2f9e0 000007f8`f65fd609 kernel32!BaseThreadInitThunk+0x1a
000000b4`d3f2fa10 00000000`00000000 ntdll!RtlUserThreadStart+0x1d
Status
Microsoft har bekreftet at dette er et problem i Microsoft-produktene som er oppført i delen "Gjelder for".
Forfatter: yuhua
Tekstforfatter: v-juwang
Teknisk redaktør: ericbu; jayc; OLAMER; yuhua
Editor: v-xhua