Korriger: "ingen unntak bør være hevet koden" feil når du kjører parallelt spørringen i SQL Server-2014

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

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

Trenger du mer hjelp?

Utvid ferdighetene dine
Utforsk opplæring
Vær først ute med de nye funksjonene
Bli med i Microsoft Insiders

Var denne informasjonen nyttig?

Takk for tilbakemeldingen!

Takk for tilbakemeldingen! Det høres ut som det kan være lurt å sette deg i kontakt med én av våre Office-kundestøtteagenter.

×