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
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 |