Oliver Hitz wrote:
> On 07 May 2009, Oliver Jowett wrote:
>> No it isn't, go look at the thread dumps, his application is blocking on
>> read not on write.
>
> The strange thing is that I didn't see anything at the backend. All
> connections were idle at that time. If the application was hanging
> because of a transaction lock, shouldn't I see this in pg_locks or
> pg_stat_activity?
>
> Anyway, I have changed some transactions and re-arranged some of the
> code. The application is running for about four days now without a hang,
> but I'm not sure if the problem has really gone away.
Yes, it seems quite strange .. Probably you would need to attach a
debugger to the server process corresponding to the hung application
thread and see what it was doing, but that might be tricky to arrange.
-O