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.
Resolution
The issue was first fixed in the following cumulative update of SQL Server.
Cumulative Update 4 for SQL Server 2012 SP2 /en-us/help/3007556
Cumulative Update 13 for SQL Server 2012 SP1 /en-us/help/3002044
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.
