Thread: Postmaster 7.1.2 hanging

Postmaster 7.1.2 hanging

From
Justin Clift
Date:
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

Re: Postmaster 7.1.2 hanging

From
"pgsql-bugs"
Date:
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@bigpond.net.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

Re: Postmaster 7.1.2 hanging

From
Tom Lane
Date:
Justin Clift <aa2@bigpond.net.au> writes:
> Just did a :
> pg_ctl stop -m fast
> And the postmaster process won't die.

Can't duplicate it here.  Can you attach to the postmaster process with
a debugger and see what it thinks its state is?  The static variables in
postmaster.c are the things to look at.  Are there still entries
in BackendList?  Are any of StartupPID, ShutdownPID, CheckPointPID
nonzero?  What's the value of Shutdown?  Etc.

            regards, tom lane

Re: Postmaster 7.1.2 hanging

From
Justin Clift
Date:
Hi Tom,

I had to kill -9 the postmaster process and go from there about 2
minutes after sending that email.  Although the data wasn't important,
the availability of PostgreSQL on the server was.  Had to get it up and
running again asap.

If it happens again, I'll attach a debugger to the postmaster process as
you've suggested and see what it thinks is going on.

:-)

Regards and best wishes,

Justin Clift

Tom Lane wrote:
>
> Justin Clift <aa2@bigpond.net.au> writes:
> > Just did a :
> > pg_ctl stop -m fast
> > And the postmaster process won't die.
>
> Can't duplicate it here.  Can you attach to the postmaster process with
> a debugger and see what it thinks its state is?  The static variables in
> postmaster.c are the things to look at.  Are there still entries
> in BackendList?  Are any of StartupPID, ShutdownPID, CheckPointPID
> nonzero?  What's the value of Shutdown?  Etc.
>
>                         regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly