Popravak: DROP_ASYMMETRIC_KEY uzrokuje instanca SQL Server krah ako ga je vraćen iz okidača

Bug #: 12337261 (sqlbuvsts01)
Bug #: 11708399 (sqlbuvsts01)
Bug #: 90567 (Content Idea)
Bug #: 81981 (Content Idea)

Simptomi

Pretpostavi koristiti SQL iskaz stvaranje OKIDAČA < trigger_name > Dalje baze podataka za DROP_ASYMMETRIC_KEY kao VRAĆANJE za stvaranje okidača baze podataka da biste spriječili ASIMETRIČNA KLJUČ koji se prekine. Međutim, ako se prekine asimetrična ključ, možete primiti sljedeću poruku o pogrešci:

Poruka 64, razina 20, stanje 0, redak LineNumber Došlo je do pogreške prijevoza razinu prilikom primanja rezultata s poslužitelja. (davatelja: TCP davatelja, pogreška: 0 - navedeni mrežni naziv više nije dostupna.)

Uz to, kada prekida instance SQL Server datoteke s izvatkom je generiran u zapisnik MAPI pogreška SQL Server i datoteku zapisnika pogreška SQL Server je prijavljen poruku sličnu sljedećoj:

Pogreška: 1203, ozbiljnosti: 20, stanje: 1 Obradi ID 62 pokušali otključati resursa vlasnik: LockRef 0x000000A0CA2B89C0... Ponovno transakciju, jer uzrok te pogreške možda biti tempiranje uvjet. Ako se problem nastavi, obratite se administratoru baze podataka. Pogreška: 1203, ozbiljnosti: 20, stanje: 1. Obradi ID 62 pokušali otključati resursa vlasnik: LockRef 0x000000A0CA2B89C0... Ponovno transakciju, jer uzrok te pogreške možda biti tempiranje uvjet. Ako se problem nastavi, obratite se administratoru baze podataka. ex_terminator: prekid moguće zbog iznimka tijekom unwinding snop. Pomoću verzije 'dbghelp.dll' '4.0.5' ** Izvadaka nit - spid = 0, EC = 0x000000A0B70F5730 Izvadak stoga šalje FilePath\FileName * ******************************************************************************* * * IZVADAK STOGA POČETAK: Datum vrijeme spid 62 * * ex_terminator - zadnji rukovanje iznimka izgledi * Ulazni međuspremnik 86 bajtova- * ISPUSTI ASIMETRIČNA KLJUČ image_keys11 *

Rješenje

Ovaj popravak je obuhvaćen sljedećih kumulativna ažuriranja za SQL Server:

       Kumulativno ažuriranje 7 za SQL Server 2017

       Kumulativno ažuriranje 3 za SQL Server 2016 SP2

O izgradi SQL Server

Svaki novi međuverzije za SQL Server 2017 sadrži sve hitne popravke i sigurnosna popravke koji su u prethodnu međuverziju. Preporučujemo da instalirate ažuran za verziju sustava SQL Server:

ažuran za SQL Server 2017

Najnovijim kumulativnim ažuriranjem za SQL Server 2016

Status

Microsoft je potvrdio da se taj problem pojavljuje u Microsoftovim proizvodima navedenima u odjeljku "Odnosi se na".

Stack dump

0:000> knL100

# Child-SP          RetAddr           Call Site

00 000000ae`c10e58d8 00007ffa`7aed1118 ntdll!ZwWaitForSingleObject+0xa

01 000000ae`c10e58e0 00007ff6`b27b038f KERNELBASE!WaitForSingleObjectEx+0x94

02 000000ae`c10e5980 00007ff6`b27b00a2 sqlservr!CDmpDump::DumpInternal+0x2bf

03 000000ae`c10e5a80 00007ff6`b27baaf8 sqlservr!CDmpDump::DumpFilter+0xc2

04 000000ae`c10e5b70 00007ffa`6fe6f2cb sqlservr!`CDmpDump::Dump'::`1'::filt$0+0x19

05 000000ae`c10e5ba0 00007ffa`7daa349d msvcr120!__C_specific_handler+0x93

06 000000ae`c10e5c10 00007ffa`7da648d7 ntdll!RtlpExecuteHandlerForException+0xd

07 000000ae`c10e5c40 00007ffa`7da63afd ntdll!RtlDispatchException+0x197

08 000000ae`c10e6310 00007ffa`7aed92fc ntdll!RtlRaiseException+0x18d

09 000000ae`c10e6ad0 00007ff6`b27affcc KERNELBASE!RaiseException+0x68

0a 000000ae`c10e6bb0 00007ffa`69f2520d sqlservr!CDmpDump::Dump+0x4c

0b 000000ae`c10e6bf0 00007ffa`6abc6881 sqllang!SQLDumperLibraryInvoke+0x1cd

0c 000000ae`c10e6c30 00007ffa`6abc7334 sqllang!SQLLangDumperLibraryInvoke+0x171

0d 000000ae`c10e6cf0 00007ffa`6ab9157e sqllang!CImageHelper::DoMiniDump+0x4a5

