Checkpoint operation failed. Error: 41315

Hello!

All started when  Sql server error log shows:
The transaction log for database 'databasename' is full due to 'XTP_CHECKPOINT'.
On database which uses as usually 30GB log file. 
The LOG file now is 400GB

After searching during 2 days I found too little information(((

It seems, that I have the same problem like in this link, log is growing.
https://connect.microsoft.com/SQLServer/feedback/details/1021865

Microsoft SQL Server 2014 - 12.0.2456.0 
Database in SIMPLE recovery, 
DBCC LOGINFO shows many rows with  State=2
DBCC OPENTRAN show 0 transactions
SYS.DATABASES.log_reuse_wait_desc = XTP_CHECKPOINT
No replications
In-Memory enabled and used
Manual CHECKPOINT shows the error:

Error: 41315, Severity: 16, Checkpoint operation failed.

Is anybody catches the same errors before?

PS. I have restored Database and can run CHECKPOINT command and shrink database. But in several minutes I can't repeat this again because of the same CHECKPOINT error.

---------------------------------------

The same not resolved threads:

I can not shrink transaction log , please help me.

 https://social.technet.microsoft.com/Forums/en-US/5a1926b7-cef4-4b64-a06f-e1927dedfe71/i-can-not-shrink-transaction-log-please-help-me?forum=sqldatabaseengine and this :

Log not truncating due to xpt_checkpoint

https://social.technet.microsoft.com/Forums/en-US/4914e549-3f7a-4be1-83e2-442e22a07dc2/log-not-truncating-due-to-xptcheckpoint?forum=sqldatabaseengine

March 27th, 2015 4:09am

8What I found was two Connect items:
https://connect.microsoft.com/SQLServer/feedback/details/1021865/log-not-truncating-due-to-xpt-checkpoint
https://connect.microsoft.com/SQLServer/feedback/details/1028379/unable-to-clear-xtp-checkpoint-in-database-with-inmemory-table-usage

The gist seems to be that XTP_CHECKPOINT is incorrect, but the real reason is something else. Not much of else. I would consider opening a case with Microsoft and refer to these two Connect items.

Free Windows Admin Tool Kit Click here and download it now
March 27th, 2015 7:12pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics