Share via

Severe Error in Sql query with minidump creation after upgrade MSSQL 2019 to CU8

Igor Arsentiev 21 Reputation points
2020-11-06T11:57:48.453+00:00

Hello.
After upgrade MSSQL Server 2019 with CU8 the following error occurs

Source spid96
Message
SQL Server Assertion: File: <"sql\ntdbms\hekaton\engine\core\tx.cpp">, line=7798 Failed Assertion = 'count <= Count'. This error may be timing-related. If the error persists after rerunning the statement, use DBCC CHECKDB to check the database for structural integrity, or restart the server to ensure in-memory data structures are not corrupted.

I've checked my database and it is in ok state. after rollback to CU6 everything became normal.
And for the info - my database full of native compiled functions and thus in-memory table variables.
Thanks in advance.

And these are lines from SQL Server Log , i've attached minidump file also

**10/29/2020 22:45:21,spid83,Unknown,SQL Server Assertion: File: <"sql\ntdbms\hekaton\engine\core\tx.cpp"><c/> line=7798 Failed Assertion = 'count <= Count'. This error may be timing-related. If the error persists af37939-sqldump0123.txtter rerunning the statement<c/> use DBCC CHECKDB to check the database for structural integrity<c/> or restart the server to ensure in-memory data structures are not corrupted.
10/29/2020 22:45:21,spid83,Unknown,Error: 17066<c/> Severity: 16<c/> State: 1.
10/29/2020 22:45:21,spid83,Unknown,Dump request is dismissed (stack signature 0x0000000095E2AB81).
10/29/2020 22:45:21,spid83,Unknown,Stack Signature for the dump is 0x0000000095E2AB81
10/29/2020 22:45:21,spid83,Unknown,00007FFB7ED3CEC1 Module(ntdll+000000000004CEC1)
10/29/2020 22:45:21,spid83,Unknown,00007FFB7D317034 Module(KERNEL32+0000000000017034)
10/29/2020 22:45:21,spid83,Unknown,00007FFB0C0F1F53 Module(sqldk+0000000000021F53)
10/29/2020 22:45:21,spid83,Unknown,00007FFB0C0F215C Module(sqldk+000000000002215C)
10/29/2020 22:45:21,spid83,Unknown,00007FFB0C0F17F2 Module(sqldk+00000000000217F2)
10/29/2020 22:45:21,spid83,Unknown,00007FFB0C0DA51E Module(sqldk+000000000000A51E)
10/29/2020 22:45:21,spid83,Unknown,00007FFB0C0DA92D Module(sqldk+000000000000A92D)
10/29/2020 22:45:21,spid83,Unknown,00007FFB0C0D9FF3 Module(sqldk+0000000000009FF3)
10/29/2020 22:45:21,spid83,Unknown,00007FFB0C61BEB3 Module(sqllang+000000000001BEB3)
10/29/2020 22:45:21,spid83,Unknown,00007FFB0C61C0D6 Module(sqllang+000000000001C0D6)
10/29/2020 22:45:21,spid83,Unknown,00007FFB0C6145FF Module(sqllang+00000000000145FF)
10/29/2020 22:45:21,spid83,Unknown,00007FFB0C60B6C5 Module(sqllang+000000000000B6C5)
10/29/2020 22:45:21,spid83,Unknown,00007FFB0C60BF3C Module(sqllang+000000000000BF3C)
10/29/2020 22:45:21,spid83,Unknown,00007FFB7ED90476 Module(ntdll+00000000000A0476)
10/29/2020 22:45:21,spid83,Unknown,00007FFB699943A8 Module(VCRUNTIME140+00000000000043A8)
10/29/2020 22:45:21,spid83,Unknown,00007FFB69991030 Module(VCRUNTIME140+0000000000001030)
10/29/2020 22:45:21,spid83,Unknown,00007FFB0C6512AD Module(sqllang+00000000000512AD)
10/29/2020 22:45:21,spid83,Unknown,00007FFB0C611D02 Module(sqllang+0000000000011D02)
10/29/2020 22:45:21,spid83,Unknown,00007FFB0C611C55 Module(sqllang+0000000000011C55)
10/29/2020 22:45:21,spid83,Unknown,00007FFB0C6418AA Module(sqllang+00000000000418AA)
10/29/2020 22:45:21,spid83,Unknown,00007FFB0D1F1AE3 Module(sqllang+0000000000BF1AE3)
10/29/2020 22:45:21,spid83,Unknown,00007FFB0B703117 Module(hkengine+0000000000013117)
10/29/2020 22:45:21,spid83,Unknown,00007FFB0B7373ED Module(hkengine+00000000000473ED)
10/29/2020 22:45:21,spid83,Unknown,00007FFB0B750A9C Module(hkengine+0000000000060A9C)
10/29/2020 22:45:21,spid83,Unknown,00007FFB0B916C56 Module(hkengine+0000000000226C56)
10/29/2020 22:45:21,spid83,Unknown,00007FFB10293BB6 Module(sqlmin+0000000000DA3BB6)
10/29/2020 22:45:21,spid83,Unknown,00007FFB0C203E96 Module(sqldk+0000000000133E96)
10/29/2020 22:45:21,spid83,Unknown,00007FFB0D62CEFA Module(sqllang+000000000102CEFA)
10/29/2020 22:45:21,spid83,Unknown,00007FFB0D5EAF9A Module(sqllang+0000000000FEAF9A)
10/29/2020 22:45:21,spid83,Unknown,00007FFB0D5E700E Module(sqllang+0000000000FE700E)
10/29/2020 22:45:21,spid83,Unknown,00007FFB7C513E49 Module(KERNELBASE+0000000000023E49)
10/29/2020 22:45:21,spid83,Unknown,* Short Stack Dump
10/29/2020 22:45:21,spid83,Unknown,* -------------------------------------------------------------------------------
10/29/2020 22:45:21,spid83,Unknown,* *******************************************************************************
10/29/2020 22:45:21,spid83,Unknown,* Rip: 00007FFB7C513E49: 8C8B480000441F0F CC3348000000C024 C4814800068C32E8 6483CCC3000000D8 CCCCCCCFEB003824 CCCCCCCCCCCCCCCC
10/29/2020 22:45:21,spid83,Unknown,* R15: 0000000000000000:
10/29/2020 22:45:21,spid83,Unknown,* R14: 00000060EA3F7710: 00610063006F004C 006E006F00690074 002200200009003A 005C006C00710073 00640074006E005C 005C0073006D0062
10/29/2020 22:45:21,spid83,Unknown,* R13: 0000000000000000:
10/29/2020 22:45:21,spid83,Unknown,* R12: 00000000000000BF:
10/29/2020 22:45:21,spid83,Unknown,* R11: 0000000000000008:
10/29/2020 22:45:21,spid83,Unknown,* R10: 0000000000000010:
10/29/2020 22:45:21,spid83,Unknown,* R9: 00000060EA3F5510: 0000000000000005 00000060EA3F54B8 0000000000000000 00007FFB0E3F2B5C 00000060EA3F5CB8 0000000000000032
10/29/2020 22:45:21,spid83,Unknown,* R8: 00007FFB7C81EDBB: FFFFFDE5E930438B 438B480820438348 B4E9F878BF0F4820 00000001BEFFFFFD F6FFFFFEB9E9C68B 042802850F103043
10/29/2020 22:45:21,spid83,Unknown,* Rdi: 0000017AF1310AA0: 0000017AF1310AA0 0000017AF1302740 0000000000000000 0000000000000000 0000000000000000 000000000000007A
10/29/2020 22:45:21,spid83,Unknown,* Rsi: 00000060EA3F5DC0: 0000017E8B2ABDD0 0000000000000008 00007FFB7C810000 0000000000000000 0000000000000002 00007FFB7C81DA16
10/29/2020 22:45:21,spid83,Unknown,* Rbp: 00000060EA3F7800: 0000000100001E76 00000001FFFFFFFF 0000000000000009 00007FFB0B97C390 00000060EA3F8180 0000000000000076
10/29/2020 22:45:21,spid83,Unknown,* Rsp: 00000060EA3F5B70: 00000060EA3F5DC0 0000000000000000 00000060EA3F5DC0 0000017B6BF88FD0 00000000000042AC 0000000000000000
10/29/2020 22:45:21,spid83,Unknown,* Rbx: 0000000000000000:
10/29/2020 22:45:21,spid83,Unknown,* Rdx: 0000000000000057:
10/29/2020 22:45:21,spid83,Unknown,* Rcx: 00000060EA3F5200: 00007FFB0EB35CA4 00007FFB7ED3B131 00007FFB7ED3B131 00007FFF00000000 00000060EA3F5340 0000000000000000
10/29/2020 22:45:21,spid83,Unknown,* Rax: 00007FFB695ADE00: 2D636972656E6567 0000002D65707974 6574616C706D6574 74656D617261702D 73616C63002D7265 00003A3A00002073
10/29/2020 22:45:21,spid83,Unknown,* EFlags: 0000000000000202:
10/29/2020 22:45:21,spid83,Unknown,* SegSs: 000000000000002B:
10/29/2020 22:45:21,spid83,Unknown,* SegGs: 000000000000002B:
10/29/2020 22:45:21,spid83,Unknown,* SegFs: 0000000000000053:
10/29/2020 22:45:21,spid83,Unknown,* SegEs: 000000000000002B:
10/29/2020 22:45:21,spid83,Unknown,* SegDs: 000000000000002B:
10/29/2020 22:45:21,spid83,Unknown,* SegCs: 0000000000000033:
10/29/2020 22:45:21,spid83,Unknown,* MxCsr: 0000000000001FA8:
10/29/2020 22:45:21,spid83,Unknown,* ContextFlags: 000000000010004F:
10/29/2020 22:45:21,spid83,Unknown,* P6Home: 0000017FB6CCD910: 00000000FFFFFFFF 0000000000000000 00000000FFFFFFFF 0000000000000000 00000000FFFFFFFF 0000000000000000
10/29/2020 22:45:21,spid83,Unknown,* P5Home: 0000000000000000:
10/29/2020 22:45:21,spid83,Unknown,* P4Home: 0000000000000074:
10/29/2020 22:45:21,spid83,Unknown,* P3Home: 00780074002E0031:
10/29/2020 22:45:21,spid83,Unknown,* P2Home: 0032003100300070:
10/29/2020 22:45:21,spid83,Unknown,* P1Home: 006D00750044004C:
10/29/2020 22:45:21,spid83,Unknown,*
10/29/2020 22:45:21,spid83,Unknown,* xtp_p_6_226099846_189541225684408_1 00007FFB5B570000 00007FFB5B5A2FFF 00033000
10/29/2020 22:45:21,spid83,Unknown,* xpstar 0000017FB5430000 0000017FB543CFFF 0000d000
10/29/2020 22:45:21,spid83,Unknown,* SQLSCM 00007FFB3F960000 00007FFB3F973FFF 00014000
10/29/2020 22:45:21,spid83,Unknown,* xpstar 00007FFB3CCF0000 00007FFB3CD61FFF 00072000
10/29/2020 22:45:21,spid83,Unknown,* xpsqlbot 00007FFB47BC0000 00007FFB47BC9FFF 0000a000
10/29/2020 22:45:21,spid83,Unknown,* xplog70 0000017FB3FB0000 0000017FB3FB3FFF 00004000
10/29/2020 22:45:21,spid83,Unknown,* xplog70 00007FFB4A360000 00007FFB4A375FFF 00016000
10/29/2020 22:45:21,spid83,Unknown,* xtp_p_6_210099789_189541215109998_4 00007FFB521F0000 00007FFB5220FFFF 00020000
10/29/2020 22:45:21,spid83,Unknown,* xtp_v_6_901578250_189541215106264_4 00007FFB400A0000 00007FFB400C5FFF 00026000
10/29/2020 22:45:21,spid83,Unknown,* xtp_v_6_1061578820_189541215107091_4 00007FFB400D0000 00007FFB400F5FFF 00026000
10/29/2020 22:45:21,spid83,Unknown,* xtp_v_6_1109578991_189541215107363_4 00007FFB40100000 00007FFB40125FFF 00026000
10/29/2020 22:45:21,spid83,Unknown,* xtp_v_6_981578535_189541215106716_4 00007FFB4A380000 00007FFB4A3A5FFF 00026000
10/29/2020 22:45:21,spid83,Unknown,* xtp_v_6_997578592_189541215106823_4 00007FFB522D0000 00007FFB522F5FFF 00026000
10/29/2020 22:45:21,spid83,Unknown,* xtp_v_6_1077578877_189541215107228_4 00007FFB52300000 00007FFB52325FFF 00026000
10/29/2020 22:45:21,spid83,Unknown,* xtp_v_6_965578478_189541215106577_4 00007FFB533E0000 00007FFB53405FFF 00026000
10/29/2020 22:45:21,spid83,Unknown,* xtp_v_6_1141579105_189541215107631_4 00007FFB6A7D0000 00007FFB6A7F6FFF 00027000
10/29/2020 22:45:21,spid83,Unknown,* xtp_p_6_2037582297_189541215109577_4 00007FFB6A800000 00007FFB6A81BFFF 0001c000
10/29/2020 22:45:21,spid83,Unknown,* System.Xml.ni 00007FFB5B830000 00007FFB5C0DAFFF 008ab000
10/29/2020 22:45:21,spid83,Unknown,* System.Security.ni 00007FFB14040000 00007FFB14137FFF 000f8000
10/29/2020 22:45:21,spid83,Unknown,* System.Transactions 00007FFB5CA70000 00007FFB5CABEFFF 0004f000
10/29/2020 22:45:21,spid83,Unknown,* System.Data 00007FFB15B40000 00007FFB15EAAFFF 0036b000
10/29/2020 22:45:21,spid83,Unknown,* System.Core.ni 00007FFB5F3D0000 00007FFB5FE44FFF 00a75000
10/29/2020 22:45:21,spid83,Unknown,* System.ni 00007FFB5FF00000 00007FFB60B6FFFF 00c70000
10/29/2020 22:45:21,spid83,Unknown,* ncryptsslp 00007FFB59000000 00007FFB59025FFF 00026000
10/29/2020 22:45:21,spid83,Unknown,* DSPARSE 00007FFB6B370000 00007FFB6B37BFFF 0000c000
10/29/2020 22:45:21,spid83,Unknown,* ntdsapi 00007FFB2A5A0000 00007FFB2A5C9FFF 0002a000
10/29/2020 22:45:21,spid83,Unknown,* ntmarta 00007FFB7B160000 00007FFB7B192FFF 00033000
10/29/2020 22:45:21,spid83,Unknown,* mswsock 00007FFB7BBC0000 00007FFB7BC29FFF 0006a000
10/29/2020 22:45:21,spid83,Unknown,* mskeyprotect 00007FFB58FB0000 00007FFB58FC4FFF 00015000
10/29/2020 22:45:21,spid83,Unknown,* SRVCLI 00007FFB65CB0000 00007FFB65CD7FFF 00028000
10/29/2020 22:45:21,spid83,Unknown,* Wldp 00007FFB7BEB0000 00007FFB7BEDBFFF 0002c000
10/29/2020 22:45:21,spid83,Unknown,* windows.storage 00007FFB7A570000 00007FFB7AD03FFF 00794000
10/29/2020 22:45:21,spid83,Unknown,* clrjit 00007FFB61CF0000 00007FFB61E3EFFF 0014f000
10/29/2020 22:45:21,spid83,Unknown,* SqlAccess 00007FFB23C10000 00007FFB23C85FFF 00076000
10/29/2020 22:45:21,spid83,Unknown,* mscorlib.ni 00007FFB627B0000 00007FFB63DAFFFF 01600000
10/29/2020 22:45:21,spid83,Unknown,* VCRUNTIME140_CLR0400 00007FFB67290000 00007FFB672A5FFF 00016000
10/29/2020 22:45:21,spid83,Unknown,* ucrtbase_clr0400 00007FFB671D0000 00007FFB6728CFFF 000bd000
10/29/2020 22:45:21,spid83,Unknown,* clr 00007FFB66020000 00007FFB66AE1FFF 00ac2000
10/29/2020 22:45:21,spid83,Unknown,* SQLNCLIRDAR11 0000017E8F780000 0000017E8F7B7FFF 00038000
10/29/2020 22:45:21,spid83,Unknown,* sqlnclirda11 00000000705B0000 0000000070908FFF 00359000
10/29/2020 22:45:21,spid83,Unknown,* netbios 00007FFB59870000 00007FFB5987BFFF 0000c000
10/29/2020 22:45:21,spid83,Unknown,* SQLNCLIR11 0000017E8F710000 0000017E8F747FFF 00038000
10/29/2020 22:45:21,spid83,Unknown,* MSVCR100 0000000070910000 00000000709E1FFF 000d2000
10/29/2020 22:45:21,spid83,Unknown,* sqlncli11 00007FFB0AA10000 00007FFB0AD62FFF 00353000
10/29/2020 22:45:21,spid83,Unknown,* BatchParser 00007FFB2A760000 00007FFB2A789FFF 0002a000
10/29/2020 22:45:21,spid83,Unknown,* dhcpcsvc6 00007FFB74DD0000 00007FFB74DE6FFF 00017000
10/29/2020 22:45:21,spid83,Unknown,* MSOLEDBSQLR 0000017E8F620000 0000017E8F641FFF 00022000
10/29/2020 22:45:21,spid83,Unknown,* COMCTL32 00007FFB5FE50000 00007FFB5FEFFFFF 000b0000
10/29/2020 22:45:21,spid83,Unknown,* SHELL32 00007FFB7E050000 00007FFB7E78FFFF 00740000
10/29/2020 22:45:21,spid83,Unknown,* shcore 00007FFB7EB80000 00007FFB7EC2DFFF 000ae000
10/29/2020 22:45:21,spid83,Unknown,* COMDLG32 00007FFB7E810000 00007FFB7E8E9FFF 000da000
10/29/2020 22:45:21,spid83,Unknown,* msoledbsql 00007FFB0B300000 00007FFB0B5A2FFF 002a3000
10/29/2020 22:45:21,spid83,Unknown,* msxml3 00007FFB3BBA0000 00007FFB3BDAFFFF 00210000
10/29/2020 22:45:21,spid83,Unknown,* clbcatq 00007FFB7E8F0000 00007FFB7E998FFF 000a9000
10/29/2020 22:45:21,spid83,Unknown,* SqlServerSpatial150 00007FFB15480000 00007FFB15521FFF 000a2000
10/29/2020 22:45:21,spid83,Unknown,* mscoreei 00007FFB67B00000 00007FFB67BA9FFF 000aa000
10/29/2020 22:45:21,spid83,Unknown,* MSCOREE 00007FFB684A0000 00007FFB68504FFF 00065000
10/29/2020 22:45:21,spid83,Unknown,* SECURITY 0000017E8B480000 0000017E8B482FFF 00003000
10/29/2020 22:45:21,spid83,Unknown,* schannel 00007FFB7B410000 00007FFB7B4A0FFF 00091000
10/29/2020 22:45:21,spid83,Unknown,* kerberos 00007FFB7BCF0000 00007FFB7BDFDFFF 0010e000
10/29/2020 22:45:21,spid83,Unknown,* cryptdll 00007FFB7BC50000 00007FFB7BC64FFF 00015000
10/29/2020 22:45:21,spid83,Unknown,* NtlmShared 00007FFB7BB10000 00007FFB7BB22FFF 00013000
10/29/2020 22:45:21,spid83,Unknown,* msv1_0 00007FFB7BB30000 00007FFB7BBB9FFF 0008a000
10/29/2020 22:45:21,spid83,Unknown,* profapi 00007FFB7C370000 00007FFB7C395FFF 00026000
10/29/2020 22:45:21,spid83,Unknown,* ncryptprov 00007FFB65FC0000 00007FFB66019FFF 0005a000
10/29/2020 22:45:21,spid83,Unknown,* SHLWAPI 00007FFB7DDB0000 00007FFB7DE04FFF 00055000
10/29/2020 22:45:21,spid83,Unknown,* hkengine 00007FFB0B6F0000 00007FFB0BDE5FFF 006f6000
10/29/2020 22:45:21,spid83,Unknown,* hkcompile 00007FFB0B5B0000 00007FFB0B6EFFFF 00140000
10/29/2020 22:45:21,spid83,Unknown,* dbghelp 00007FFB69440000 00007FFB69623FFF 001e4000
10/29/2020 22:45:21,spid83,Unknown,* hkruntime 00007FFB0BDF0000 00007FFB0C0C2FFF 002d3000
10/29/2020 22:45:21,spid83,Unknown,* VERSION 00007FFB749B0000 00007FFB749B9FFF 0000a000
10/29/2020 22:45:21,spid83,Unknown,* RESUTILS 00007FFB67410000 00007FFB674ABFFF 0009c000
10/29/2020 22:45:21,spid83,Unknown,* NSI 00007FFB7DE10000 00007FFB7DE18FFF 00009000
10/29/2020 22:45:21,spid83,Unknown,* IPHLPAPI 00007FFB7B8B0000 00007FFB7B8EAFFF 0003b000
10/29/2020 22:45:21,spid83,Unknown,* DNSAPI 00007FFB7B8F0000 00007FFB7B9BAFFF 000cb000
10/29/2020 22:45:21,spid83,Unknown,* CLUSAPI 00007FFB657D0000 00007FFB658D7FFF 00108000
10/29/2020 22:45:21,spid83,Unknown,* sqlevn70 00000176FC7F0000 00000176FCB2BFFF 0033c000
10/29/2020 22:45:21,spid83,Unknown,* sqlevn70 00000176FC450000 00000176FC7EEFFF 0039f000
10/29/2020 22:45:21,spid83,Unknown,* cscapi 00007FFB5A640000 00007FFB5A651FFF 00012000
10/29/2020 22:45:21,spid83,Unknown,* wkscli 00007FFB7B620000 00007FFB7B636FFF 00017000
10/29/2020 22:45:21,spid83,Unknown,* gpapi 00007FFB7AD20000 00007FFB7AD42FFF 00023000
10/29/2020 22:45:21,spid83,Unknown,* imagehlp 00007FFB7EC30000 00007FFB7EC4CFFF 0001d000
10/29/2020 22:45:21,spid83,Unknown,* CRYPTBASE 00007FFB7BE20000 00007FFB7BE2BFFF 0000c000
10/29/2020 22:45:21,spid83,Unknown,* rsaenh 00007FFB7B4F0000 00007FFB7B523FFF 00034000
10/29/2020 22:45:21,spid83,Unknown,* CRYPTSP 00007FFB7BE00000 00007FFB7BE17FFF 00018000
10/29/2020 22:45:21,spid83,Unknown,* instapi150 00007FFB2A730000 00007FFB2A743FFF 00014000
10/29/2020 22:45:21,spid83,Unknown,* bcryptPrimitives 00007FFB7CCB0000 00007FFB7CD2EFFF 0007f000
10/29/2020 22:45:21,spid83,Unknown,* kernel.appcore 00007FFB7A370000 00007FFB7A381FFF 00012000
10/29/2020 22:45:21,spid83,Unknown,* MSASN1 00007FFB7C030000 00007FFB7C041FFF 00012000
10/29/2020 22:45:21,spid83,Unknown,* psapi 00007FFB7D3F0000 00007FFB7D3F7FFF 00008000
10/29/2020 22:45:21,spid83,Unknown,* NTASN1 00007FFB7BEE0000 00007FFB7BF1AFFF 0003b000
10/29/2020 22:45:21,spid83,Unknown,* LOGONCLI 00007FFB7B9D0000 00007FFB7BA11FFF 00042000
10/29/2020 22:45:21,spid83,Unknown,* dhcpcsvc 00007FFB752E0000 00007FFB752FCFFF 0001d000
10/29/2020 22:45:21,spid83,Unknown,* XmlLite 00007FFB75E50000 00007FFB75E85FFF 00036000
10/29/2020 22:45:21,spid83,Unknown,* AUTHZ 00007FFB7B210000 00007FFB7B25BFFF 0004c000
10/29/2020 22:45:21,spid83,Unknown,* USERENV 00007FFB7C330000 00007FFB7C35DFFF 0002e000
10/29/2020 22:45:21,spid83,Unknown,* WINTRUST 00007FFB7C940000 00007FFB7C99FFFF 00060000
10/29/2020 22:45:21,spid83,Unknown,* DPAPI 00007FFB7B530000 00007FFB7B539FFF 0000a000
10/29/2020 22:45:21,spid83,Unknown,* ncrypt 00007FFB7BF20000 00007FFB7BF46FFF 00027000
10/29/2020 22:45:21,spid83,Unknown,* SAMCLI 00007FFB6A090000 00007FFB6A0A8FFF 00019000
10/29/2020 22:45:21,spid83,Unknown,* SSPICLI 00007FFB7C2F0000 00007FFB7C32BFFF 0003c000
10/29/2020 22:45:21,spid83,Unknown,* bcrypt 00007FFB7C910000 00007FFB7C936FFF 00027000
10/29/2020 22:45:21,spid83,Unknown,* NETUTILS 00007FFB7B9C0000 00007FFB7B9CBFFF 0000c000
10/29/2020 22:45:21,spid83,Unknown,* secforwarder 00007FFB3BF90000 00007FFB3BFA0FFF 00011000
10/29/2020 22:45:21,spid83,Unknown,* ODBC32 00007FFB23D70000 00007FFB23E27FFF 000b8000
10/29/2020 22:45:21,spid83,Unknown,* WINHTTP 00007FFB72F50000 00007FFB7304FFFF 00100000
10/29/2020 22:45:21,spid83,Unknown,* Secur32 00007FFB68410000 00007FFB6841BFFF 0000c000
10/29/2020 22:45:21,spid83,Unknown,* VCRUNTIME140_1 00007FFB69430000 00007FFB6943BFFF 0000c000
10/29/2020 22:45:21,spid83,Unknown,* WINMM 00007FFB65910000 00007FFB65936FFF 00027000
10/29/2020 22:45:21,spid83,Unknown,* WININET 00007FFB68B70000 00007FFB69049FFF 004da000
10/29/2020 22:45:21,spid83,Unknown,* WS2_32 00007FFB7E7A0000 00007FFB7E80AFFF 0006b000
10/29/2020 22:45:21,spid83,Unknown,* VCRUNTIME140 00007FFB69990000 00007FFB699A8FFF 00019000
10/29/2020 22:45:21,spid83,Unknown,* MPR 00007FFB6A790000 00007FFB6A7ACFFF 0001d000
10/29/2020 22:45:21,spid83,Unknown,* sqllang 00007FFB0C600000 00007FFB0EC16FFF 02617000
10/29/2020 22:45:21,spid83,Unknown,* sqlmin 00007FFB0F4F0000 00007FFB1252EFFF 0303f000
10/29/2020 22:45:21,spid83,Unknown,* MSVCP140 00007FFB697D0000 00007FFB69860FFF 00091000
10/29/2020 22:45:21,spid83,Unknown,* svl 00007FFB552A0000 00007FFB552CCFFF 0002d000
10/29/2020 22:45:21,spid83,Unknown,* sqldk 00007FFB0C0D0000 00007FFB0C5FCFFF 0052d000
10/29/2020 22:45:21,spid83,Unknown,* qds 00007FFB16DD0000 00007FFB16EFAFFF 0012b000
10/29/2020 22:45:21,spid83,Unknown,* opends60 00007FFB5CA60000 00007FFB5CA68FFF 00009000
10/29/2020 22:45:21,spid83,Unknown,* OLEAUT32 00007FFB7D400000 00007FFB7D4CCFFF 000cd000
10/29/2020 22:45:21,spid83,Unknown,* sqlTsEs 00007FFB0EC20000 00007FFB0F4EAFFF 008cb000
10/29/2020 22:45:21,spid83,Unknown,* SQLOS 00007FFB755C0000 00007FFB755C7FFF 00008000
10/29/2020 22:45:21,spid83,Unknown,* USER32 00007FFB7DB70000 00007FFB7DD0FFFF 001a0000
10/29/2020 22:45:21,spid83,Unknown,* msvcp_win 00007FFB7CC10000 00007FFB7CCACFFF 0009d000
10/29/2020 22:45:21,spid83,Unknown,* gdi32full 00007FFB7CB00000 00007FFB7CC08FFF 00109000
10/29/2020 22:45:21,spid83,Unknown,* win32u 00007FFB7CD30000 00007FFB7CD51FFF 00022000
10/29/2020 22:45:21,spid83,Unknown,* GDI32 00007FFB7EA30000 00007FFB7EA59FFF 0002a000
10/29/2020 22:45:21,spid83,Unknown,* combase 00007FFB7CE90000 00007FFB7D1E4FFF 00355000
10/29/2020 22:45:21,spid83,Unknown,* ole32 00007FFB7CD60000 00007FFB7CE89FFF 0012a000
10/29/2020 22:45:21,spid83,Unknown,* sechost 00007FFB7DA70000 00007FFB7DB0AFFF 0009b000
10/29/2020 22:45:21,spid83,Unknown,* RPCRT4 00007FFB7D940000 00007FFB7DA63FFF 00124000
10/29/2020 22:45:21,spid83,Unknown,* msvcrt 00007FFB7DD10000 00007FFB7DDADFFF 0009e000
10/29/2020 22:45:21,spid83,Unknown,* pdh 00007FFB69780000 00007FFB697C8FFF 00049000
10/29/2020 22:45:21,spid83,Unknown,* NETAPI32 00007FFB681E0000 00007FFB681F7FFF 00018000
10/29/2020 22:45:21,spid83,Unknown,* ADVAPI32 00007FFB7D250000 00007FFB7D2F9FFF 000aa000
10/29/2020 22:45:21,spid83,Unknown,* ucrtbase 00007FFB7C810000 00007FFB7C90FFFF 00100000
10/29/2020 22:45:21,spid83,Unknown,* CRYPT32 00007FFB7C9A0000 00007FFB7CAFCFFF 0015d000
10/29/2020 22:45:21,spid83,Unknown,* KERNELBASE 00007FFB7C4F0000 00007FFB7C7B7FFF 002c8000
10/29/2020 22:45:21,spid83,Unknown,* KERNEL32 00007FFB7D300000 00007FFB7D3BCFFF 000bd000
10/29/2020 22:45:21,spid83,Unknown,* ntdll 00007FFB7ECF0000 00007FFB7EEE5FFF 001f6000
10/29/2020 22:45:21,spid83,Unknown,* sqlservr 00007FF6A8E20000 00007FF6A8EBDFFF 0009e000
10/29/2020 22:45:21,spid83,Unknown,* MODULE BASE END SIZE
10/29/2020 22:45:21,spid83,Unknown,*
10/29/2020 22:45:21,spid83,Unknown,*
10/29/2020 22:45:21,spid83,Unknown,* global_attrs_sess gp inner
10/29/2020 22:45:21,spid83,Unknown,* N) select gp.type<c/>gp.starttime<c/>gp.gou_id<c/>gp.id<c/>gp.endtime<c/>gp.N from
10/29/2020 22:45:21,spid83,Unknown,* insert into @global rajesh _attrs_sess(type<c/>starttime<c/>gou_id<c/>id<c/>endtime<c/>
10/29/2020 22:45:21,spid83,Unknown,* n_id=@session_id and g.id=gh.gou_id where gp.session_id=@session_id
10/29/2020 22:45:21,spid83,Unknown,* gou_holder gh on gp.gou_id=gh.gou_id inner join gou g on g.sessio
10/29/2020 22:45:21,spid83,Unknown,* en gp.ppbr else gp.p end) as p from gou_plan gp inner join @
10/29/2020 22:45:21,spid83,Unknown,* null(g.iv0_calc<c/>0)=5 then gp.p_dem when isnull(g.iv0_calc<c/>0)=6 th
10/29/2020 22:45:21,spid83,Unknown,* gp.p when isnull(g.iv0_calc<c/>0)=4 then gp.isei_pdem when is
10/29/2020 22:45:21,spid83,Unknown,* null(g.iv0_calc<c/>0)=1 then gp.tg when isnull(g.iv0_calc<c/>0)=2 then
10/29/2020 22:45:21,spid83,Unknown,* ou_id <c/>(case when isnull(g.iv0_calc<c/>0)=3 then gp.pbr when is
10/29/2020 22:45:21,spid83,Unknown,* n(id<c/>targetdate<c/>hour<c/>gou_id<c/>p) select gp.id<c/>gp.targetdate<c/>gp.hour<c/>gp.g
10/29/2020 22:45:21,spid83,Unknown,* and g.id=gh.gou_id cross join @times c insert into @贱㊙狗 _pla
10/29/2020 22:45:21,spid83,Unknown,* rom @贱㊙狗 _holder gh inner join gou g on g.session_id=@session_id
10/29/2020 22:45:21,spid83,Unknown,* <c/>0 as itype <c/>1 as is_plan <c/>0 as is_fact <c/>0 as is_n f
10/29/2020 22:45:21,spid83,Unknown,* 0 as N <c/>(case when g.calc_shape_pbr=1 then 16 else 3 end) as type
10/29/2020 22:45:21,spid83,Unknown,* .id+c.cur_hour as id<c/>@session_id<c/>gh.gou_id<c/>c.cur_time1<c/>c.cur_time2 <c/>
10/29/2020 22:45:21,spid83,Unknown,* u_id<c/>starttime<c/>endtime<c/>N<c/>type<c/>itype<c/>is_plan<c/>is_fact<c/>is_n) select g
10/29/2020 22:45:21,spid83,Unknown,* r=@cur_hour+1; end insert into @over_commands(id<c/>session_id<c/>go
10/29/2020 22:45:21,spid83,Unknown,* time1=dateadd(hour<c/>1<c/>dbo.RoundTimeMem(@cur_time1<c/>1)) set @cur_hou
10/29/2020 22:45:21,spid83,Unknown,* me2) values(@cur_hour<c/>@cur_time1<c/>@cur_time2); set @cur_
10/29/2020 22:45:21,spid83,Unknown,* meMem(@cur_time1<c/>1)); insert into @times(cur_hour<c/>cur_time1<c/>cur_ti
10/29/2020 22:45:21,spid83,Unknown,* @cur_hour<@hours begin set @cur_time2= dateadd(hour<c/>1<c/>dbo.RoundTi
10/29/2020 22:45:21,spid83,Unknown,* <c/>@cur_time1 datetime='20201027 00:00:00'<c/>@cur_time2 datetime while
10/29/2020 22:45:21,spid83,Unknown,* gou_holder(gou_id) values(10911) declare @cur_hour int=0<c/>@hours int=1
10/29/2020 22:45:21,spid83,Unknown,* type) select id from command_types where id in (3<c/>16) insert into @
10/29/2020 22:45:21,spid83,Unknown,* <c/>@贱㊙狗 _fact t_fact <c/>@贱㊙狗 _fact_hour t_fact insert into @scommands(i
10/29/2020 22:45:21,spid83,Unknown,* mands <c/>@贱㊙狗 _plan t_gou_plan <c/>@global rajesh _attrs_sess t_global_attrs
10/29/2020 22:45:21,spid83,Unknown,* s <c/>@scommands u_itype <c/>@贱㊙狗 _holder u_gou_holder <c/>@over_commands t_com
10/29/2020 22:45:21,spid83,Unknown,* declare @session_id int=25379<c/>@itype int=0<c/>@times u_time
10/29/2020 22:45:21,spid83,Unknown,* Input Buffer 510 bytes -
10/29/2020 22:45:21,spid83,Unknown,*
10/29/2020 22:45:21,spid83,Unknown,* Process ID: 16800
10/29/2020 22:45:21,spid83,Unknown,* SPID: 83
10/29/2020 22:45:21,spid83,Unknown,* Expression: count <= Count
10/29/2020 22:45:21,spid83,Unknown,* Location: "sql\ntdbms\hekaton\engine\core\tx.cpp":7798
10/29/2020 22:45:21,spid83,Unknown,*
10/29/2020 22:45:21,spid83,Unknown,* 10/29/20 22:45:21 spid 83
10/29/2020 22:45:21,spid83,Unknown,* BEGIN STACK DUMP:
10/29/2020 22:45:21,spid83,Unknown,*
10/29/2020 22:45:21,spid83,Unknown,* *******************************************************************************
10/29/2020 22:45:21,spid83,Unknown,***Stack Dump being sent to C:\Databases\MSSQL15.MSSQLSERVER\MSSQL\LOG\SQLDump0122.txt
10/29/2020 22:45:21,spid83,Unknown,**Dump thread - spid = 0<c/> EC = 0x0000017AF1310AA0
10/29/2020 22:45:21,spid83,Unknown,CImageHelper::Init () Version-specific dbghelp.dll is not used
10/29/2020 22:45:21,spid83,Unknown,A system assertion check has failed. Check the SQL Server error log for details. Typically<c/> an assertion failure is caused by a software bug or data corruption. To check for database corruption<c/> consider running DBCC CHECKDB. If you agreed to send dumps to Microsoft during setup<c/> a mini dump will be sent to Microsoft. An update might be available from Microsoft in the latest Service Pack or in a Hotfix from Technical Support.
10/29/2020 22:45:21,spid83,Unknown,Error: 3624<c/> Severity: 20<c/> State: 1.
10/29/2020 22:45:21,spid83,Unknown,SQL Server Assertion: File: <"sql\ntdbms\hekaton\engine\core\tx.cpp"><c/> line=7798 Failed Assertion = 'count <= Count'. This error may be timing-related. If the error persists after rerunning the statement<c/> use DBCC CHECKDB to check the database for structural integrity<c/> or restart the server to ensure in-memory data structures are not corrupted.
10/29/2020 22:45:21,spid83,Unknown,Error: 17066<c/> Severity: 16<c/> State: 1.
10/29/2020 22:45:21,spid83,Unknown,Dump request is dismissed (stack signature 0x000000015105375F).
10/29/2020 22:45:21,spid83,Unknown,Stack Signature for the dump is 0x000000015105375F
10/29/2020 22:45:21,spid83,Unknown,00007FFB7ED3CEC1 Module(ntdll+000000000004CEC1)
10/29/2020 22:45:21,spid83,Unknown,00007FFB7D317034 Module(KERNEL32+0000000000017034)
10/29/2020 22:45:21,spid83,Unknown,00007FFB0C0F1F53 Module(sqldk+0000000000021F53)
10/29/2020 22:45:21,spid83,Unknown,00007FFB0C0F215C Module(sqldk+000000000002215C)
10/29/2020 22:45:21,spid83,Unknown,00007FFB0C0F17F2 Module(sqldk+00000000000217F2)
10/29/2020 22:45:21,spid83,Unknown,00007FFB0C0DA51E Module(sqldk+000000000000A51E)
10/29/2020 22:45:21,spid83,Unknown,00007FFB0C0DA92D Module(sqldk+000000000000A92D)
10/29/2020 22:45:21,spid83,Unknown,00007FFB0C0D9FF3 Module(sqldk+0000000000009FF3)
10/29/2020 22:45:21,spid83,Unknown,00007FFB0C61BEB3 Module(sqllang+000000000001BEB3)
10/29/2020 22:45:21,spid83,Unknown,00007FFB0C61C0D6 Module(sqllang+000000000001C0D6)
10/29/2020 22:45:21,spid83,Unknown,00007FFB0C6145FF Module(sqllang+00000000000145FF)
10/29/2020 22:45:21,spid83,Unknown,00007FFB0C60B6C5 Module(sqllang+000000000000B6C5)
10/29/2020 22:45:21,spid83,Unknown,00007FFB0C60BF3C Module(sqllang+000000000000BF3C)
10/29/2020 22:45:21,spid83,Unknown,00007FFB0C60C5ED Module(sqllang+000000000000C5ED)
10/29/2020 22:45:21,spid83,Unknown,00007FFB0D3395AD Module(sqllang+0000000000D395AD)
10/29/2020 22:45:21,spid83,Unknown,00007FFB0B702B2E Module(hkengine+0000000000012B2E)
10/29/2020 22:45:21,spid83,Unknown,00007FFB0B7372C5 Module(hkengine+00000000000472C5)
10/29/2020 22:45:21,spid83,Unknown,00007FFB0B750A9C Module(hkengine+0000000000060A9C)
10/29/2020 22:45:21,spid83,Unknown,00007FFB0B916C56 Module(hkengine+0000000000226C56)
10/29/2020 22:45:21,spid83,Unknown,00007FFB10293BB6 Module(sqlmin+0000000000DA3BB6)
10/29/2020 22:45:21,spid83,Unknown,00007FFB0C203E96 Module(sqldk+0000000000133E96)
10/29/2020 22:45:21,spid83,Unknown,00007FFB0D62CEFA Module(sqllang+000000000102CEFA)
10/29/2020 22:45:21,spid83,Unknown,00007FFB0D5EAF9A Module(sqllang+0000000000FEAF9A)
10/29/2020 22:45:21,spid83,Unknown,00007FFB0D5E700E Module(sqllang+0000000000FE700E)
10/29/2020 22:45:21,spid83,Unknown,00007FFB7C513E49 Module(KERNELBASE+0000000000023E49)
10/29/2020 22:45:21,spid83,Unknown,* Short Stack Dump
10/29/2020 22:45:21,spid83,Unknown,* -------------------------------------------------------------------------------
10/29/2020 22:45:21,spid83,Unknown,* *******************************************************************************
10/29/2020 22:45:21,spid83,Unknown,* Rip: 00007FFB7C513E49: 8C8B480000441F0F CC3348000000C024 C4814800068C32E8 6483CCC3000000D8 CCCCCCCFEB003824 CCCCCCCCCCCCCCCC
10/29/2020 22:45:21,spid83,Unknown,* R15: 0000000000000000:
10/29/2020 22:45:21,spid83,Unknown,* R14: 00000060EA3FB660: 00610063006F004C 006E006F00690074 002200200009003A 005C006C00710073 00640074006E005C 005C0073006D0062
10/29/2020 22:45:21,spid83,Unknown,* R13: 0000000000000000:
10/29/2020 22:45:21,spid83,Unknown,* R12: 00000000000000BF:
10/29/2020 22:45:21,spid83,Unknown,* R11: 0000000000000008:
10/29/2020 22:45:21,spid83,Unknown,* R10: 0000000000000010:
10/29/2020 22:45:21,spid83,Unknown,* R9: 00000060EA3F9460: 0000000000000005 00000060EA3F9408 0000000000000000 00007FFB0E3F2B5C 00000060EA3F9C08 0000000000000032
10/29/2020 22:45:21,spid83,Unknown,* R8: 00007FFB7C81EDBB: FFFFFDE5E930438B 438B480820438348 B4E9F878BF0F4820 00000001BEFFFFFD F6FFFFFEB9E9C68B 042802850F103043
10/29/2020 22:45:21,spid83,Unknown,* Rdi: 0000017AF1310AA0: 0000017AF1310AA0 0000017AF1302740 0000000000000000 0000000000000000 0000000000000000 0000000000000079
10/29/2020 22:45:21,spid83,Unknown,* Rsi: 00000060EA3F9D10: 0000017E8B2ABDD0 0000000000000000 0000017E00000008 0000534ACAF807BD 0000017B6BECA480 00000060EA3FA368
10/29/2020 22:45:21,spid83,Unknown,* Rbp: 00000060EA3FB750: 0000000100001E76 00000001FFFFFFFF 0000006000000009 00007FFB0B97C390 00000060EA3FC0D0 0000000000000076
10/29/2020 22:45:21,spid83,Unknown,* Rsp: 00000060EA3F9AC0: 00000060EA3F9D10 0000000000000000 00000060EA3F9D10 0000017B6BF88FD0 00000000000042AC 0000000000000000
10/29/2020 22:45:21,spid83,Unknown,* Rbx: 0000000000000000:
10/29/2020 22:45:21,spid83,Unknown,* Rdx: 0000000000000000:
10/29/2020 22:45:21,spid83,Unknown,* Rcx: FFFFFFFFFFFFFFFE:
10/29/2020 22:45:21,spid83,Unknown,* Rax: 0000000000000000:
10/29/2020 22:45:21,spid83,Unknown,* EFlags: 0000000000000206:
10/29/2020 22:45:21,spid83,Unknown,* SegSs: 000000000000002B:
10/29/2020 22:45:21,spid83,Unknown,* SegGs: 000000000000002B:
10/29/2020 22:45:21,spid83,Unknown,* SegFs: 0000000000000053:
10/29/2020 22:45:21,spid83,Unknown,* SegEs: 000000000000002B:
10/29/2020 22:45:21,spid83,Unknown,* SegDs: 000000000000002B:
10/29/2020 22:45:21,spid83,Unknown,* SegCs: 0000000000000033:
10/29/2020 22:45:21,spid83,Unknown,* MxCsr: 0000000000001FA8:
10/29/2020 22:45:21,spid83,Unknown,* ContextFlags: 000000000010004F:
10/29/2020 22:45:21,spid83,Unknown,* P6Home: 00007FFB00000000:
10/29/2020 22:45:21,spid83,Unknown,* P5Home: 00000060EA3FAB18: 00000060EA3F9A10 0000000000000000 000000000000007E 0000000000000000 0000000000000008 0000000000000074
10/29/2020 22:45:21,spid83,Unknown,* P4Home: 0000000000000074:
10/29/

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,630 questions
0 comments
Accepted answer
  1. Shashank Singh 6,251 Reputation points
    2020-11-06T13:12:33.583+00:00

    I would agree with Tom Phillips here, I would also highly recommend to open Support case. If this turns out to be a bug from SQL Server side you would most likely get a refund. Before opening a ticket make sure you run database checkdb on all the databases just to rule out any data corruption.

    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tom Phillips 17,731 Reputation points
    2020-11-06T12:59:15.173+00:00

    That is an internal code error in SQL Server. I suggest you contact MS Support for resolution.

    0 comments
  2. Igor Arsentiev 21 Reputation points
    2020-11-06T13:38:15.84+00:00

    Thanks to all -)
    I will do as you recommended

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.