From: | David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Server continuously enters to recovery mode. |
Date: | 2014-05-03 23:59:40 |
Message-ID: | 1399161580786-5802322.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
DrakoRod wrote
> Hi everybody!
>
> I have a problem (really huge problem), I have one server of production,
> but yesterday in the night I saw this error:
>
>
*
> ERROR: could not access status of transaction 2410303155
> DETAIL: Could not open file "pg_clog/08FA": No such file or directory
*
>
> Solution:
>
*
> dd if=/dev/zero/ of=data/pg_clog/08FA bs=256K count=1
*
>
>
> So I ran this solutions, no problem so far, but then (after 1 or 2 hours
> approximately), the server crash, I think somebody did something but did
> not tell me, no one did nothing! cool!! ¬¬. I started the server and this
> began in recovery mode, he started. But after some time (without apparent
> pattern), the server came into the recovery mode again.
>
> After that, the server continuously entering recovery mode, like I said
> without apparent pattern, between 3, 5 or 10 minutes run normally but then
> enter in the recovery mode again. I restart the server (began in recovery
> mode again), started, but after sometime he enter in recovery mode again.
>
> Try to recover the server with the PITR and nothing. The server version is
> 9.0.x in a Linux SUSE. The database size is the 336 GB.
>
> Please give me any help to recover the server!
>
> Thanks!
The only help I'm good for on this topic is to tell you to supply log file
data; especially those entries at and just before the server enters recovery
mode.
Good Luck!
David J.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Server-continuously-enters-to-recovery-mode-tp5802321p5802322.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | Tim van der Linden | 2014-05-04 01:26:43 | Normalization in text search ranking |
Previous Message | DrakoRod | 2014-05-03 23:29:01 | Server continuously enters to recovery mode. |