X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 4129F9DCC36 for ; Tue, 14 Mar 2006 16:05:56 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 07877-01 for ; Tue, 14 Mar 2006 16:05:56 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from uproxy.gmail.com (uproxy.gmail.com [66.249.92.199]) by postgresql.org (Postfix) with ESMTP id A4CC59DCC2E for ; Tue, 14 Mar 2006 16:05:53 -0400 (AST) Received: by uproxy.gmail.com with SMTP id k40so791293ugc for ; Tue, 14 Mar 2006 12:05:53 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=jDizjtxFV3L5z9v4yCjlqJXYtHy8s2jfPU0qg8OiBAl0qDvFZEaa2FBeVNFBrejzasXxuuL5wEiiCNA5aYon2T1XZeXuXFb0oxyoPXKLTetRPXcK4A4vnqdAwwz7UWaDbkeaOkoe5SpK8tTG2trrCTgo6BbjhwgDjv9dnSNxIyY= Received: by 10.67.19.6 with SMTP id w6mr799112ugi; Tue, 14 Mar 2006 12:05:53 -0800 (PST) Received: by 10.67.27.10 with HTTP; Tue, 14 Mar 2006 12:05:53 -0800 (PST) Message-ID: Date: Tue, 14 Mar 2006 20:05:53 +0000 From: "Guido Barosio" To: "Cory Vokey" Subject: Re: Postgres process terminating Cc: pgsql-admin@postgresql.org In-Reply-To: <68df54b40603140654j320d4298hc3cfca58f7993039@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <68df54b40603140654j320d4298hc3cfca58f7993039@mail.gmail.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.22 required=5 tests=[AWL=0.220] X-Spam-Score: 0.22 X-Spam-Level: X-Archive-Number: 200603/116 X-Sequence-Number: 20873 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 product= ion) On 3/14/06, Cory Vokey wrote: > Hi all, I'm currently running postgres-7.4.12 with slony-1.0.5 and am see= ing > the below postgres errors: > > Mar 14 00:00:25 master postgres[27357]: [12-1] FATAL: 57P03: the databa= se > 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: ValidXLOGHeade= r, > 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=3D172.20.42.19 port=3D54294 > 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 databa= se > 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=3D172.20.42.19 port=3D54295 > 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 databa= se > 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=3D172.20.42.20 port=3D38111 > 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 databa= se > 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=3D172.20.42.20 port=3D38112 > 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 databa= se > 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=3D172.20.42.19 port=3D54297 > 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 databa= se > 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=3D172.20.42.19 port=3D54298 > 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 databa= se > 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 . / \ -----------------------------------------------------------------