Please install the latest patch and retest.
https://learn.microsoft.com/en-US/troubleshoot/sql/general/determine-version-edition-update-level
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi,
The DatabaseMail on sql server 2016 crashes with following error :
Exception Type: System.Data.SqlClient.SqlException
Errors: System.Data.SqlClient.SqlErrorCollection
Class: 20
LineNumber: 11
Number: 3624
Procedure: trig_sysmail_mailitems
Server: <DBName>
State: 1
Source: .Net SqlClient Data Provider
ErrorCode: -2146232060
Message: 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 Microsoft during setup, 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.
Cannot continue the execution because the session is in the kill state.
A severe error occurred on the current command. The results, if any, should be discarded.
Location: SpcAlloc.cpp:909
Expression: pPage->IsType (Page::TEXT_MIX_PAGE)
SPID: 59
Process ID: 6400
Data: System.Collections.ListDictionaryInternal
TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean)
HelpLink: NULL
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.DataAccessAdapter.PostResponse(Response r, Guid convHandle)
at Microsoft.SqlServer.Management.SqlIMail.IMailProcess.ThreadCallBack.PostResponseIfNeeded(MailInfo mailInfo, Response response)
at Microsoft.SqlServer.Management.SqlIMail.IMailProcess.ThreadCallBack.MailOperation(Object obj)
I have checked the integrity of DB and all looks good. Because of this error important client error alerts are not being sent from DBMail. DBMail crashes most of times on PROD env. The 2016 sql server on PROD env is updated with latest updates.
Is this issue something that is known, on sql server, as suggested in many of the posts on MSDN Forums?
Please install the latest patch and retest.
https://learn.microsoft.com/en-US/troubleshoot/sql/general/determine-version-edition-update-level
Hi ThomasSam-1947,
Were there any dumps generated in the \Program Files\Microsoft SQL Server\MSSQL13.\MSSQL\Log when SQL Server crashed? Please make sure you have installed the latest SP and CU for SQL Server 2016.
You could open a ticket with Microsoft support. They can analyze the dump files and confirm what exactly is causing the issue.
Best Regards,
Amelia