Skip site navigation (1) Skip section navigation (2)

Re: Thread hangs in VisibleBufferedInputStream.readMore

From: Oliver Hitz <oliver(at)net-track(dot)ch>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Thread hangs in VisibleBufferedInputStream.readMore
Date: 2009-05-07 11:59:19
Message-ID: 20090507115919.GC28635@net-track.ch (view raw or flat)
Thread:
Lists: pgsql-jdbc
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.

Oliver

In response to

Responses

pgsql-jdbc by date

Next:From: Oliver JowettDate: 2009-05-07 12:10:49
Subject: Re: Thread hangs in VisibleBufferedInputStream.readMore
Previous:From: Simon RiggsDate: 2009-05-07 08:45:51
Subject: Re: Very strange performance decrease when reusing aPreparedStatement

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group