Postgres Pro
Downloads
Home   >   mailing lists

Re: Hang in semop() in 'waiting' backends - Mailing list pgsql-admin

From Tom Lane
Subject Re: Hang in semop() in 'waiting' backends
Date
Msg-id 13350.1112846404@sss.pgh.pa.us
Whole thread Raw
In response to Hang in semop() in 'waiting' backends  (Robert Fielding <rob@dsvr.net>)
List pgsql-admin
Tree view 
Robert Fielding <rob@dsvr.net> writes:
> strace shows:
> semop(19529737, 0xbfffe020, 1

Can you attach to a few of the stuck processes with gdb and get stack
traces?  Are they all doing exactly the same query when they hang?

            regards, tom lane

pgsql-admin by date:

Previous
From: Robert Fielding
Date:
Subject: Hang in semop() in 'waiting' backends
Next
From: "Jim C. Nasby"
Date:
Subject: Re: delete to slow