patternsqlMinor
What does "Deleting unrecoverable checkpoint table row" mean?
Viewed 0 times
deletingwhatmeancheckpointunrecoverabledoesrowtable
Problem
When I look at our production SQL Server 2016's server logs I am seeing multiple entries that say:
[INFO] Database ID: [5]. Deleting unrecoverable checkpoint table row
(id: 294).
The id at the end is incremented by 1 for each entry.
I Googled for this error and there is literally nothing about it. What does this entry mean? It sounds rather ominous.
[INFO] Database ID: [5]. Deleting unrecoverable checkpoint table row
(id: 294).
The id at the end is incremented by 1 for each entry.
I Googled for this error and there is literally nothing about it. What does this entry mean? It sounds rather ominous.
Solution
This is my assumption based on the log entry -
If you are using Memory optimized tables, there are Checkpoint File Pair (CFPs).
CPFs transition through several states before they can be deallocated. Database checkpoints and log backups need to happen to transition the files through the phases, and ultimately clean up files that are no longer needed. For a description of these phases, see sys.dm_db_xtp_checkpoint_files
The log entry refers to deallocation by garbage collection process.
If you are using Memory optimized tables, there are Checkpoint File Pair (CFPs).
CPFs transition through several states before they can be deallocated. Database checkpoints and log backups need to happen to transition the files through the phases, and ultimately clean up files that are no longer needed. For a description of these phases, see sys.dm_db_xtp_checkpoint_files
The log entry refers to deallocation by garbage collection process.
Context
StackExchange Database Administrators Q#163143, answer score: 5
Revisions (0)
No revisions yet.