locked
Database xxx was shutdown due to error 3624 in routine 'XdesRMFull::Rollback' RRS feed

  • Question

  • Found that AllwaysOn AG connection was terminated and again reconnected for a particular DB. The DB shutdown with error 3624 in routine 'XdesRMFull::Rollback'. Ran DBCC CHECKDB on the DB didn't found any errors both on primary and secondary. A stack dump got created showing an SPID. Not able to figure out the root cause of the issue and not able to regenerate the same. 

    This is log file...

    2016-12-15 23:55:48.670 spid371      **Dump thread - spid = 0, EC = 0x000000BDD412F940
    2016-12-15 23:55:48.670 spid371      ***Stack Dump being sent to D:\Microsoft SQL Server\MSSQL13.server3\MSSQL\LOG\SQLDump0003.txt
    2016-12-15 23:55:48.670 spid371      * *******************************************************************************
    2016-12-15 23:55:48.670 spid371      *
    2016-12-15 23:55:48.670 spid371      * BEGIN STACK DUMP:
    2016-12-15 23:55:48.670 spid371      *   12/15/16 23:55:48 spid 371
    2016-12-15 23:55:48.670 spid371      *
    2016-12-15 23:55:48.670 spid371      * Location: d:\b\s2\sources\sql\ntdbms\storeng\include\xact.h:784
    2016-12-15 23:55:48.670 spid371      * Expression: 0
    2016-12-15 23:55:48.670 spid371      * SPID: 371
    2016-12-15 23:55:48.670 spid371      * Process ID: 3120
    2016-12-15 23:55:48.670 spid371      *
    2016-12-15 23:55:48.670 spid371      * Input Buffer 214 bytes -
    2016-12-15 23:55:48.670 spid371      *         ?   spProcedure;50 '12/15/2016', 'Hybrid Pricepoint MD b
    2016-12-15 23:55:48.670 spid371      *  y Category Effective 12/16/16', '0'
    2016-12-15 23:55:48.670 spid371      *  
    2016-12-15 23:55:48.670 spid371      *
    2016-12-15 23:55:48.670 spid371      *  MODULE                          BASE      END       SIZE
    2016-12-15 23:55:48.670 spid371      * sqlservr                       00007FF759CA0000  00007FF759D07FFF  00068000
    2016-12-15 23:55:48.670 spid371      * ntdll                          00007FFD3C7D0000  00007FFD3C97CFFF  001ad000
    2016-12-15 23:55:48.670 spid371      * KERNEL32                       00007FFD3C420000  00007FFD3C55DFFF  0013e000
    2016-12-15 23:55:48.670 spid371      * KERNELBASE                     00007FFD39D10000  00007FFD39E24FFF  00115000
    2016-12-15 23:55:48.670 spid371      * NETAPI32                       00007FFD365B0000  00007FFD365C5FFF  00016000
    2016-12-15 23:55:48.670 spid371      * pdh                            00007FFD34110000  00007FFD3415EFFF  0004f000
    2016-12-15 23:55:48.670 spid371      * ADVAPI32                       00007FFD3C560000  00007FFD3C609FFF  000aa000
    2016-12-15 23:55:48.670 spid371      * ole32                          00007FFD3BFE0000  00007FFD3C173FFF  00194000
    2016-12-15 23:55:48.670 spid371      * SQLOS                          00007FFD34BA0000  00007FFD34BA6FFF  00007000
    2016-12-15 23:55:48.670 spid371      * sqlmin                         00007FFD2AF80000  00007FFD2D40CFFF  0248d000
    2016-12-15 23:55:48.670 spid371      * sqllang                        00007FFD289E0000  00007FFD2AF72FFF  02593000
    2016-12-15 23:55:48.670 spid371      * sqlTsEs                        00007FFD28150000  00007FFD289DAFFF  0088b000
    2016-12-15 23:55:48.670 spid371      * sqldk                          00007FFD27C80000  00007FFD28146FFF  004c7000
    2016-12-15 23:55:48.670 spid371      * opends60                       00007FFD2D920000  00007FFD2D928FFF  00009000
    2016-12-15 23:55:48.670 spid371      * qds                            00007FFD2D840000  00007FFD2D91BFFF  000dc000
    2016-12-15 23:55:48.670 spid371      * MSVCP120                       00007FFD2F630000  00007FFD2F6D5FFF  000a6000
    2016-12-15 23:55:48.670 spid371      * MSVCR120                       00007FFD2F6E0000  00007FFD2F7CEFFF  000ef000
    2016-12-15 23:55:48.670 spid371      * netutils                       00007FFD37D80000  00007FFD37D8BFFF  0000c000
    2016-12-15 23:55:48.670 spid371      * srvcli                         00007FFD39510000  00007FFD39535FFF  00026000
    2016-12-15 23:55:48.670 spid371      * wkscli                         00007FFD37D90000  00007FFD37DA6FFF  00017000
    2016-12-15 23:55:48.670 spid371      * msvcrt                         00007FFD3BC80000  00007FFD3BD29FFF  000aa000
    2016-12-15 23:55:48.670 spid371      * RPCRT4                         00007FFD3BD30000  00007FFD3BE6FFFF  00140000
    2016-12-15 23:55:48.670 spid371      * sechost                        00007FFD3C1E0000  00007FFD3C238FFF  00059000
    2016-12-15 23:55:48.670 spid371      * combase                        00007FFD39ED0000  00007FFD3A0E0FFF  00211000
    2016-12-15 23:55:48.670 spid371      * GDI32                          00007FFD3C680000  00007FFD3C7CEFFF  0014f000
    2016-12-15 23:55:48.670 spid371      * USER32                         00007FFD3C240000  00007FFD3C3B6FFF  00177000
    2016-12-15 23:55:48.670 spid371      * CRYPT32                        00007FFD39AD0000  00007FFD39CAEFFF  001df000
    2016-12-15 23:55:48.670 spid371      * Secur32                        00007FFD38C90000  00007FFD38C9BFFF  0000c000
    2016-12-15 23:55:48.670 spid371      * WS2_32                         00007FFD3C180000  00007FFD3C1D9FFF  0005a000
    2016-12-15 23:55:48.670 spid371      * WINHTTP                        00007FFD34030000  00007FFD340F6FFF  000c7000
    2016-12-15 23:55:48.670 spid371      * bcrypt                         00007FFD393F0000  00007FFD39415FFF  00026000
    2016-12-15 23:55:48.670 spid371      * OLEAUT32                       00007FFD3A2F0000  00007FFD3A3B0FFF  000c1000
    2016-12-15 23:55:48.670 spid371      * ODBC32                         00007FFD2EE80000  00007FFD2EF41FFF  000c2000
    2016-12-15 23:55:48.670 spid371      * USERENV                        00007FFD38EB0000  00007FFD38ED0FFF  00021000
    2016-12-15 23:55:48.670 spid371      * AUTHZ                          00007FFD38BA0000  00007FFD38BE7FFF  00048000
    2016-12-15 23:55:48.670 spid371      * WINTRUST                       00007FFD39CB0000  00007FFD39D00FFF  00051000
    2016-12-15 23:55:48.670 spid371      * XmlLite                        00007FFD36020000  00007FFD36058FFF  00039000
    2016-12-15 23:55:48.670 spid371      * dhcpcsvc                       00007FFD35B80000  00007FFD35B99FFF  0001a000
    2016-12-15 23:55:48.670 spid371      * WINMM                          00007FFD2D810000  00007FFD2D831FFF  00022000
    2016-12-15 23:55:48.670 spid371      * SspiCli                        00007FFD39E30000  00007FFD39E5DFFF  0002e000
    2016-12-15 23:55:48.670 spid371      * MSASN1                         00007FFD399B0000  00007FFD399C0FFF  00011000
    2016-12-15 23:55:48.670 spid371      * NSI                            00007FFD39E60000  00007FFD39E68FFF  00009000
    2016-12-15 23:55:48.670 spid371      * profapi                        00007FFD39900000  00007FFD39914FFF  00015000
    2016-12-15 23:55:48.670 spid371      * WINMMBASE                      00007FFD2D7E0000  00007FFD2D809FFF  0002a000
    2016-12-15 23:55:48.670 spid371      * LOGONCLI                       00007FFD38EE0000  00007FFD38F1EFFF  0003f000
    2016-12-15 23:55:48.670 spid371      * cfgmgr32                       00007FFD39A80000  00007FFD39ACEFFF  0004f000
    2016-12-15 23:55:48.670 spid371      * DEVOBJ                         00007FFD38780000  00007FFD387A7FFF  00028000
    2016-12-15 23:55:48.670 spid371      * SAMCLI                         00007FFD34180000  00007FFD34196FFF  00017000
    2016-12-15 23:55:48.670 spid371      * psapi                          00007FFD3BE70000  00007FFD3BE76FFF  00007000
    2016-12-15 23:55:48.670 spid371      * kernel.appcore                 00007FFD385A0000  00007FFD385AAFFF  0000b000
    2016-12-15 23:55:48.670 spid371      * CRYPTBASE                      00007FFD39770000  00007FFD3977AFFF  0000b000
    2016-12-15 23:55:48.670 spid371      * bcryptPrimitives               00007FFD39700000  00007FFD39762FFF  00063000
    2016-12-15 23:55:48.670 spid371      * instapi130                     00007FFD34020000  00007FFD3402FFFF  00010000
    2016-12-15 23:55:48.670 spid371      * CRYPTSP                        00007FFD39300000  00007FFD3931FFFF  00020000
    2016-12-15 23:55:48.670 spid371      * rsaenh                         00007FFD38DE0000  00007FFD38E15FFF  00036000
    2016-12-15 23:55:48.670 spid371      * imagehlp                       00007FFD3A2C0000  00007FFD3A2D5FFF  00016000
    2016-12-15 23:55:48.670 spid371      * ncrypt                         00007FFD393C0000  00007FFD393E4FFF  00025000
    2016-12-15 23:55:48.670 spid371      * NTASN1                         00007FFD39380000  00007FFD393B6FFF  00037000
    2016-12-15 23:55:48.670 spid371      * gpapi                          00007FFD38AF0000  00007FFD38B13FFF  00024000
    2016-12-15 23:55:48.670 spid371      * cscapi                         00007FFD2D7C0000  00007FFD2D7D1FFF  00012000
    2016-12-15 23:55:48.670 spid371      * sqlevn70                       00007FFD27990000  00007FFD27C7CFFF  002ed000
    2016-12-15 23:55:48.670 spid371      * CLUSAPI                        00007FFD35B10000  00007FFD35B7DFFF  0006e000
    2016-12-15 23:55:48.670 spid371      * cryptdll                       00007FFD39320000  00007FFD39339FFF  0001a000
    2016-12-15 23:55:48.670 spid371      * RESUTILS                       00007FFD35AC0000  00007FFD35B0BFFF  0004c000
    2016-12-15 23:55:48.670 spid371      * VERSION                        00007FFD34890000  00007FFD34899FFF  0000a000
    2016-12-15 23:55:48.670 spid371      * hkruntime                      00007FFD27220000  00007FFD274F0FFF  002d1000
    2016-12-15 23:55:48.670 spid371      * hkcompile                      00007FFD270D0000  00007FFD27211FFF  00142000
    2016-12-15 23:55:48.670 spid371      * hkengine                       00007FFD26B60000  00007FFD270CAFFF  0056b000
    2016-12-15 23:55:48.670 spid371      * dbghelp                        000000006A580000  000000006A715FFF  00196000
    2016-12-15 23:55:48.670 spid371      * SHLWAPI                        00007FFD3C3C0000  00007FFD3C413FFF  00054000
    2016-12-15 23:55:48.670 spid371      * pcwum                          00007FFD38B30000  00007FFD38B3DFFF  0000e000
    2016-12-15 23:55:48.670 spid371      * msv1_0                         00007FFD390B0000  00007FFD3911DFFF  0006e000
    2016-12-15 23:55:48.670 spid371      * kerberos                       00007FFD39180000  00007FFD39277FFF  000f8000
    2016-12-15 23:55:48.670 spid371      * schannel                       00007FFD38D70000  00007FFD38DDCFFF  0006d000
    2016-12-15 23:55:48.670 spid371      * MSCOREE                        00007FFD33150000  00007FFD331B3FFF  00064000
    2016-12-15 23:55:48.670 spid371      * mscoreei                       00007FFD32D40000  00007FFD32DD7FFF  00098000
    2016-12-15 23:55:48.670 spid371      * SqlServerSpatial130            00007FFD24BE0000  00007FFD24C91FFF  000b2000
    2016-12-15 23:55:48.670 spid371      * security                       00007FFD26660000  00007FFD26662FFF  00003000
    2016-12-15 23:55:48.670 spid371      * clbcatq                        00007FFD3A1C0000  00007FFD3A275FFF  000b6000
    2016-12-15 23:55:48.670 spid371      * sqlncli11                      00007FFD231F0000  00007FFD23542FFF  00353000
    2016-12-15 23:55:48.670 spid371      * MSVCR100                       000000006A430000  000000006A501FFF  000d2000
    2016-12-15 23:55:48.670 spid371      * COMCTL32                       00007FFD23140000  00007FFD231E3FFF  000a4000
    2016-12-15 23:55:48.670 spid371      * COMDLG32                       00007FFD3A100000  00007FFD3A1B5FFF  000b6000
    2016-12-15 23:55:48.670 spid371      * SHELL32                        00007FFD3A750000  00007FFD3BC78FFF  01529000
    2016-12-15 23:55:48.670 spid371      * SHCORE                         00007FFD38230000  00007FFD382E1FFF  000b2000
    2016-12-15 23:55:48.670 spid371      * SQLNCLIR11                     000000006A3F0000  000000006A427FFF  00038000
    2016-12-15 23:55:48.670 spid371      * DPAPI                          00007FFD38C80000  00007FFD38C89FFF  0000a000
    2016-12-15 23:55:48.670 spid371      * netbios                        00007FFD23130000  00007FFD2313AFFF  0000b000
    2016-12-15 23:55:48.670 spid371      * sqlnclirda11                   000000006A090000  000000006A3E8FFF  00359000
    2016-12-15 23:55:48.670 spid371      * SQLNCLIRDAR11                  000000006A050000  000000006A087FFF  00038000
    2016-12-15 23:55:48.670 spid371      * clr                            00007FFD32370000  00007FFD32CCBFFF  0095c000
    2016-12-15 23:55:48.670 spid371      * MSVCR120_CLR0400               00007FFD32270000  00007FFD32366FFF  000f7000
    2016-12-15 23:55:48.670 spid371      * mscorlib.ni                    00007FFD30D40000  00007FFD321D7FFF  01498000
    2016-12-15 23:55:48.670 spid371      * clrjit                         00007FFD2F7F0000  00007FFD2F8F4FFF  00105000
    2016-12-15 23:55:48.670 spid371      * BatchParser                    00007FFD22B80000  00007FFD22BABFFF  0002c000
    2016-12-15 23:55:48.670 spid371      * perfcounter                    00007FFD230E0000  00007FFD2311CFFF  0003d000
    2016-12-15 23:55:48.670 spid371      * DNSAPI                         00007FFD38F20000  00007FFD38FC3FFF  000a4000
    2016-12-15 23:55:48.670 spid371      * MSDTCPRX                       00007FFD22F40000  00007FFD2301BFFF  000dc000
    2016-12-15 23:55:48.670 spid371      * MTXCLU                         00007FFD22ED0000  00007FFD22F36FFF  00067000
    2016-12-15 23:55:48.670 spid371      * ktmw32                         00007FFD353B0000  00007FFD353BAFFF  0000b000
    2016-12-15 23:55:48.670 spid371      * ntmarta                        00007FFD352E0000  00007FFD35311FFF  00032000
    2016-12-15 23:55:48.670 spid371      * BROWCLI                        00007FFD24E00000  00007FFD24E12FFF  00013000
    2016-12-15 23:55:48.670 spid371      * rasman                         00007FFD36E10000  00007FFD36E3FFFF  00030000
    2016-12-15 23:55:48.670 spid371      * IPHLPAPI                       00007FFD35FB0000  00007FFD35FD9FFF  0002a000
    2016-12-15 23:55:48.670 spid371      * WINNSI                         00007FFD35920000  00007FFD35929FFF  0000a000
    2016-12-15 23:55:48.670 spid371      * mswsock                        00007FFD39120000  00007FFD39178FFF  00059000
    2016-12-15 23:55:48.670 spid371      * ntdsapi                        00007FFD360A0000  00007FFD360C8FFF  00029000
    2016-12-15 23:55:48.670 spid371      * DSPARSE                        00007FFD22330000  00007FFD2233CFFF  0000d000
    2016-12-15 23:55:48.670 spid371      * ncryptsslp                     00007FFD26490000  00007FFD264ACFFF  0001d000
    2016-12-15 23:55:48.670 spid371      * msxml3                         00007FFD213A0000  00007FFD215E0FFF  00241000
    2016-12-15 23:55:48.670 spid371      * xpsqlbot                       00007FFD34C00000  00007FFD34C07FFF  00008000
    2016-12-15 23:55:48.670 spid371      * xpstar                         00007FFD1FEE0000  00007FFD1FF48FFF  00069000
    2016-12-15 23:55:48.670 spid371      * SQLSCM                         00007FFD21FE0000  00007FFD21FEFFFF  00010000
    2016-12-15 23:55:48.670 spid371      * xpstar                         00007FFD1FED0000  00007FFD1FEDCFFF  0000d000
    2016-12-15 23:55:48.670 spid371      * rasadhlp                       00007FFD358C0000  00007FFD358C9FFF  0000a000
    2016-12-15 23:55:48.670 spid371      * fwpuclnt                       00007FFD35850000  00007FFD358BAFFF  0006b000
    2016-12-15 23:55:48.670 spid371      * SAMLIB                         00007FFD34160000  00007FFD3417EFFF  0001f000
    2016-12-15 23:55:48.670 spid371      * DSROLE                         00007FFD365D0000  00007FFD365D9FFF  0000a000
    2016-12-15 23:55:48.670 spid371      * xprepl                         00007FFD22060000  00007FFD22076FFF  00017000
    2016-12-15 23:55:48.670 spid371      * xplog70                        00007FFD2D950000  00007FFD2D960FFF  00011000
    2016-12-15 23:55:48.670 spid371      * xplog70                        00007FFD38590000  00007FFD38593FFF  00004000
    2016-12-15 23:55:48.670 spid371      * oledb32                        00007FFD21EA0000  00007FFD21F99FFF  000fa000
    2016-12-15 23:55:48.670 spid371      * MSDART                         00007FFD1FE70000  00007FFD1FE94FFF  00025000
    2016-12-15 23:55:48.670 spid371      * comsvcs                        00007FFD1BCD0000  00007FFD1BE7BFFF  001ac000
    2016-12-15 23:55:48.670 spid371      * msdasql                        00007FFD1FD00000  00007FFD1FDB4FFF  000b5000
    2016-12-15 23:55:48.670 spid371      * MSDATL3                        00007FFD1FCD0000  00007FFD1FCF1FFF  00022000
    2016-12-15 23:55:48.670 spid371      * MSDASQLR                       00007FFD37630000  00007FFD3763EFFF  0000f000
    2016-12-15 23:55:48.670 spid371      * SQLSRV32                       00007FFD1FC00000  00007FFD1FCC7FFF  000c8000
    2016-12-15 23:55:48.670 spid371      * odbccp32                       00007FFD1FBD0000  00007FFD1FBF4FFF  00025000
    2016-12-15 23:55:48.670 spid371      * msadce                         00007FFD1FB00000  00007FFD1FB9FFFF  000a0000
    2016-12-15 23:55:48.670 spid371      * msadcer                        00007FFD37000000  00007FFD37001FFF  00002000
    2016-12-15 23:55:48.670 spid371      * COMRES                         00007FFD1DF10000  00007FFD1E04DFFF  0013e000
    2016-12-15 23:55:48.670 spid371      * XOLEHLP                        00007FFD2EF50000  00007FFD2EF65FFF  00016000
    2016-12-15 23:55:48.670 spid371      * sqloledb                       00007FFD21DB0000  00007FFD21E9BFFF  000ec000
    2016-12-15 23:55:48.670 spid371      * odsole70                       00007FFD1FE50000  00007FFD1FE67FFF  00018000
    2016-12-15 23:55:48.670 spid371      * scrrun                         00007FFD1F9E0000  00007FFD1FA13FFF  00034000
    2016-12-15 23:55:48.670 spid371      * sxs                            00007FFD397E0000  00007FFD39878FFF  00099000
    2016-12-15 23:55:48.670 spid371      * msodbcsql13                    00007FFD14510000  00007FFD1472AFFF  0021b000
    2016-12-15 23:55:48.670 spid371      * Sort00060101                   00007FFD239D0000  00007FFD239E2FFF  00013000
    2016-12-15 23:55:48.670 spid371      * System.Data                    00007FFD1EB60000  00007FFD1EEACFFF  0034d000
    2016-12-15 23:55:48.670 spid371      * sqlevn70                       00007FFD0AE90000  00007FFD0B21FFFF  00390000
    2016-12-15 23:55:48.670 spid371      * sqlevn70                       00007FFD0AB00000  00007FFD0AE8FFFF  00390000
    2016-12-15 23:55:48.670 spid371      * sqlevn70                       00007FFD0A910000  00007FFD0AAF6FFF  001e7000
    2016-12-15 23:55:48.670 spid371      * sqlevn70                       00007FFD0A5E0000  00007FFD0A90AFFF  0032b000
    2016-12-15 23:55:48.670 spid371      * sqlevn70                       00007FFCFDED0000  00007FFCFE240FFF  00371000
    2016-12-15 23:55:48.670 spid371      * sqlevn70                       00007FFCFDB50000  00007FFCFDEC8FFF  00379000
    2016-12-15 23:55:48.670 spid371      * sqlevn70                       00007FFCFD800000  00007FFCFDB4DFFF  0034e000
    2016-12-15 23:55:48.670 spid371      * sqlevn70                       00007FFCFD4A0000  00007FFCFD7F8FFF  00359000
    2016-12-15 23:55:48.670 spid371      * sqlevn70                       00007FFCFD180000  00007FFCFD490FFF  00311000
    2016-12-15 23:55:48.670 spid371      * sqlevn70                       00007FFCFCE60000  00007FFCFD179FFF  0031a000
    2016-12-15 23:55:48.670 spid371      * sqlevn70                       00007FFCFCB50000  00007FFCFCE50FFF  00301000
    2016-12-15 23:55:48.670 spid371      * sqlevn70                       00007FFCFC7D0000  00007FFCFCB43FFF  00374000
    2016-12-15 23:55:48.670 spid371      * sqlevn70                       00007FFCFC450000  00007FFCFC7C0FFF  00371000
    2016-12-15 23:55:48.670 spid371      * sqlevn70                       00007FFCFC0A0000  00007FFCFC44AFFF  003ab000
    2016-12-15 23:55:48.670 spid371      * sqlevn70                       00007FFCFBD50000  00007FFCFC096FFF  00347000
    2016-12-15 23:55:48.670 spid371      * sqlevn70                       00007FFCFBA50000  00007FFCFBD4DFFF  002fe000
    2016-12-15 23:55:48.670 spid371      * sqlevn70                       00007FFCFB700000  00007FFCFBA43FFF  00344000
    2016-12-15 23:55:48.670 spid371      * sqlevn70                       00007FFD0A480000  00007FFD0A5DCFFF  0015d000
    2016-12-15 23:55:48.670 spid371      * sqlevn70                       00007FFCFB520000  00007FFCFB6F9FFF  001da000
    2016-12-15 23:55:48.670 spid371      * sqlevn70                       00007FFD0A320000  00007FFD0A470FFF  00151000
    2016-12-15 23:55:48.670 spid371      * sqlevn70                       00007FFCFB210000  00007FFCFB519FFF  0030a000
    2016-12-15 23:55:48.670 spid371      * ssdebugps                      00007FFD35E50000  00007FFD35E58FFF  00009000
    2016-12-15 23:55:48.670 spid371      * apphelp                        00007FFD37CF0000  00007FFD37D7DFFF  0008e000
    2016-12-15 23:55:48.670 spid371      * perfdisk                       00007FFD22E00000  00007FFD22E0EFFF  0000f000
    2016-12-15 23:55:48.670 spid371      * WMICLNT                        00007FFD36070000  00007FFD3607EFFF  0000f000
    2016-12-15 23:55:48.670 spid371      * sqlvdi                         00007FFD1A480000  00007FFD1A4B1FFF  00032000
    2016-12-15 23:55:48.670 spid371      * System.ni                      00007FFD2FFD0000  00007FFD30BA1FFF  00bd2000
    2016-12-15 23:55:48.670 spid371      * System.Core.ni                 00007FFD2DAB0000  00007FFD2E43AFFF  0098b000
    2016-12-15 23:55:48.670 spid371      * System.Transactions            00007FFD1EA30000  00007FFD1EA7CFFF  0004d000
    2016-12-15 23:55:48.670 spid371      * System.Security.ni             00007FFD0DA30000  00007FFD0DB0EFFF  000df000
    2016-12-15 23:55:48.670 spid371      * System.Xml.ni                  00007FFD2E470000  00007FFD2ED01FFF  00892000
    2016-12-15 23:55:48.670 spid371      * perfos                         00007FFD2D970000  00007FFD2D97CFFF  0000d000
    2016-12-15 23:55:48.670 spid371      * dbghelp                        0000000069AE0000  0000000069C75FFF  00196000
    2016-12-15 23:55:48.670 spid371      *
    2016-12-15 23:55:48.670 spid371      *     P1Home: 000000C0A217D280:  0000000100000310  FFFFFFFF00000001  FFFFFFFF00000001  000000C0A217DBE0  00007FFD2D3B7A64  000000000000006D  
    2016-12-15 23:55:48.670 spid371      *     P2Home: 0000000000000000:  
    2016-12-15 23:55:48.670 spid371      *     P3Home: 00000074F8F00000:  0000000000000000  01009B177AB9E8E9  00000002FFEEFFEE  00000074FA4B0018  00000074F8F00120  00000074F8F00000  
    2016-12-15 23:55:48.670 spid371      *     P4Home: 0000000000000000:  
    2016-12-15 23:55:48.670 spid371      *     P5Home: 0000000000000000:  
    2016-12-15 23:55:48.670 spid371      *     P6Home: 000000000000000A:  
    2016-12-15 23:55:48.670 spid371      * ContextFlags: 000000000010004F:  
    2016-12-15 23:55:48.670 spid371      *      MxCsr: 0000000000001FA0:  
    2016-12-15 23:55:48.670 spid371      *      SegCs: 0000000000000033:  
    2016-12-15 23:55:48.670 spid371      *      SegDs: 000000000000002B:  
    2016-12-15 23:55:48.670 spid371      *      SegEs: 000000000000002B:  
    2016-12-15 23:55:48.670 spid371      *      SegFs: 0000000000000053:  
    2016-12-15 23:55:48.670 spid371      *      SegGs: 000000000000002B:  
    2016-12-15 23:55:48.670 spid371      *      SegSs: 000000000000002B:  
    2016-12-15 23:55:48.670 spid371      *     EFlags: 0000000000000202:  
    2016-12-15 23:55:48.670 spid371      *        Rax: 0000008000000040:  0000000000000000  0000000000000000  0000000000000000  0000000000000000  00A603016135E026  00001232C3EF0100  
    2016-12-15 23:55:48.670 spid371      *        Rcx: 0000004000000000:  
    2016-12-15 23:55:48.670 spid371      *        Rdx: 0000000000000104:  
    2016-12-15 23:55:48.670 spid371      *        Rbx: 0000000000000000:  
    2016-12-15 23:55:48.670 spid371      *        Rsp: 000000C0A217B600:  0000000000000000  0000000000000000  000000BDD412F940  00007FFD27CEB5D0  00000000000042AC  0000000000000000  
    2016-12-15 23:55:48.670 spid371      *        Rbp: 000000C0A217D280:  0000000100000310  FFFFFFFF00000001  FFFFFFFF00000001  000000C0A217DBE0  00007FFD2D3B7A64  000000000000006D  
    2016-12-15 23:55:48.670 spid371      *        Rsi: 000000BDD412F940:  000000BDD412F940  000000B3D2789890  0000000000000000  0000000000000000  0000000000000000  0000000000000003  
    2016-12-15 23:55:48.670 spid371      *        Rdi: 00007FFD27CEB5D0:  6C894808245C8948  5718247489481024  8B48F18B30EC8348  330019EB650D8BEA  4800110D9915FFDB  F88039481C74C085  
    2016-12-15 23:55:48.670 spid371      *         R8: 0000000000000000:  
    2016-12-15 23:55:48.670 spid371      *         R9: 0000020800000003:  
    2016-12-15 23:55:48.670 spid371      *        R10: 0000000000000000:  
    2016-12-15 23:55:48.670 spid371      *        R11: 0000000000000000:  
    2016-12-15 23:55:48.670 spid371      *        R12: 00000000000000BF:  
    2016-12-15 23:55:48.670 spid371      *        R13: 0000000000000001:  
    2016-12-15 23:55:48.670 spid371      *        R14: 000000C0A217B850:  000000C0847D01B0  00000000000008F0  0000000000000000  00007FFD2AFE6116  000014D63822ACBD  000000C0D09056C8  
    2016-12-15 23:55:48.670 spid371      *        R15: 0000000000000000:  
    2016-12-15 23:55:48.670 spid371      *        Rip: 00007FFD39D18A5C:  000000C0248C8B48  FFFF89D4E8CC3348  C3000000D8C48148  9090909090909090  38418B4D28EC8348  11E8D18B49CA8B48  
    2016-12-15 23:55:48.670 spid371      * *******************************************************************************
    2016-12-15 23:55:48.670 spid371      * -------------------------------------------------------------------------------
    2016-12-15 23:55:48.670 spid371      * Short Stack Dump
    2016-12-15 23:55:48.700 spid371      00007FFD39D18A5C Module(KERNELBASE+0000000000008A5C)
    2016-12-15 23:55:48.700 spid371      00007FFD299FE18E Module(sqllang+000000000101E18E)
    2016-12-15 23:55:48.700 spid371      00007FFD29A01F09 Module(sqllang+0000000001021F09)
    2016-12-15 23:55:48.710 spid371      00007FFD29A3DB49 Module(sqllang+000000000105DB49)
    2016-12-15 23:55:48.720 spid371      00007FFD27CDB924 Module(sqldk+000000000005B924)
    2016-12-15 23:55:48.730 spid371      00007FFD2C3E413C Module(sqlmin+000000000146413C)
    2016-12-15 23:55:48.730 spid371      00007FFD2B10B784 Module(sqlmin+000000000018B784)
    2016-12-15 23:55:48.730 spid371      00007FFD2B10B2E9 Module(sqlmin+000000000018B2E9)
    2016-12-15 23:55:48.730 spid371      00007FFD289FF516 Module(sqllang+000000000001F516)
    2016-12-15 23:55:48.730 spid371      00007FFD28C6240D Module(sqllang+000000000028240D)
    2016-12-15 23:55:48.730 spid371      00007FFD289FF6A4 Module(sqllang+000000000001F6A4)
    2016-12-15 23:55:48.730 spid371      00007FFD289FF59A Module(sqllang+000000000001F59A)
    2016-12-15 23:55:48.730 spid371      00007FFD289EC204 Module(sqllang+000000000000C204)
    2016-12-15 23:55:48.730 spid371      00007FFD28DA77BF Module(sqllang+00000000003C77BF)
    2016-12-15 23:55:48.730 spid371      00007FFD289F5F62 Module(sqllang+0000000000015F62)
    2016-12-15 23:55:48.730 spid371      00007FFD289F5223 Module(sqllang+0000000000015223)
    2016-12-15 23:55:48.730 spid371      00007FFD27C8519D Module(sqldk+000000000000519D)
    2016-12-15 23:55:48.730 spid371      00007FFD27C85AD5 Module(sqldk+0000000000005AD5)
    2016-12-15 23:55:48.730 spid371      00007FFD27C8572D Module(sqldk+000000000000572D)
    2016-12-15 23:55:48.730 spid371      00007FFD27C96F58 Module(sqldk+0000000000016F58)
    2016-12-15 23:55:48.730 spid371      00007FFD27C97140 Module(sqldk+0000000000017140)
    2016-12-15 23:55:48.730 spid371      00007FFD27C970C9 Module(sqldk+00000000000170C9)
    2016-12-15 23:55:48.740 spid371      00007FFD27C976E8 Module(sqldk+00000000000176E8)
    2016-12-15 23:55:48.760 spid371      00007FFD3C4213D2 Module(KERNEL32+00000000000013D2)
    2016-12-15 23:55:48.760 spid371      00007FFD3C7E54E4 Module(ntdll+00000000000154E4)
    2016-12-15 23:55:48.770 spid371      Stack Signature for the dump is 0x00000000CE040F45
    2016-12-15 23:56:00.940 spid371      External dump process return code 0x20000001.
    External dump process returned no errors.

    2016-12-15 23:56:00.950 spid371      Error: 17066, Severity: 16, State: 1.
    2016-12-15 23:56:00.950 spid371      SQL Server Assertion: File: <d:\b\s2\sources\sql\ntdbms\storeng\include\xact.h>, line=784 Failed Assertion = '0'. This error may be timing-related. If the error persists after rerunning the statement, use DBCC CHECKDB to check the database for structural i
    2016-12-15 23:56:00.950 spid371      Error: 3624, Severity: 20, State: 1.
    2016-12-15 23:56:00.950 spid371      A system assertion check has failed. Check the SQL Server error log for details. Typically, an assertion failure is caused by a software bug or data corruption. To check for database corruption, consider running DBCC CHECKDB. If you agreed to send dumps to
    2016-12-15 23:56:00.950 spid371      Error: 3314, Severity: 21, State: 5.
    2016-12-15 23:56:00.950 spid371      During undoing of a logged operation in database 'database', an error occurred at log record ID (24500295:299279:1). Typically, the specific failure is logged previously as an error in the Windows Event Log service. Restore the database or file from a 
    2016-12-15 23:56:00.950 spid371      Database database was shutdown due to error 3624 in routine 'XdesRMFull::Rollback'. Restart for non-snapshot databases will be attempted after all connections to the database are aborted.
    2016-12-15 23:56:00.980 spid429      Error: 9001, Severity: 21, State: 5.
    2016-12-15 23:56:00.980 spid429      The log for database 'database' is not available. Check the event log for related error messages. Resolve any errors and restart the database.
    2016-12-15 23:56:00.980 spid429      Error: 3314, Severity: 21, State: 3.
    2016-12-15 23:56:00.980 spid429      During undoing of a logged operation in database 'database', an error occurred at log record ID (24500295:615786:111). Typically, the specific failure is logged previously as an error in the Windows Event Log service. Restore the database or file from 
    2016-12-15 23:56:00.980 spid429      Error: 3314, Severity: 21, State: 5.
    2016-12-15 23:56:00.980 spid429      During undoing of a logged operation in database 'database', an error occurred at log record ID (24500295:615786:1). Typically, the specific failure is logged previously as an error in the Windows Event Log service. Restore the database or file from a 
    2016-12-15 23:56:01.990 Logon        Error: 18456, Severity: 14, State: 38.
    2016-12-15 23:56:01.990 Logon        Login failed for user 'server1\testservice'. Reason: Failed to open the explicitly specified database 'database'. [CLIENT: <local machine>]
    2016-12-15 23:56:01.990 Logon        Error: 18456, Severity: 14, State: 38.
    2016-12-15 23:56:01.990 Logon        Login failed for user 'user'. Reason: Failed to open the explicitly specified database 'database'. [CLIENT: 10.185.100.107]
    2016-12-15 23:56:02.010 Logon        Error: 18456, Severity: 14, State: 38.
    2016-12-15 23:56:02.010 Logon        Login failed for user 'server1\testservice'. Reason: Failed to open the explicitly specified database 'database'. [CLIENT: <local machine>]
    2016-12-15 23:56:02.030 Logon        Error: 18456, Severity: 14, State: 38.
    2016-12-15 23:56:02.030 Logon        Login failed for user 'server1\testservice'. Reason: Failed to open the explicitly specified database 'database'. [CLIENT: <local machine>]
    2016-12-15 23:56:02.040 Logon        Error: 18456, Severity: 14, State: 38.
    2016-12-15 23:56:02.040 Logon        Login failed for user 'server1\testservice'. Reason: Failed to open the explicitly specified database 'database'. [CLIENT: <local machine>]
    2016-12-15 23:56:02.060 Logon        Error: 18456, Severity: 14, State: 38.
    2016-12-15 23:56:02.060 Logon        Login failed for user 'server1\testservice'. Reason: Failed to open the explicitly specified database 'database'. [CLIENT: <local machine>]
    2016-12-15 23:56:02.080 Logon        Error: 18456, Severity: 14, State: 38.
    2016-12-15 23:56:02.080 Logon        Login failed for user 'server1\testservice'. Reason: Failed to open the explicitly specified database 'database'. [CLIENT: <local machine>]
    2016-12-15 23:56:02.090 Logon        Error: 18456, Severity: 14, State: 38.
    2016-12-15 23:56:02.090 Logon        Login failed for user 'server1\testservice'. Reason: Failed to open the explicitly specified database 'database'. [CLIENT: <local machine>]
    2016-12-15 23:56:02.110 Logon        Error: 18456, Severity: 14, State: 38.
    2016-12-15 23:56:02.110 Logon        Login failed for user 'server1\testservice'. Reason: Failed to open the explicitly specified database 'database'. [CLIENT: <local machine>]
    2016-12-15 23:56:04.550 spid371      **Dump thread - spid = 0, EC = 0x000000BDD412F940
    2016-12-15 23:56:04.550 spid371      ***Stack Dump being sent to D:\Microsoft SQL Server\MSSQL13.server3\MSSQL\LOG\SQLDump0004.txt
    2016-12-15 23:56:04.550 spid371      * *******************************************************************************
    2016-12-15 23:56:04.550 spid371      *
    2016-12-15 23:56:04.550 spid371      * BEGIN STACK DUMP:
    2016-12-15 23:56:04.550 spid371      *   12/15/16 23:56:04 spid 371
    2016-12-15 23:56:04.550 spid371      *
    2016-12-15 23:56:04.550 spid371      * Location: d:\b\s2\sources\sql\ntdbms\storeng\include\xact.h:784
    2016-12-15 23:56:04.550 spid371      * Expression: 0
    2016-12-15 23:56:04.550 spid371      * SPID: 371
    2016-12-15 23:56:04.550 spid371      * Process ID: 3120
    2016-12-15 23:56:04.550 spid371      *
    2016-12-15 23:56:04.550 spid371      * Input Buffer 214 bytes -
    2016-12-15 23:56:04.550 spid371      *         ?   spProcedure;50 '12/15/2016', 'Hybrid Pricepoint MD b
    2016-12-15 23:56:04.550 spid371      *  y Category Effective 12/16/16', '0'
    2016-12-15 23:56:04.550 spid371      *  
    2016-12-15 23:56:04.550 spid371      *

    Tuesday, December 20, 2016 7:33 AM

Answers