Re: hung postmaster?

On Wednesday February 16 2005 3:38, Martijn van Oosterhout wrote:
> On Wed, Feb 16, 2005 at 11:41:35AM -0700, Ed L. wrote:
> > Question:  Am I doing all I can to avoid corruption with the
> > following procedure to shutdown a 7.4.6 cluster with a hung
> > postmaster?  Suggestions?
>
> What is the state of the processes in ps? D, S, R, ?? That
> should at least give a hint as to what it *is* doing...

The postmasters were sleeping.  I was able to trace a local hung 
psql client through lsof-->netstat to see the connection was in 
tcp "ESTABLISHED" state.

Anyway, before we installed gdb (wdb) from hp dvd to get a 
backtrace, I'd already guessed it could be a problem with the 
build since the 7.4.6 build that was hanging was built with gcc 
3.2.2, while the 7.4.6 builds on two other identical boxes were 
built with gcc 3.4.2.  So we shutdown all the 7.4.6 clusters, 
rebuilt using gcc 3.4.2, identical build steps AFAICS, and this 
nasty problem has apparently gone away (knock on wood).

I have saved a copy of the problematic gcc-3.2.2-built 7.4.6 
installation executables, libraries, etc. in case anyone is 
interested.  Time permitting, I may fire them up with a new 
cluster and see if I can recreate the problem to get a 
backtrace.

Thanks.

Ed