Re: Hung thread - Mailing list pgsql-jdbc
| From | Dave Cramer |
|---|---|
| Subject | Re: Hung thread |
| Date | |
| Msg-id | CADK3HHJVvgFAXniBL55Yq832cgpkKefppGLqtRGGSNT5=O9zyA@mail.gmail.com Whole thread Raw |
| In response to | Re: Hung thread (dhaval jaiswal <dhavallj@hotmail.com>) |
| Responses |
Re: Hung thread
(Kevin Grittner <kgrittn@ymail.com>)
|
| List | 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 ?
On 28 October 2014 07:34, dhaval jaiswal <dhavallj@hotmail.com> wrote:
Any update on the below thread.
From: dhavallj@hotmail.com
To: pgsql-jdbc@postgresql.org
Subject: Hung thread
Date: Thu, 23 Oct 2014 15:05:30 +0530This 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)
pgsql-jdbc by date: