Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

No catalog entry found for partition ID (MSSQL 2005) Expand / Collapse
Author
Message
Posted Monday, September 14, 2009 11:20 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, October 30, 2014 10:47 AM
Points: 72, Visits: 299
I've seen few posts regarding this error msg but none that have yet helped me. This error has happened a few times in our environment at seemingly random times, necessitating a restart of the DB service. SQL logs the error as:

Date 9/13/2009 1:06:36 AM
Log SQL Server (Archive #1 - 9/13/2009 1:09:00 AM)
Source spid57
Message
No catalog entry found for partition ID xxx in database yyy. The metadata is inconsistent. Run DBCC CHECKDB to check for a metadata corruption.

In the Windows Event Viewer:
Source:MSSQLSERVER
Time: 1:06:36 AM
Category: (2)
Type: Error
EventID: 608
Description:
No catalog entry found for partition ID xxx in database yyy. The metadata is inconsistent. Run DBCC CHECKDB to check for a metadata corruption.


The following SQL statement returns no results:

SELECT OBJECT_NAME([object_id])
FROM sys.partitions
WHERE partition_id = xxx


The SQL log does provide the SpID...is it possible to identify the process that ran into this problem? Are there additional things I can look at to try and determine where/what is causing this problem.

Further Note: I do not have any jobs scheduled for this time and DBCC returns no errors

TIA
Post #787630
Posted Tuesday, September 15, 2009 10:55 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, October 27, 2014 11:15 AM
Points: 2,041, Visits: 1,671
Is this a user database or tempdb?

Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
Post #788370
Posted Tuesday, September 15, 2009 11:58 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, October 30, 2014 10:47 AM
Points: 72, Visits: 299
This is a user database
Post #788422
Posted Tuesday, September 15, 2009 12:23 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, October 27, 2014 11:15 AM
Points: 2,041, Visits: 1,671
There's a known bug with this on tempdb (see http://www.sqlservercentral.com/Forums/Topic770808-149-1.aspx). Could be the same thing. I'll ping Product Support.

Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
Post #788444
Posted Tuesday, September 15, 2009 12:30 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, October 30, 2014 10:47 AM
Points: 72, Visits: 299
I saw that thread and couldn't confirm that it was the same issue. I'll keep my eyes on it for your response. Thanks Paul.
Post #788452
Posted Tuesday, September 15, 2009 2:06 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, October 27, 2014 11:15 AM
Points: 2,041, Visits: 1,671
Ok - that bug is tempdb only it seems.

Can you run DBCC CHECKDB (yourdb) WITH ALL_ERRORMSGS, NO_INFOMSGS and post any results?

[Edit: Hmm - see that you don't get DBCC errors - in that case it must be a bug and you'll need to call into Product Support to help you out].

Thanks


Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
Post #788534
Posted Friday, March 28, 2014 11:38 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: 2 days ago @ 9:09 AM
Points: 50, Visits: 576
Hello. I know this is an old post, however, I just experienced this same issue with Microsoft SQL Server 2012 (SP1) - 11.0.3381.0 (X64) Standard Edition. I am still digging to determine if this is a bug.

Error: 608, Severity: 16, State: 1.
2014-03-27 19:50:01.250 spid57 No catalog entry found for partition ID 5908827923301924864 in database 2. The metadata is inconsistent. Run DBCC CHECKDB to check for a metadata corruption.

Ran CHECKDB, found no corruption
Post #1556080
Posted Friday, March 28, 2014 12:05 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, October 27, 2014 11:15 AM
Points: 2,041, Visits: 1,671
Did you call Product Support yet? What did they say?

Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
Post #1556096
Posted Friday, March 28, 2014 12:37 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: 2 days ago @ 9:09 AM
Points: 50, Visits: 576
Hello Mr. Randal,
Thanks for replying so quickly. We are in the process of opening a case.
Post #1556114
Posted Tuesday, April 1, 2014 12:53 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: 2 days ago @ 9:09 AM
Points: 50, Visits: 576
Mr. Randal,

MSFT called back to inform us that we may have a TEMPDB corruption. However, I told them running the consistency checker displays no corruption, therefore, their corruption team will be contacting me shortly. Will keep you posted.
Post #1557167
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse