Help - Cannot continue the execution because the session is in the kill state.

New Contributor

I try to execute a update query in SQL Server 2016 (v13.0.5026.0) and get these error messages:

 

UPDATE tableName SET fieldName1 ='a long query with some html tags and all it has 3600 chars' WHERE fieldName2  = 12345

 And get this error,

Msg 596, Level 21, State 1, Line 0
Cannot continue the execution because the session is in the kill state.

Msg 0, Level 20, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.

As Microsoft website suggested, I tried an update to Cummulative Update(CU6) and changed to 13.0.5292.0 It says CU1 update has to fix it but doesn't solve the issue.

 

This query creates a dump file, and the log has the following message:

SqlDumpExceptionHandler: Process ID generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.

 

The same update query works on other table in the same database.

 

Any help would be great.

1 Reply