KB2995352 - FIX: "No catalog entry found for partition ID <ID> in database <Database Name>" error when you use SQL Server 2012

Symptoms

Assume that you query the tempdb.sys.allocation_units table in Microsoft SQL Server 2012. When you use NOLOCK hint in the query or the query is under the READ UNCOMMITED transaction isolation level, you receive the following intermittent 608 error message:

Error: 608 Severity: 16 State: 1 No catalog entry found for partition <ID> in database <Database Name>. The metadata is inconsistent. Run DBCC CHECKDB to check for a metadata corruption


Note The DBCC CHECKDB command does not show any sign of database corruption.

Cause

The issue occurs because of a dirty read on stale metadata.

Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. Check out the latest cumulative updates for SQL Server:


Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×