From: | Daniel Migowski <dmigowski(at)ikoffice(dot)de> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: Thread hangs in VisibleBufferedInputStream.readMore |
Date: | 2009-05-07 06:56:29 |
Message-ID: | 4A02861D.1070505@ikoffice.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Hello Oliver,
This is a problem with a full receive buffer on the client side blocking
the server from writing more results while the client tries to send more
commands to server. Either split your server input into several single
statements or increase the receive buffer size of your client.
Daniel Migowski
PS: I'd like this problem to be solved, too, but this would need either
a multithreaded driver, or some timeout handling within the driver, both
coming with some small performance losses. Maybe an option should be
added to the driver here...
Oliver Hitz schrieb:
> 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 | Oliver Jowett | 2009-05-07 07:29:11 | Re: Thread hangs in VisibleBufferedInputStream.readMore |
Previous Message | Tom Lane | 2009-05-06 22:39:08 | Re: Very strange performance decrease when reusing a PreparedStatement |