Re: Postgres 7.4.6 hang in async_notify - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Postgres 7.4.6 hang in async_notify
Date
Msg-id 25761.1114467638@sss.pgh.pa.us
Whole thread Raw
In response to Postgres 7.4.6 hang in async_notify  (pgsql-bugs@counterstorm.com)
List pgsql-bugs
pgsql-bugs@counterstorm.com writes:
> We have seen this twice.  The first time, it was on a 32 bit Fedora
> Core 3 system during a `postgres stop`.  The stop hung because one of
> the processes was in async_notify and refused to get out.  We were
> unable to do further debugging because the db was in shutdown.  We
> were forced to kill -9 the process.

Next time try attaching to the stuck backend with gdb so you can get
a stack trace.  It's difficult to speculate what could be wrong without
a better-localized idea of where it's hanging.  It'd be a good idea to
rebuild with --enable-debug so that the stack trace will be most useful
when you get it.

            regards, tom lane

pgsql-bugs by date:

Previous
From: pgsql-bugs@counterstorm.com
Date:
Subject: Re: Postgres 7.4.6 hang in async_notify
Next
From: "Dennis Vshivkov"
Date:
Subject: BUG #1626: Minimum documented values aren't accepted for all basic integer types