Postgres Pro
Downloads
Home   >   mailing lists

Re: Problems with vacuum - Mailing list pgsql-general

From Tom Lane
Subject Re: Problems with vacuum
Date
Msg-id 1331.976300728@sss.pgh.pa.us
Whole thread Raw
In response to Problems with vacuum  ("Timothy H. Keitt" <Timothy.Keitt@SUNYSB.Edu>)
List pgsql-general
Tree view 
"Timothy H. Keitt" <Timothy.Keitt@SUNYSB.Edu> writes:
> NOTICE:  Rel bbs_counts: TID 6257/6: OID IS INVALID. TUPGONE 1.
> NOTICE:  Rel bbs_counts: TID 6257/7: OID IS INVALID. TUPGONE 1.
> NOTICE:  Rel bbs_counts: TID 6257/8: OID IS INVALID. TUPGONE 1.
> NOTICE:  Rel bbs_counts: TID 6257/9: OID IS INVALID. TUPGONE 1.
> NOTICE:  Rel bbs_counts: TID 6257/11: OID IS INVALID. TUPGONE 1.

Hmm.  Looks like you've got a clobbered page in that relation.
Page 6257 to be exact (remember these are 8K pages, and the first page
in the table is page zero).  Can you dump it out with dd and od,
or some similar tools, and see what's there?

Has anything unusual happened lately in this database?  Crashes, etc?

            regards, tom lane

pgsql-general by date:

Previous
From: "Timothy H. Keitt"
Date:
Subject: Problems with vacuum
Next
From: "Mayers, Philip J"
Date:
Subject: Help interpreting the output of EXPLAIN