X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 8457BD1DEB3 for ; Thu, 26 Feb 2004 14:46:11 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 51238-05 for ; Thu, 26 Feb 2004 10:46:13 -0400 (AST) Received: from server.postman.co.za (server.postman.co.za [196.15.137.155]) by svr1.postgresql.org (Postfix) with ESMTP id 8DED7D1DD00 for ; Thu, 26 Feb 2004 10:46:06 -0400 (AST) Received: from gert (localhost.localdomain [127.0.0.1]) by server.postman.co.za (8.11.6/8.11.6) with SMTP id i1QEk8R27487 for ; Thu, 26 Feb 2004 16:46:08 +0200 Message-ID: <09ea01c3fc77$42797630$1002a8c0@gert> From: "Barry" To: Subject: postgres crashes Date: Thu, 26 Feb 2004 16:46:03 +0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_09E7_01C3FC88.05C208E0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2720.3000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2727.1300 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/357 X-Sequence-Number: 12531 This is a multi-part message in MIME format. ------=_NextPart_000_09E7_01C3FC88.05C208E0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi All After running for a couple of days, my postgres server crashes. When I do a /etc/init.d/postgresql status, I get unused. And when I then try and start it, it fails. Only a reboot helps. Here's my /var/log/postgres : DEBUG: database system is ready ERROR: Relation "cleared" does not exist DEBUG: pq_recvbuf: unexpected EOF on client connection Lock file "/var/lib/pgsql/data/postmaster.pid" already exists. Is another postmaster (pid 1658) running in "/var/lib/pgsql/data"? Lock file "/var/lib/pgsql/data/postmaster.pid" already exists. Is another postmaster (pid 1658) running in "/var/lib/pgsql/data"? Lock file "/tmp/.s.PGSQL.5432.lock" already exists. Is another postmaster (pid 1658) using "/tmp/.s.PGSQL.5432"? /usr/bin/postmaster: cannot create UNIX stream port DEBUG: database system was interrupted at 2004-02-16 16:35:09 CET DEBUG: checkpoint record is at 0/28549D8 DEBUG: redo record is at 0/28549D8; undo record is at 0/0; shutdown FALSE DEBUG: next transaction id: 54058; next oid: 74008 DEBUG: database system was not properly shut down; automatic recovery in p= rogress DEBUG: ReadRecord: record with zero length at 0/2854A18 DEBUG: redo is not required DEBUG: database system is ready Lock file "/var/lib/pgsql/data/postmaster.pid" already exists. Is another postmaster (pid 1647) running in "/var/lib/pgsql/data"? DEBUG: database system was interrupted at 2004-02-25 13:16:13 CET DEBUG: checkpoint record is at 0/2854A18 DEBUG: redo record is at 0/2854A18; undo record is at 0/0; shutdown TRUE DEBUG: next transaction id: 54058; next oid: 74008 DEBUG: database system was not properly shut down; automatic recovery in p= rogress DEBUG: ReadRecord: record with zero length at 0/2854A58 DEBUG: redo is not required DEBUG: database system is ready Lock file "/var/lib/pgsql/data/postmaster.pid" already exists. Is another postmaster (pid 1647) running in "/var/lib/pgsql/data"? Lock file "/var/lib/pgsql/data/postmaster.pid" already exists. Is another postmaster (pid 1647) running in "/var/lib/pgsql/data"? DEBUG: database system was interrupted at 2004-02-25 16:29:54 CET DEBUG: checkpoint record is at 0/2854A58 DEBUG: redo record is at 0/2854A58; undo record is at 0/0; shutdown TRUE DEBUG: next transaction id: 54058; next oid: 74008 DEBUG: database system was not properly shut down; automatic recovery in p= rogress DEBUG: ReadRecord: record with zero length at 0/2854A98 DEBUG: redo is not required DEBUG: database system is ready Any pointers would be much appreciated. Thanks Barry ------=_NextPart_000_09E7_01C3FC88.05C208E0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi All
 
After running for a couple of days, m= y=20 postgres server crashes.
When I do a /etc/init.d/postgresql status,= I get=20 unused.
And when I then try and start it, it fails= . Only a=20 reboot helps.
Here's my /var/log/postgres :
 
DEBUG:  database system is=20 ready
ERROR:  Relation "cleared" does not exist
DEBUG: =20 pq_recvbuf: unexpected EOF on client connection
Lock file=20 "/var/lib/pgsql/data/postmaster.pid" already exists.
Is another postmast= er=20 (pid 1658) running in "/var/lib/pgsql/data"?
Lock file=20 "/var/lib/pgsql/data/postmaster.pid" already exists.
Is another postmast= er=20 (pid 1658) running in "/var/lib/pgsql/data"?
Lock file=20 "/tmp/.s.PGSQL.5432.lock" already exists.
Is another postmaster (pid 165= 8)=20 using "/tmp/.s.PGSQL.5432"?
/usr/bin/postmaster: cannot create UNIX stre= am=20 port
DEBUG:  database system was interrupted at 2004-02-16 16:35:09= =20 CET
DEBUG:  checkpoint record is at 0/28549D8
DEBUG:  redo= =20 record is at 0/28549D8; undo record is at 0/0; shutdown FALSE
DEBUG:&nbs= p;=20 next transaction id: 54058; next oid: 74008
DEBUG:  database system= was=20 not properly shut down; automatic recovery in progress
DEBUG: =20 ReadRecord: record with zero length at 0/2854A18
DEBUG:  redo is no= t=20 required
DEBUG:  database system is ready
Lock file=20 "/var/lib/pgsql/data/postmaster.pid" already exists.
Is another postmast= er=20 (pid 1647) running in "/var/lib/pgsql/data"?
DEBUG:  database syste= m was=20 interrupted at 2004-02-25 13:16:13 CET
DEBUG:  checkpoint record is= at=20 0/2854A18
DEBUG:  redo record is at 0/2854A18; undo record is at 0/= 0;=20 shutdown TRUE
DEBUG:  next transaction id: 54058; next oid:=20 74008
DEBUG:  database system was not properly shut down; automatic= =20 recovery in progress
DEBUG:  ReadRecord: record with zero length at= =20 0/2854A58
DEBUG:  redo is not required
DEBUG:  database sys= tem=20 is ready
Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.<= BR>Is=20 another postmaster (pid 1647) running in "/var/lib/pgsql/data"?
Lock fil= e=20 "/var/lib/pgsql/data/postmaster.pid" already exists.
Is another postmast= er=20 (pid 1647) running in "/var/lib/pgsql/data"?
DEBUG:  database syste= m was=20 interrupted at 2004-02-25 16:29:54 CET
DEBUG:  checkpoint record is= at=20 0/2854A58
DEBUG:  redo record is at 0/2854A58; undo record is at 0/= 0;=20 shutdown TRUE
DEBUG:  next transaction id: 54058; next oid:=20 74008
DEBUG:  database system was not properly shut down; automatic= =20 recovery in progress
DEBUG:  ReadRecord: record with zero length at= =20 0/2854A98
DEBUG:  redo is not required
DEBUG:  database sys= tem=20 is ready
Any pointers would be much=20 appreciated.
 
Thanks
Barry
------=_NextPart_000_09E7_01C3FC88.05C208E0--