Skip site navigation (1) Skip section navigation (2)

Endless recovery

From: Hans-Juergen Schoenig <postgres(at)cybertec(dot)at>
To: pgsql-patches(at)postgresql(dot)org
Subject: Endless recovery
Date: 2008-02-11 08:29:39
Message-ID: 12208CE8-238D-4D39-948A-F67427B891D1@cybertec.at (view raw or flat)
Thread:
Lists: pgsql-patches
Last week we have seen a problem with some horribly configured machine.
The disk filled up (bad FSM ;) ) and once this happened the sysadmi  
killed the system (-9).
After two days PostgreSQL has still not started up and they tried to  
restart it again and again making sure that the consistency check was  
started over an over again (thus causing more and more downtime).
 From the admi point of view there was no way to find out whether the  
machine was actually dead or still recovering.

Here is a small patch which issues a log message indicating that the  
recovery process can take ages.
Maybe this can prevent some admis from interrupting the recovery  
process.

In our case, the recovery process took 3.5 days !!

	best regards,

		hans





--
Cybertec Schönig & Schönig GmbH
PostgreSQL Solutions and Support
Gröhrmühlgasse 26, 2700 Wiener Neustadt
Tel: +43/1/205 10 35 / 340
www.postgresql.at, www.cybertec.at


Responses

pgsql-patches by date

Next:From: Heikki LinnakangasDate: 2008-02-11 09:26:08
Subject: Re: Endless recovery
Previous:From: Tom LaneDate: 2008-02-10 23:37:12
Subject: Re: NUMERIC key word

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group