pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Guido Barosio <gbarosio@gmail.com>
To: Cory Vokey <cvokey@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Postgres process terminating
Date: Tue, 14 Mar 2006 20:05:53 +0000
Message-ID: <f7f6b4c70603141205o21020282o8ee32d084cc818a0@mail.gmail.com> (raw)
In-Reply-To: <68df54b40603140654j320d4298hc3cfca58f7993039@mail.gmail.com>
References: <68df54b40603140654j320d4298hc3cfca58f7993039@mail.gmail.com>

Hi Cory,

Actually it seems that the database wasn't shut down properly, and
while it was doing the recovery, it refused connections. Expected and
what needs to happen, indeed.

That's why if you are a client about to connect, you'll recieve the "
FATAL ...database is starting up " message.

Ideally, you (the dba) should let the server end this task (the
recovery). AFAIK, the recovery started as a consecuence of dirty data
somewere, probably a big transaction not comitted when the server went
off.

Are you aware of a shutdown prior to this messages?

Nothing to do with your current issue, but you will receive comments
related with your pgsql version if you are not using a  pgsql 8 :)

Regards
Guido Barosio.
( Shall I confess that I still have some 7.4.2 instances running in production)

On 3/14/06, Cory Vokey <cvokey@gmail.com> wrote:
> Hi all, I'm currently running postgres-7.4.12 with slony-1.0.5 and am seeing
> the below postgres errors:
>
>  Mar 14 00:00:25 master postgres[27357]: [12-1] FATAL:  57P03: the database
> system is starting up
>  Mar 14 00:00:25 master postgres[27357]: [12-2] LOCATION:
> ProcessStartupPacket, postmaster.c:1437
>  Mar 14 00:00:25 master postgres[27356]: [17-1] LOG:  00000: unexpected
> pageaddr 1/55F4A000 in log file 1, segment 183, offset 16031744
>  Mar 14 00:00:25 master postgres[27356]: [17-2] LOCATION:  ValidXLOGHeader,
> xlog.c:2096
>  Mar 14 00:00:25 master postgres[27356]: [18-1] LOG:  00000: redo done at
> 1/B7F49220
>  Mar 14 00:00:25 master postgres[27356]: [18-2] LOCATION:  StartupXLOG,
> xlog.c:2796
>  Mar 14 00:00:26 master postgres[27386]: [11-1] LOG:  00000: connection
> received: host=172.20.42.19 port=54294
>  Mar 14 00:00:26 master postgres[27386]: [11-2] LOCATION:  BackendFork,
> postmaster.c:2395
>  Mar 14 00:00:26 master postgres[27386]: [12-1] FATAL:  57P03: the database
> system is starting up
>  Mar 14 00:00:26 master postgres[27386]: [12-2] LOCATION:
> ProcessStartupPacket, postmaster.c:1437
>  Mar 14 00:00:26 master postgres[27387]: [11-1] LOG:  00000: connection
> received: host=172.20.42.19 port=54295
>  Mar 14 00:00:26 master postgres[27387]: [11-2] LOCATION:  BackendFork,
> postmaster.c:2395
>  Mar 14 00:00:26 master postgres[27387]: [12-1] FATAL:  57P03: the database
> system is starting up
>  Mar 14 00:00:26 master postgres[27387]: [12-2] LOCATION:
> ProcessStartupPacket, postmaster.c:1437
>  Mar 14 00:00:26 master postgres[27388]: [11-1] LOG:  00000: connection
> received: host=172.20.42.20 port=38111
>  Mar 14 00:00:26 master postgres[27388]: [11-2] LOCATION:  BackendFork,
> postmaster.c:2395
>  Mar 14 00:00:26 master postgres[27388]: [12-1] FATAL:  57P03: the database
> system is starting up
>  Mar 14 00:00:26 master postgres[27388]: [12-2] LOCATION:
> ProcessStartupPacket, postmaster.c:1437
>  Mar 14 00:00:26 master postgres[27389]: [11-1] LOG:  00000: connection
> received: host=172.20.42.20 port=38112
>  Mar 14 00:00:26 master postgres[27389]: [11-2] LOCATION:  BackendFork,
> postmaster.c:2395
>  Mar 14 00:00:26 master postgres[27389]: [12-1] FATAL:  57P03: the database
> system is starting up
>  Mar 14 00:00:26 master postgres[27389]: [12-2] LOCATION:
> ProcessStartupPacket, postmaster.c:1437
>  Mar 14 00:00:26 master postgres[27392]: [11-1] LOG:  00000: connection
> received: host=172.20.42.19 port=54297
>  Mar 14 00:00:26 master postgres[27392]: [11-2] LOCATION:  BackendFork,
> postmaster.c:2395
>  Mar 14 00:00:26 master postgres[27392]: [12-1] FATAL:  57P03: the database
> system is starting up
>  Mar 14 00:00:26 master postgres[27392]: [12-2] LOCATION:
> ProcessStartupPacket, postmaster.c:1437
>  Mar 14 00:00:26 master postgres[27393]: [11-1] LOG:  00000: connection
> received: host=172.20.42.19 port=54298
>  Mar 14 00:00:26 master postgres[27393]: [11-2] LOCATION:  BackendFork,
> postmaster.c:2395
>  Mar 14 00:00:26 master postgres[27393]: [12-1] FATAL:  57P03: the database
> system is starting up
>
>  This causes slony to die on all clusters as well as our web applications.
>
>  In google'ing for "FATAL:  57P03: the database system is starting up" I
> noticed other people having similar issues but I not been able to locate a
> fix.
>
>  This morning I dropped all slony schema's  from the database and am
> continuing to re-create my clusters one by one and have not seeing these
> errors thus far.
>
>  What I am interested in is a description of the above error log.
>
>  Any help is appreciated!
>
>  Thanks.
>
>
> --
> Cory Vokey


--
/"\   ASCII Ribbon Campaign  .
\ / - NO HTML/RTF in e-mail  .
 X  - NO Word docs in e-mail .
/ \ -----------------------------------------------------------------



view thread (5+ messages)  latest in thread

Message-ID: <f7f6b4c70603141205o21020282o8ee32d084cc818a0@mail.gmail.com>
Permalink:  ../f7f6b4c70603141205o21020282o8ee32d084cc818a0@mail.gmail.com/
Also on:    postgresql.org/message-id/f7f6b4c70603141205o21020282o8ee32d084cc818a0@mail.gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: gbarosio@gmail.com, cvokey@gmail.com
  Subject: Re: Postgres process terminating
  In-Reply-To: <f7f6b4c70603141205o21020282o8ee32d084cc818a0@mail.gmail.com>
  References: <68df54b40603140654j320d4298hc3cfca58f7993039@mail.gmail.com> <f7f6b4c70603141205o21020282o8ee32d084cc818a0@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox