September 19, 2016 at 5:05 am
Hello Everyone,
I came across an issue today. Issue is My Sql services had stopped automatically.
I had to start the service from Configuration manager.
When i checked in Error log i found the following errors.Are these errors reason for the Service stop?
SQL Server Assertion: File: <sosmemobj.cpp>, line=2763 Failed Assertion
= 'pvb->FInUse ()'. 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.
SQL Server Assertion: File: <qxcntxt.cpp>, line=1137 Failed Assertion =
'!"No exceptions should be raised by this code"'. 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.
Thanks in Advance,
Sanjay
September 19, 2016 at 5:21 am
Have you applied the latest CU for SQL2016? Available here: https://support.microsoft.com/en-us/kb/3164674 Among other things it addresses an assertion problem that may match your experience https://support.microsoft.com/en-us/kb/3172973
Also, have you tried running DBCC CHECKDB? If so, what were the results?
Thomas Rushton
blog: https://thelonedba.wordpress.com
September 19, 2016 at 6:34 am
Sorry, Forgot to Mention the Edition - My server edition is SQL Server 2012 - Standard edition.
I have 5 Databases. I don't know on which DB to run DBCC checkDB. And It's a live server.
September 19, 2016 at 10:52 am
Run DBCC on ALL of your DB's as that is the only way to tell if a DB has corruption.
September 19, 2016 at 9:11 pm
This was removed by the editor as SPAM
September 19, 2016 at 11:04 pm
Thanks Dewayne, I will check for DBCC errors.
September 19, 2016 at 11:05 pm
Thanks, for the support prettsons
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply