Re: Backends stuck in LISTEN

On 1/8/14 3:00 PM, Alvaro Herrera wrote:
> Marko Tiikkaja wrote:
>>
>> #0 0x00007f26dd17d5b7 in monstartup () from /lib/x86_64-linux-gnu/libc.so.6
>> #1 0x00007f26d79e5c70 in ?? ()
>> #2 0x00007f26d79e5c80 in ?? ()
>> #3 0x00007f254d772b60 in ?? ()
>> #4 0x00000000006359c5 in LWLockAcquire (lockid=87, mode=LW_SHARED)
>> at /build/buildd/postgresql-9.1-9.1.9/build/../src/backend/storage/lmgr/lwlock.c:464
>
> Hm, looks like either they got stuck trying to activate profiling (but
> then Debian doesn't build its packages with gcc -pg, does it?), or the
> backtrace is flawed for those upper frames. Maybe installing the libc
> -dbg (I imagine it'd be libc6-dbg) package would be useful, if this
> reoccurs.

libc6-dbg only changed it a bit:

#0 0x00007f26dd17d5b7 in __monstartup (lowpc=<optimized out>,
highpc=140737090958784) at gmon.c:130
#1 0x00007f26d79fcae0 in ?? ()
#2 0x00007f26d79fcaf0 in ?? ()
#3 0x00007f254d772aa0 in ?? ()

I still have the core dump available, is there something else I can do?
From what I heard, this is the second time this happened already :-(

Regards,
Marko Tiikkaja