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-04-28 19:55:40
Message-ID: 20090428195540.GA21951@net-track.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On 28 Apr 2009, Oliver Hitz wrote:
> Anything else that I could try? I will try if loglevel=2 results in some
> useful output now.

Ok now here's a query that hangs after it has been sent. Right after
"Sync" the program hangs:

19:24:45.594 (172) simple execute, handler=org(dot)postgresql(dot)jdbc2(dot)AbstractJdbc2Statement$StatementResultHandler(at)d7e2b57, maxRows=0, fetchSize=0, flags=17
19:24:45.594 (172) FE=> Parse(stmt=null,query="SELECT changes.what,changes.whenchanged FROM changes WHERE what=$1 AND whenchanged>$2",oids={1043,0})
19:24:45.594 (172) FE=> Bind(stmt=null,portal=null,$1=<'docsiscmts'>,$2=<'2009-04-28 13:41:32.425000 +02:00:00'>)
19:24:45.594 (172) FE=> Describe(portal=null)
19:24:45.594 (172) FE=> Execute(portal=null,limit=0)
19:24:45.594 (172) FE=> Sync

Nothing special on the backend. From what I can see, all processes are in
idle state.

Any idea what could be wrong here?

Thanks in advance,

Oliver

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Jordan 2009-04-28 19:58:49 Begginer JDBC
Previous Message Oliver Jowett 2009-04-28 15:21:01 Re: Very strange performance decrease when reusing a PreparedStatement