Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL 8.3 data corruption - Mailing list pgsql-general

From Chitra Creta
Subject Re: PostgreSQL 8.3 data corruption
Date
Msg-id CABkVLeOK+=dP2+hiwjs31zzE8V0tZcgWR=vK0KgMjtFtDXJ4Tg@mail.gmail.com
Whole thread Raw
In response to PostgreSQL 8.3 data corruption  (Chitra Creta <chitracreta@gmail.com>)
Responses Re: PostgreSQL 8.3 data corruption
List pgsql-general
Tree view
Hello all,

Any thoughts on this one?

Cheers.


On Tue, May 1, 2012 at 9:51 PM, Chitra Creta <chitracreta@gmail.com> wrote:
Hi there,

I have mission-critical data running on PostgreSQL 8.3. My database got corrupted a few days ago as I ran out of disk space. 

I had to run pg_resetxlog to get the database started again. I am now experiencing the following errors:

1. ERROR: t_xmin is uncommitted in tuple to be updated

2. ERROR: could not access status of transaction 61323662
  Detail: Could not read from file "pg_subtrans/03A7" at offset 188416: No error.

Does anyone know how to resolve the issues above? Would a VACUUM FULL or a dump and restore work? Or is there another way to fix the above.


Thanking you in advance,
Chitra

pgsql-general by date:

Previous
From: Maxim Boguk
Date:
Subject: Re: Inefficient plan selected by PostgreSQL 9.0.7
Next
From: Pavel Stehule
Date:
Subject: Re: PostgreSQL 8.3 data corruption