From: | Daniel Kalchev <daniel(at)digsys(dot)bg> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | tuples gone? |
Date: | 2002-05-23 10:19:15 |
Message-ID: | 200205231019.g4NAJFu20539@dcave.digsys.bg |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi,
I got an corrupted table,,, unfortunately with pretty important data :(
VACUUM tells me:
NOTICE: Rel relx: TID 2344/5704: OID IS INVALID. TUPGONE 1.
NOTICE: Rel relx: TID 2344/5736: OID IS INVALID. TUPGONE 1.
NOTICE: Rel relx: TID 2344/5768: OID IS INVALID. TUPGONE 1.
(this, many times, then)
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
I can read part (beginning?) of the relation with select or copy, but anything
that touches this area dies badly :(
Is there any way to recover this relation? Or at least as much data as
possible?
Oh, an this is 7.1.3 and I am probably running with too large oids :)
DEBUG: NextTransactionId: 708172974; NextOid: 3480073772
Daniel
From | Date | Subject | |
---|---|---|---|
Next Message | D'Arcy J.M. Cain | 2002-05-23 11:32:45 | Re: Edge case problem with pg_dump |
Previous Message | Michael Meskes | 2002-05-23 08:44:04 | Re: Redhat 7.3 time manipulation bug |