Re: Postmaster 7.1.2 hanging

From: "pgsql-bugs" <pgsql-bugs(at)fc(dot)emc(dot)com(dot)ph>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Postmaster 7.1.2 hanging
Date: 2001-07-06 11:33:57
Message-ID: fc.000f567200cc871f000f567200cc871f.cc877e@fc.emc.com.ph
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

I also had this experience in Mandrake 8.0 after the postgresql 7.1.2
installation.
I modified postgresql.conf and stopped the service.
I looked at the initscript and it seem like "/usr/bin/pg_ctl stop -D
$PGDATA -s -m fast"
can't stop the daemon. Kill -15 did the job.

sherwin

aa2(at)bigpond(dot)net(dot)au writes:
>Hi all,
>
>Running Mandrake 7.2, personally compiled version of PostgreSQL 7.1.2.
>
>Just did a :
>
>pg_ctl stop -m fast
>
>And the postmaster process won't die.
>
>Waited for about 2 minutes, then sent a normal everyday kill signal to
>the
>postmaster process from the root user (just in case). Haven't done a
>kill 9.
>
>The last part of the postgresql log is :
>
>pq_recvbuf: unexpected EOF on client connection
>ERROR: <unnamed> referential integrity violation - key referenced from
>goods_bought not found in goods
>pq_recvbuf: unexpected EOF on client connection
>pq_recvbuf: unexpected EOF on client connection
>pq_recvbuf: unexpected EOF on client connection
>pq_recvbuf: unexpected EOF on client connection
>Fast Shutdown request at Fri Jul 6 14:33:57 2001
>Aborting any active transaction...
>FATAL 1: This connection has been terminated by the administrator.
>
>I shutdown the Tomcat process before doing any of this, so I'm thinking
>that's the cause of the unexpected EOF's just before this.
>
>When using "ps -ef" I get this listing of the PostgreSQL processes :
>
>postgres 16067 1 0 Jul04 ? 00:00:07
>/opt/postgresql/bin/postmaster -D /opt/postgresql/data -d 0 -i
>
>So, any ideas what's jamming the database on?
>
>This isn't urgent, it's a development database I have plenty of recent
>backups of, more to let people know it's happening.
>
>Regards and best wishes,
>
>Justin Clift

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2001-07-06 13:21:38 Re: Postmaster 7.1.2 hanging
Previous Message Justin Clift 2001-07-06 04:42:21 Postmaster 7.1.2 hanging