Return-Path: Mailing-List: contact commons-dev-help@jakarta.apache.org; run by ezmlm Delivered-To: mailing list commons-dev@jakarta.apache.org Received: (qmail 29605 invoked from network); 28 Aug 2003 14:58:31 -0000 Received: from unknown (HELO exchange.sun.com) (192.18.33.10) by daedalus.apache.org with SMTP; 28 Aug 2003 14:58:31 -0000 Received: (qmail 16952 invoked by uid 50); 28 Aug 2003 13:11:55 -0000 Date: 28 Aug 2003 13:11:55 -0000 Message-ID: <20030828131155.16951.qmail@nagoya.betaversion.org> From: bugzilla@apache.org To: commons-dev@jakarta.apache.org Cc: Subject: DO NOT REPLY [Bug 22736] - validationQuery parameter hangs getConnection method. X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT . ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE. http://nagoya.apache.org/bugzilla/show_bug.cgi?id=22736 validationQuery parameter hangs getConnection method. ------- Additional Comments From sudhir@myway.com 2003-08-28 13:11 ------- I think I isolated the issue that was causing the thread to wait indefinitely. I change the query from SELECT (seq_policyid) FROM SEQUENCE_NUMBER TO SELECT MAX(seq_policyid) FROM SEQUENCE_NUMBER and that seemed to have solved the issue. BUt could someone tell me what the issue here is? Here is the thread dump. The context I am running is "/preneed". at java.lang.Thread.run(Thread.java:536) "Thread-5" daemon prio=5 tid=0x0AF00830 nid=0x50c runnable [badf000..badfd8c] at java.net.Inet4AddressImpl.getHostByAddr(Native Method) at java.net.InetAddress$1.getHostByAddr(InetAddress.java:722) at java.net.InetAddress.getHostFromNameService(InetAddress.java:464) at java.net.InetAddress.getHostName(InetAddress.java:407) at java.net.InetAddress.getHostName(InetAddress.java:379) at com.microsoft.jdbc.sqlserver.tds.TDSConnection.getLocalHostname(Unkno wn Source) at com.microsoft.jdbc.sqlserver.tds.TDSLoginRequest.submitRequest(Unknow n Source) at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Sou rce) at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown S ource) at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source) - locked <02AD3DD8> (a com.microsoft.jdbc.sqlserver.SQLServerConnection) at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source) at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(Driv erConnectionFactory.java:83) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(Poolable ConnectionFactory.java:184) - locked <036668B8> (a org.apache.commons.dbcp.PoolableConnectionFactory ) at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(Unknown S ource) - locked <036668D8> (a org.apache.commons.dbcp.AbandonedObjectPool) at org.apache.commons.dbcp.AbandonedObjectPool.borrowObject(AbandonedObj ectPool.java:117) - locked <036668D8> (a org.apache.commons.dbcp.AbandonedObjectPool) at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSo urce.java:108) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource .java:312) at nglic.webapp.utils.DAOUtils.getDBConnection(DAOUtils.java:84) at nglic.webapp.dao.UserDAO.getUser(UserDAO.java:51) at nglic.webapp.services.UserServicesImpl.authenticateUser(UserServicesI mpl.java:159) at nglic.webapp.action.LoginAction.performAction(LoginAction.java:322) at nglic.webapp.action.BaseAction.execute(BaseAction.java:89) at org.apache.struts.action.RequestProcessor.processActionPerform(Reques tProcessor.java:484) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.ja va:274) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:148 0) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:524) at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl icationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF ilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV alve.java:256) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex t.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav a:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV alve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex t.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav a:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java: 2416) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j ava:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex t.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatche rValve.java:171) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex t.invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j ava:172) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex t.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav a:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal ve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex t.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav a:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:22 3) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java :601) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce ssConnection(Http11Protocol.java:392) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java :565) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP ool.java:619) at java.lang.Thread.run(Thread.java:536) "Thread-4" daemon prio=5 tid=0x0AF552F0 nid=0x7b8 runnable [ba9f000..ba9fd8c] at java.net.PlainSocketImpl.socketAccept(Native Method) at java.net.PlainSocketImpl.accept(PlainSocketImpl.java:353) - locked <03013110> (a java.net.PlainSocketImpl) at java.net.ServerSocket.implAccept(ServerSocket.java:439) at java.net.ServerSocket.accept(ServerSocket.java:410) at org.apache.tomcat.util.net.DefaultServerSocketFactory.acceptSocket(De faultServerSocketFactory.java:107) at org.apache.tomcat.util.net.PoolTcpEndpoint.acceptSocket(PoolTcpEndpoi nt.java:356) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java :529) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP ool.java:619) at java.lang.Thread.run(Thread.java:536) "Thread-3" daemon prio=5 tid=0x0AF55198 nid=0x560 in Object.wait() [ba5f000..ba5 fd8c] at java.lang.Object.wait(Native Method) - waiting on <035842C8> (a org.apache.tomcat.util.threads.ThreadPool$Con trolRunnable) at java.lang.Object.wait(Object.java:426) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP ool.java:595) - locked <035842C8> (a org.apache.tomcat.util.threads.ThreadPool$Control Runnable) at java.lang.Thread.run(Thread.java:536) "Thread-2" daemon prio=5 tid=0x0AF55620 nid=0x85c in Object.wait() [ba1f000..ba1 fd8c] at java.lang.Object.wait(Native Method) - waiting on <03584340> (a org.apache.tomcat.util.threads.ThreadPool$Con trolRunnable) at java.lang.Object.wait(Object.java:426) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP ool.java:595) - locked <03584340> (a org.apache.tomcat.util.threads.ThreadPool$Control Runnable) at java.lang.Thread.run(Thread.java:536) "HostConfig[localhost]" daemon prio=5 tid=0x0AF54A40 nid=0x890 waiting on condit ion [b9df000..b9dfd8c] at java.lang.Thread.sleep(Native Method) at org.apache.catalina.startup.HostConfig.threadSleep(HostConfig.java:82 4) at org.apache.catalina.startup.HostConfig.run(HostConfig.java:848) at java.lang.Thread.run(Thread.java:536) "StandardManager[/webdav]" daemon prio=5 tid=0x0AF54010 nid=0x83c waiting on con dition [b99f000..b99fd8c] at java.lang.Thread.sleep(Native Method) at org.apache.catalina.session.StandardManager.threadSleep(StandardManag er.java:810) at org.apache.catalina.session.StandardManager.run(StandardManager.java: 869) at java.lang.Thread.run(Thread.java:536) "StandardManager[/tomcat-docs]" daemon prio=5 tid=0x0ADF3B00 nid=0x51c waiting o n condition [b95f000..b95fd8c] at java.lang.Thread.sleep(Native Method) at org.apache.catalina.session.StandardManager.threadSleep(StandardManag er.java:810) at org.apache.catalina.session.StandardManager.run(StandardManager.java: 869) at java.lang.Thread.run(Thread.java:536) "StandardManager[]" daemon prio=5 tid=0x0AE0A0C0 nid=0x7e4 waiting on condition [b91f000..b91fd8c] at java.lang.Thread.sleep(Native Method) at org.apache.catalina.session.StandardManager.threadSleep(StandardManag er.java:810) at org.apache.catalina.session.StandardManager.run(StandardManager.java: 869) at java.lang.Thread.run(Thread.java:536) "StandardManager[/struts-example]" daemon prio=5 tid=0x0AF4EB98 nid=0x7d8 waitin g on condition [b8df000..b8dfd8c] at java.lang.Thread.sleep(Native Method) at org.apache.catalina.session.StandardManager.threadSleep(StandardManag er.java:810) at org.apache.catalina.session.StandardManager.run(StandardManager.java: 869) at java.lang.Thread.run(Thread.java:536) "StandardManager[/struts-documentation]" daemon prio=5 tid=0x0AE1A668 nid=0x88c waiting on condition [b89f000..b89fd8c] at java.lang.Thread.sleep(Native Method) at org.apache.catalina.session.StandardManager.threadSleep(StandardManag er.java:810) at org.apache.catalina.session.StandardManager.run(StandardManager.java: 869) at java.lang.Thread.run(Thread.java:536) "StandardManager[/manager]" daemon prio=5 tid=0x0AE1A510 nid=0x3ac waiting on co ndition [b85f000..b85fd8c] at java.lang.Thread.sleep(Native Method) at org.apache.catalina.session.StandardManager.threadSleep(StandardManag er.java:810) at org.apache.catalina.session.StandardManager.run(StandardManager.java: 869) at java.lang.Thread.run(Thread.java:536) "StandardManager[/admin]" daemon prio=5 tid=0x0AE1A3B8 nid=0x840 waiting on cond ition [b81f000..b81fd8c] at java.lang.Thread.sleep(Native Method) at org.apache.catalina.session.StandardManager.threadSleep(StandardManag er.java:810) at org.apache.catalina.session.StandardManager.run(StandardManager.java: 869) at java.lang.Thread.run(Thread.java:536) "StandardManager[/examples]" daemon prio=5 tid=0x0AE1A260 nid=0x2ac waiting on c ondition [b7df000..b7dfd8c] at java.lang.Thread.sleep(Native Method) at org.apache.catalina.session.StandardManager.threadSleep(StandardManag er.java:810) at org.apache.catalina.session.StandardManager.run(StandardManager.java: 869) at java.lang.Thread.run(Thread.java:536) "WebappLoader[/examples]" daemon prio=5 tid=0x0AD8A950 nid=0x860 waiting on cond ition [b79f000..b79fd8c] at java.lang.Thread.sleep(Native Method) at org.apache.catalina.loader.WebappLoader.threadSleep(WebappLoader.java :1208) at org.apache.catalina.loader.WebappLoader.run(WebappLoader.java:1328) at java.lang.Thread.run(Thread.java:536) "StandardManager[/preneed]" daemon prio=5 tid=0x008E75C0 nid=0x678 waiting on co ndition [b75f000..b75fd8c] at java.lang.Thread.sleep(Native Method) at org.apache.catalina.session.StandardManager.threadSleep(StandardManag er.java:810) at org.apache.catalina.session.StandardManager.run(StandardManager.java: 869) at java.lang.Thread.run(Thread.java:536) "WebappLoader[/preneed]" daemon prio=5 tid=0x0AD49DD8 nid=0x5b8 waiting on condi tion [b71f000..b71fd8c] at java.lang.Thread.sleep(Native Method) at org.apache.catalina.loader.WebappLoader.threadSleep(WebappLoader.java :1208) at org.apache.catalina.loader.WebappLoader.run(WebappLoader.java:1328) at java.lang.Thread.run(Thread.java:536) "Signal Dispatcher" daemon prio=10 tid=0x008B5DC0 nid=0x638 waiting on condition [0..0] "Finalizer" daemon prio=9 tid=0x008FF3E8 nid=0x318 in Object.wait() [ab4f000..ab 4fd8c] at java.lang.Object.wait(Native Method) - waiting on <02EE4E48> (a java.lang.ref.ReferenceQueue$Lock) at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:111) - locked <02EE4E48> (a java.lang.ref.ReferenceQueue$Lock) at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:127) at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:159) "Reference Handler" daemon prio=10 tid=0x008FDF60 nid=0x310 in Object.wait() [ab 0f000..ab0fd8c] at java.lang.Object.wait(Native Method) - waiting on <02EE4EB0> (a java.lang.ref.Reference$Lock) at java.lang.Object.wait(Object.java:426) at java.lang.ref.Reference$ReferenceHandler.run(Reference.java:113) - locked <02EE4EB0> (a java.lang.ref.Reference$Lock) "main" prio=5 tid=0x00235660 nid=0x52c runnable [6f000..6fc40] at java.net.PlainSocketImpl.socketAccept(Native Method) at java.net.PlainSocketImpl.accept(PlainSocketImpl.java:353) - locked <035843E0> (a java.net.PlainSocketImpl) at java.net.ServerSocket.implAccept(ServerSocket.java:439) at java.net.ServerSocket.accept(ServerSocket.java:410) at org.apache.catalina.core.StandardServer.await(StandardServer.java:527 ) at org.apache.catalina.startup.Catalina.start(Catalina.java:521) at org.apache.catalina.startup.Catalina.execute(Catalina.java:400) at org.apache.catalina.startup.Catalina.process(Catalina.java:180) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl. java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces sorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:203) "VM Thread" prio=5 tid=0x008FCD28 nid=0x5b4 runnable "VM Periodic Task Thread" prio=10 tid=0x008B4958 nid=0x3d0 waiting on condition "Suspend Checker Thread" prio=10 tid=0x008B53D8 nid=0x2a4 runnable