0e 000000ae`c10e6f00 00007ffa`69f25349 sqllang!stackTrace+0x99e

0f 000000ae`c10e8930 00007ffa`68e0ca1f sqllang!stackTraceCallBack+0x99

10 000000ae`c10e8980 00007ffa`6fe5d0e7 sqldk!ex_terminator+0x8f

11 000000ae`c10e8c10 00007ffa`6fe5e922 msvcr120!terminate+0x17

12 000000ae`c10e8c40 00007ffa`6fea7212 msvcr120!__FrameUnwindFilter+0x52

13 000000ae`c10e8c70 00007ffa`6fe6f2cb msvcr120!__FrameUnwindToState$filt$0+0xe

14 000000ae`c10e8ca0 00007ffa`7daa349d msvcr120!__C_specific_handler+0x93

15 000000ae`c10e8d10 00007ffa`7da648d7 ntdll!RtlpExecuteHandlerForException+0xd

16 000000ae`c10e8d40 00007ffa`7da63afd ntdll!RtlDispatchException+0x197

17 000000ae`c10e9410 00007ffa`7aed92fc ntdll!RtlRaiseException+0x18d

18 000000ae`c10e9bd0 00007ffa`6fe5ef53 KERNELBASE!RaiseException+0x68

19 000000ae`c10e9cb0 00007ffa`68dccec7 msvcr120!_CxxThrowException+0xb3

1a 000000ae`c10e9d20 00007ffa`68dccb40 sqldk!TurnUnwindAndThrowImpl+0x37f

1b (Inline Function) --------`-------- sqldk!SOS_OS::TurnUnwindAndThrow+0xc

1c 000000ae`c10e9f00 00007ffa`68dcc80a sqldk!ex_raise2+0x4fb

1d 000000ae`c10ea230 00007ffa`6d655671 sqldk!ex_raise+0xc4

1e 000000ae`c10ea2b0 00007ffa`6d652bf0 sqlmin!reportReferenceUnlockFailure+0xb2

1f 000000ae`c10ea510 00007ffa`6c35eca3 sqlmin!LockReference::Release+0xe7

20 (Inline Function) --------`-------- sqlmin!RowsetLockCache::ReleaseLockInCache+0xffffffff`ffffa6e6

21 (Inline Function) --------`-------- sqlmin!RowsetLockCache::ReleaseLockFromCache+0xffffffff`ff0964bd

22 (Inline Function) --------`-------- sqlmin!RowsetLockCache::ReleaseLock+0xffffffff`ffffda4d

23 (Inline Function) --------`-------- sqlmin!XDES::ReleaseHoBtLock+0xffffffff`ffffda5f

24 000000ae`c10ea660 00007ffa`6c36100d sqlmin!IndexDataSetSession::GoDormantInternal+0x4f9

25 000000ae`c10ea6d0 00007ffa`6c362afa sqlmin!DatasetSession::GoDormant+0x1d

26 (Inline Function) --------`-------- sqlmin!RowsetNewSS::ReleaseResources+0xe

27 000000ae`c10ea700 00007ffa`6c3682d2 sqlmin!RowsetNewSS::GoDormant+0x8e

28 (Inline Function) --------`-------- sqlmin!ReleaseSystemTableRowset+0x1d

29 000000ae`c10ea770 00007ffa`6c39bea7 sqlmin!CMEDScanBase::ReleaseRowsets+0x51

2a (Inline Function) --------`-------- sqlmin!CMEDScan::ReleaseScan+0x7

2b 000000ae`c10ea7c0 00007ffa`6c86eafe sqlmin!CMEDScan::~CMEDScan+0x27

2c (Inline Function) --------`-------- sqlmin!CMIterThumbprints::{dtor}+0x2c

2d 000000ae`c10ea800 00007ffa`6fe66920 sqlmin!CMIterThumbprints::`scalar deleting destructor'+0x4e

2e 000000ae`c10ea840 00007ffa`6fe5ea3a msvcr120!_CallSettingFrame+0x20

2f 000000ae`c10ea870 00007ffa`6fe5f1e1 msvcr120!__FrameUnwindToState+0x116

30 000000ae`c10ea8e0 00007ffa`6fe5ec6d msvcr120!__FrameUnwindToEmptyState+0x81

31 000000ae`c10ea920 00007ffa`6fe5f5c7 msvcr120!__InternalCxxFrameHandler+0x121

32 000000ae`c10ea980 00007ffa`69c16abe msvcr120!__CxxFrameHandler+0x77

33 000000ae`c10ea9d0 00007ffa`7daa351d sqllang!__GSHandlerCheck_EH+0x6e

34 000000ae`c10eaa00 00007ffa`7da65495 ntdll!RtlpExecuteHandlerForUnwind+0xd

35 000000ae`c10eaa30 00007ffa`6fe5f535 ntdll!RtlUnwindEx+0x385

36 000000ae`c10eb110 00007ffa`6fe5d648 msvcr120!_UnwindNestedFrames+0x109

37 000000ae`c10eb6d0 00007ffa`6fe5d9b7 msvcr120!CatchIt+0xa8

38 000000ae`c10eb750 00007ffa`6fe5ed54 msvcr120!FindHandler+0x353

39 000000ae`c10eb840 00007ffa`6fe5f5c7 msvcr120!__InternalCxxFrameHandler+0x208

3a 000000ae`c10eb8a0 00007ffa`69c16abe msvcr120!__CxxFrameHandler+0x77

3b 000000ae`c10eb8f0 00007ffa`7daa349d sqllang!__GSHandlerCheck_EH+0x6e

3c 000000ae`c10eb920 00007ffa`7da648d7 ntdll!RtlpExecuteHandlerForException+0xd

3d 000000ae`c10eb950 00007ffa`7da63afd ntdll!RtlDispatchException+0x197

3e 000000ae`c10ec020 00007ffa`7aed92fc ntdll!RtlRaiseException+0x18d

3f 000000ae`c10ec7e0 00007ffa`6fe5ef53 KERNELBASE!RaiseException+0x68

40 000000ae`c10ec8c0 00007ffa`68dccec7 msvcr120!_CxxThrowException+0xb3

41 000000ae`c10ec930 00007ffa`68dccb40 sqldk!TurnUnwindAndThrowImpl+0x37f

42 (Inline Function) --------`-------- sqldk!SOS_OS::TurnUnwindAndThrow+0xc

43 000000ae`c10ecb10 00007ffa`68e0d12f sqldk!ex_raise2+0x4fb

44 000000ae`c10ece40 00007ffa`6a4a3503 sqldk!ex_raisecontrol+0xef

45 000000ae`c10ecea0 00007ffa`6a4965f4 sqllang!CXStmtDDL::FExecuteAllTriggers+0x4a3

46 000000ae`c10ecff0 00007ffa`6a496076 sqllang!LpeEvents::FFireDDLEvent+0x555

47 000000ae`c10ed9e0 00007ffa`6a498d8d sqllang!LpeEvents::FFireDDLEvent+0x206

48 000000ae`c10edae0 00007ffa`6a9d2fa8 sqllang!PostCryptoDDLEvent+0x1cd

49 000000ae`c10edbd0 00007ffa`69bf4290 sqllang!CStmtDropAsymKey::XretExecute+0x7e8

4a (Inline Function) --------`-------- sqllang!CExecStmtLoopVars::ExecuteXStmtAndSetXretReturn+0xf

4b 000000ae`c10edd80 00007ffa`69bf4c13 sqllang!CMsqlExecContext::ExecuteStmts<1,1>+0x4c5

4c 000000ae`c10eded0 00007ffa`69bf3d14 sqllang!CMsqlExecContext::FExecute+0xaae

4d 000000ae`c10ee200 00007ffa`69bfdf95 sqllang!CSQLSource::Execute+0xa2c

4e 000000ae`c10ee510 00007ffa`69bfb6d2 sqllang!process_request+0xe29

4f 000000ae`c10eeb30 00007ffa`69bfb7d3 sqllang!process_commands_internal+0x289

50 000000ae`c10eebf0 00007ffa`68db4e7d sqllang!process_messages+0x213

51 000000ae`c10eee10 00007ffa`68db5378 sqldk!SOS_Task::Param::Execute+0x231

52 000000ae`c10ef410 00007ffa`68db4fed sqldk!SOS_Scheduler::RunTask+0xad

53 000000ae`c10ef480 00007ffa`68de0c38 sqldk!SOS_Scheduler::ProcessTasks+0x3cd

54 000000ae`c10ef570 00007ffa`68de0d30 sqldk!SchedulerManager::WorkerEntryPoint+0x2a1

55 000000ae`c10ef640 00007ffa`68de0857 sqldk!SystemThread::RunWorker+0x8f

56 000000ae`c10ef670 00007ffa`68de1049 sqldk!SystemThreadDispatcher::ProcessWorker+0x2e7

57 000000ae`c10ef710 00007ffa`7bf013d2 sqldk!SchedulerManager::ThreadEntryPoint+0x1d8

58 000000ae`c10ef7c0 00007ffa`7da254f4 kernel32!BaseThreadInitThunk+0x22

59 000000ae`c10ef7f0 00000000`00000000 ntdll!RtlUserThreadStart+0x34

Reference

Saznajte više o standardnoj terminologiji Microsoft koristi za opisivanje softverskih ažuriranja.

KE: huirzhou;
Author:
Writer: v-thomr
Tech Reviewer: sqlprev; daleche; sanat; virana; petan; v-fmeng; huirzhou;
Editor: v-jeffbo

Potrebna vam je dodatna pomoć?

Proširite svoje vještine
Istražite osposobljavanje
Prvi koristite nove značajke
Pridružite se Microsoft Insidere

Jesu li ove informacije bile korisne?

Hvala vam na povratnim informacijama!

Hvala vam na povratnim informacijama! Čini se da bi vam pomoglo kad bismo vas povezali s nekim od naših agenata podrške za Office.

×