Re: Problems with vacuum

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Timothy H(dot) Keitt" <Timothy(dot)Keitt(at)SUNYSB(dot)Edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Problems with vacuum
Date: 2000-12-08 18:38:48
Message-ID: 1331.976300728@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Timothy H. Keitt" <Timothy(dot)Keitt(at)SUNYSB(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Oleg Bartunov 2000-12-08 19:03:15 Re: Indexing for geographic objects?
Previous Message Mayers, Philip J 2000-12-08 18:19:37 Help interpreting the output of EXPLAIN