Re: The database system is in recovery mode - Mailing list pgsql-admin

From Tom Lane
Subject Re: The database system is in recovery mode
Date
Msg-id 17004.1052001841@sss.pgh.pa.us
Whole thread Raw
In response to The database system is in recovery mode  (Trevor Astrope <astrope@e-corp.net>)
List pgsql-admin
Trevor Astrope <astrope@e-corp.net> writes:
>  Could this be the linux kernel randomly killing processes under heavy
> load issue?

I concur with the other respondent who pointed out that the kernel uses
signal 9, not 11, when it wants to kill something.  A check for marginal
hardware seems in order.

> Then after the machine is rebooted and while it is starting up, there is
> these messages:

> 2003-05-01 17:35:49 DEBUG:  ReadRecord: unexpected pageaddr 21/37D94000 in log file 33, segment 63, offset 14237696
> 2003-05-01 17:35:49 DEBUG:  redo done at 21/3FD92564

> I presume this is rerunning the WAL? Is the message serious...could there
> be database corruption or just lost transactions?

That message is expected if the old WAL happened to end exactly on a
page boundary --- which is somewhat unlikely, but certainly not
implausible.  I don't think you lost anything.

            regards, tom lane


pgsql-admin by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: md5 in postgres 7.3
Next
From: Bob Hartung
Date:
Subject: How to recover error message at boot time?