pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Cory Vokey <cvokey@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Postgres process terminating
Date: Tue, 14 Mar 2006 08:54:01 -0600
Message-ID: <68df54b40603140654j320d4298hc3cfca58f7993039@mail.gmail.com> (raw)

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

view thread (5+ messages)  latest in thread

Message-ID: <68df54b40603140654j320d4298hc3cfca58f7993039@mail.gmail.com>
Permalink:  ../68df54b40603140654j320d4298hc3cfca58f7993039@mail.gmail.com/
Also on:    postgresql.org/message-id/68df54b40603140654j320d4298hc3cfca58f7993039@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: cvokey@gmail.com
  Subject: Re: Postgres process terminating
  In-Reply-To: <68df54b40603140654j320d4298hc3cfca58f7993039@mail.gmail.com>
  References: <68df54b40603140654j320d4298hc3cfca58f7993039@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