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
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 |