Search Postgresql Archives

Re: DB fails to start: "Could not read from file "pg_clog/0003" at offset 212992: No error.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Olga Vingurt <olgavi@xxxxxxxxxxxxxx>
Subject: Re: DB fails to start: "Could not read from file "pg_clog/0003" at offset 212992: No error.
From: raghu ram <raghuchennuru@xxxxxxxxx>
Date: Mon, 16 Jul 2012 19:25:56 +0530
Cc: "pgsql-general@xxxxxxxxxxxxxx" <pgsql-general@xxxxxxxxxxxxxx>, Ofer Israeli <oferi@xxxxxxxxxxxxxx>
In-reply-to: <A305A29309C1274FAA7A0FED4F1F75666EBFF0B313@il-ex01.ad.checkpoint.com>

On Mon, Jul 16, 2012 at 5:44 PM, Olga Vingurt <olgavi@xxxxxxxxxxxxxx> wrote:

Hi,

We are using PostgreSQL 8.3 on Windows Server.

The db crashed and now it fails to start up.

The error is:

FATAL: could not access status of transaction 4020264

DETAIL: Could not read from file "pg_clog/0003" at offset 212992: No error.

Additional log from event viewer:

LOG: database system was interrupted; last known up at 2012-07-12 11:35:00 CEST

How can we recover from the current state?

Please perform below steps:

1. Backup the current pg_clog/0003 file in different directory

2. Create a file by assumption of make the uncommitted record as they haven't been committed. command as follows:

dd if=/dev/zero of=<data directory location>/pg_clog/0003 bs=256K count=1

3. Start the Cluster

Thanks & Regards,

Raghu Ram

EnterpriseDB Corporation

Blog:http://raghurc.blogspot.in/

Follow-Ups:
- Re: DB fails to start: "Could not read from file "pg_clog/0003" at offset 212992: No error.
  - From: Craig Ringer
- Re: DB fails to start: "Could not read from file "pg_clog/0003" at offset 212992: No error.
  - From: Raghavendra

References:
- DB fails to start: "Could not read from file "pg_clog/0003" at offset 212992: No error.
  - From: Olga Vingurt

Prev by Date: Replication terminated by primary server
Next by Date: Re: DB fails to start: "Could not read from file "pg_clog/0003" at offset 212992: No error.
Previous by thread: DB fails to start: "Could not read from file "pg_clog/0003" at offset 212992: No error.
Next by thread: Re: DB fails to start: "Could not read from file "pg_clog/0003" at offset 212992: No error.
Index(es):
- Date
- Thread

[Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Programming PHP] [Kernel Newbies] [PHP Classes] [Find Someone Nice] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]