Re: Server continuously enters to recovery mode.

[Rene Romero Benavides <rene.romero.b@xxxxxxxxx>]

Try dumping the database, you might have a damaged table as in this case:

http://www.postgresql.org/message-id/CAGWYGjWPiffET_K6QVXjjQO_jRQiUEU+BSZr1hurrh1Obv8wyQ@xxxxxxxxxxxxxx

good luck.

2014-05-03 18:59 GMT-05:00 David G Johnston <david.g.johnston@xxxxxxxxx>:

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.


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

--
El genio es 1% inspiración y 99% transpiración.
Thomas Alva Edison
http://pglearn.blogspot.mx/