Sql Server can't stop

0

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
sql-server
asked on Stack Overflow Apr 12, 2021 by jenda3 • edited Apr 12, 2021 by Dale K

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0