Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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


pgsql-bugs by date

Next:From: Tom LaneDate: 2001-07-06 13:21:38
Subject: Re: Postmaster 7.1.2 hanging
Previous:From: Justin CliftDate: 2001-07-06 04:42:21
Subject: Postmaster 7.1.2 hanging

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group