Today I had a problem with the SQL Server. The SQL Server has crashed and I can't connect to it. When I try to restart the SQL Server it remained in the STOP_Pending state for 30 minutes, then I killed the process.
I have this error message in the error log. I can't find what the error means. Does anyone have any idea?
Thanks
2021-04-12 08:02:07.54 spid755 Unable to create stack dump file due to stack shortage (Location: scheduler.cpp:2090
Expression: !pWorker->WorkerQueueElem::IsInList ()
SPID: 755
Process ID: 2336)
2021-04-12 08:02:07.54 spid755 Stack Signature for the dump is 0x0000000000000000
2021-04-12 08:02:08.20 spid755 External dump process not executed.
2021-04-12 08:02:08.20 spid755 DoMiniDump () encountered error (0xC00000FD)
2021-04-12 08:02:08.20 spid755 Error: 17066, severity: 16, state: 1.
2021-04-12 08:02:08.20 spid755 SQL Server Assertion: File: <scheduler.cpp>, line=2090 Failed Assertion = '!pWorker->WorkerQueueElem::IsInList ()'. 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.
2021-04-12 08:02:32.01 Server Using 'dbghelp.dll' version '4.0.5'
2021-04-12 08:02:32.01 Server **Dump thread - spid = 0, EC = 0x0000000000000000
2021-04-12 08:02:32.01 Server ***Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\LOG\SQLDump0009.txt
2021-04-12 08:02:32.01 Server * *******************************************************************************
2021-04-12 08:02:32.01 Server *
2021-04-12 08:02:32.01 Server * BEGIN STACK DUMP:
2021-04-12 08:02:32.01 Server * 04/12/21 08:02:32 spid 9804
2021-04-12 08:02:32.01 Server *
2021-04-12 08:02:32.01 Server * Stalled IOCP Listener
2021-04-12 08:02:32.01 Server *
2021-04-12 08:02:32.01 Server * *******************************************************************************
2021-04-12 08:02:32.01 Server * -------------------------------------------------------------------------------
2021-04-12 08:02:32.01 Server * Short Stack Dump
User contributions licensed under CC BY-SA 3.0