Problems with vacuum
Anyone seen this?
Tim
--
Timothy H. Keitt
Department of Ecology and Evolution
State University of New York at Stony Brook
Phone: 631-632-1101, FAX: 631-632-7626
http://life.bio.sunysb.edu/ee/keitt/
Attachments:
psql.outtext/plain; name=psql.outDownload
"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