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

Postmaster 7.1.2 hanging

From: Justin Clift <aa2(at)bigpond(dot)net(dot)au>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Postmaster 7.1.2 hanging
Date: 2001-07-06 04:42:21
Message-ID: 01070614422102.00708@justin (view raw or flat)
Thread:
Lists: pgsql-bugs
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

Responses

pgsql-bugs by date

Next:From: pgsql-bugsDate: 2001-07-06 11:33:57
Subject: Re: Postmaster 7.1.2 hanging
Previous:From: Carl AndersonDate: 2001-07-06 00:27:52
Subject: shared library compile error

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