From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
---|---|
To: | dhaval jaiswal <dhavallj(at)hotmail(dot)com> |
Cc: | "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: Hung thread |
Date: | 2014-10-28 12:14:19 |
Message-ID: | CADK3HHJVvgFAXniBL55Yq832cgpkKefppGLqtRGGSNT5=O9zyA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Given the little bit of information available my guess would be that since
this is using dbcp, and the connections are never really closed. I believe
once a connection is made we are always listening on the socket. So this
isn't really a hung thread, rather it is a thread that is listening for any
incoming activity.
However I will say I haven't really spent much time on this. Either way we
would need much more information in order to be able to help you.
Can you replicate the problem? What were you trying to do that you
concluded this thread is hung ?
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On 28 October 2014 07:34, dhaval jaiswal <dhavallj(at)hotmail(dot)com> wrote:
> Any update on the below thread.
>
> ------------------------------
> From: dhavallj(at)hotmail(dot)com
> To: pgsql-jdbc(at)postgresql(dot)org
> Subject: Hung thread
> Date: Thu, 23 Oct 2014 15:05:30 +0530
>
>
> This question might some one has asked but did not get the proper
> resolution in any thread. Henceforth posting.
>
> I am facing the issue of the hung thread initiated from tomcat
> (application server tomcat 6.0) to the database (postgresql 9.0). Using
> JDBC driver 9.0.
>
> From the logs of the application server found it happened some time only.
> Following is the thread dump taken at the time of hung thread. Moreover,
> there is no query stuck at the database level. In one of the forum i saw
> it might be because of the JDBC driver. Please share your thoughts on this
> issue. I checked there is no network level interruption.
>
> java.lang.Thread.State: RUNNABLE
> at java.net.SocketInputStream.socketRead0(Native Method)
> at java.net.SocketInputStream.read(SocketInputStream.java:129)
> at
> org.postgresql.core.VisibleBufferedInputStream.readMore(VisibleBufferedInputStream.java:145)
> at
> org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:114)
> at
> org.postgresql.core.VisibleBufferedInputStream.read(VisibleBufferedInputStream.java:73)
> at org.postgresql.core.PGStream.ReceiveChar(PGStream.java:274)
> at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1660)
> at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
> - locked <0x00002aaaf6282d00> (a
> org.postgresql.core.v3.QueryExecutorImpl)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)
> at
> org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
> at
> org.apache.tomcat.dbcp.dbcp.AbandonedObjectPool.borrowObject(AbandonedObjectPool.java:84)
> at
> org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96)
> at
> org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
> at
> com.eos.hotels.viahotel.manager.ViaHotelDatabaseManager.getConnection(ViaHotelDatabaseManager.java:74)
> at
> com.eos.hotels.viahotel.manager.ViaHotelDatabaseManager.getConnection(ViaHotelDatabaseManager.java:59)
> at
> com.eos.marketplace.data.MarketPlaceHotel.getHotelById(MarketPlaceHotel.java:749)
> at
> com.eos.hotels.apis.gta.GTAHotelBookingData.populateOrderItem(GTAHotelBookingData.java:334)
> at
> com.eos.hotels.viahotel.data.book.ViaAPIHotelBookingData.createOrder(ViaAPIHotelBookingData.java:531)
> at
> com.eos.hotels.apis.gta.GTAHotelBookingData.process(GTAHotelBookingData.java:407)
> at com.eos.b2c.beans.SkuBean.skuHotelBooking(SkuBean.java:902)
> at com.eos.b2c.beans.SkuBean.skuHotelBooking(SkuBean.java:873)
> at
> com.eos.b2c.ui.ResellerNavigation.doGet(ResellerNavigation.java:2237)
> at
> com.eos.b2c.ui.ResellerNavigation.doPost(ResellerNavigation.java:579)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> com.eos.accounts.UserManagerFilter.doFilter(UserManagerFilter.java:584)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
> at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
> at
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:568)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
> at
> org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:856)
> at
> org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:565)
> at
> org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1509)
> at java.lang.Thread.run(Thread.java:619)
>
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2014-10-28 14:28:16 | Re: Hung thread |
Previous Message | dhaval jaiswal | 2014-10-28 11:34:23 | Re: Hung thread |