From: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
---|---|
To: | "Akash Garg" <akash(dot)garg(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: DB errors |
Date: | 2007-10-12 15:42:14 |
Message-ID: | dcc563d10710120842s3c6720ccm680302bc4c9fbfb3@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 10/12/07, Akash Garg <akash(dot)garg(at)gmail(dot)com> wrote:
> We had a crash of one of our db systems last night. After doing a fsck of
> he file system and getting the db backup, we're getting a lot of these
> messages in our logs. The DB will also occasionally crash now.
>
> Oct 12 07:40:16 postgres[30770]: [3-1] 2007-10-12 07:40:16 PDTERROR: could
> not access status of transaction 2259991368
> Oct 12 07:40:16 postgres[30770]: [3-2] 2007-10-12 07:40:16 PDTDETAIL: Could
> not read from file "pg_clog/086B" at offset 73728: Success.
Got a recent backup?
IT sounds like your db is corrupted, and while recovering some of the
data in it might be possible, it would be better to start over with a
clean backup.
Note that if your database acts like this after a crash, you are
likely running with unreliable fsyncs on your system (either they were
turned on in postgresql.conf or your hardware lies to the OS). That's
bad. A properly built postgresql server should be capable of
recovering from this with no corruption.
From | Date | Subject | |
---|---|---|---|
Next Message | SCassidy | 2007-10-12 15:50:20 | Re: not work in IE |
Previous Message | Jack Orenstein | 2007-10-12 15:28:04 | Missing files under pg_data following power failure |