Re: thread hang on execute call - Mailing list pgsql-jdbc

From Pavan Kumar
Subject Re: thread hang on execute call
Date
Msg-id 1144411785.17761.41.camel@pavan.psmw
Whole thread Raw
In response to Re: thread hang on execute call  (Dave Cramer <pg@fastcrypt.com>)
List pgsql-jdbc
i am using spring framework. so all are wrapped up in spring call
it uses apache dbcp for connection pooling

On Fri, 2006-04-07 at 07:26 -0400, Dave Cramer wrote:
> Pavan,
>
> I'd really like to see the java code. It's important to see how you
> are handling the connections, exceptions etc.
>
> Dave
> On 7-Apr-06, at 1:07 AM, Pavan Kumar wrote:
>
> > hi
> > i sending procedure as attachments that is called by java program.
> > please  get it from attachments.
> > i creates 15 worker threads and there is queue for job.
> > worker threads get job from queue if it there and do some db
> > operation.
> > and wait if there is no job in queue. there is another thread that
> > push
> > job in queue.
> > since whole processing takes time.....so worker threads always find
> > job
> > in queue.
> > so they run nonstop and make db call to this procedure.
> > after around 2 days all threads get stuck one bye one.
> > then there is no response from either side.
> > worker thread also do some memory intensive operation  at their side.
> > it could be that threads are running low on memory so then might
> > not be
> > able to respond postgres process. but jvm doesn't show out of memory.
> > and both end are waiting on recv call.
> > please tell me if you need more info or the way i should try to
> > help you
> > people to diagnose problem.
> >
> > Following two line or from logs
> >
> > LOG:  unexpected EOF on client connection
> > LOG:  could not receive data from client: Connection reset by peer
> >
> > well i am not sure when this loggin happened. either after when i
> > killed
> > java process or before it.
> >
> > thanks a lot  for your nice help.
> >
> >
> > On Thu, 2006-04-06 at 18:35 -0400, Dave Cramer wrote:
> >> You're correct it's a guess at this point predicated on the
> >> assumption that it works for many others without this flaw.
> >> On 6-Apr-06, at 5:12 PM, Oliver Jowett wrote:
> >>
> >>> Dave Cramer wrote:
> >>>> This is most certainly a threading issue. The question is now
> >>>> whether  it is in the driver or outside the driver.
> >>>
> >>> Huh? What made you conclude it was definitely a threading issue?
> >>>
> >>> -O
> >>>
> >>> ---------------------------(end of
> >>> broadcast)---------------------------
> >>> TIP 5: don't forget to increase your free space map settings
> >>>
> >>
> >
> > ----------------------------------------------------------------------
> > --
> > Netcore Solutions Pvt. Ltd.
> > Website:  http://www.netcore.co.in
> > Spamtraps: http://cleanmail.netcore.co.in/directory.html
> >
> > Support FAQ : http://support.netcore.co.in/
> >
> > This e-mail contains confidential and/or privileged information. If
> >   you are not the intended recipient (or have received this e-mail in
> >   error)  please notify the sender immediately and delete this e-
> > mail. Any
> >   unauthorized copying, disclosure, use or distribution of the
> > material in
> >   this e-mail is strictly forbidden.
> >
> > ----------------------------------------------------------------------
> > --
> >
> > <sp_addupdateitem.sql>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings


------------------------------------------------------------------------
Netcore Solutions Pvt. Ltd.
Website:  http://www.netcore.co.in
Spamtraps: http://cleanmail.netcore.co.in/directory.html

Support FAQ : http://support.netcore.co.in/

This e-mail contains confidential and/or privileged information. If
  you are not the intended recipient (or have received this e-mail in
  error)  please notify the sender immediately and delete this e-mail. Any
  unauthorized copying, disclosure, use or distribution of the material in
  this e-mail is strictly forbidden.

------------------------------------------------------------------------


pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: thread hang on execute call
Next
From: "Michael Schmidt"
Date:
Subject: pg_dump from Java