Postmaster 7.1.2 hanging
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
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:
Show quoted text
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 -iSo, 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
Import Notes
Resolved by subject fallback
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
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:
Show quoted text
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