commons-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 22736] - validationQuery parameter hangs getConnection method.
Date Thu, 28 Aug 2003 13:11:55 GMT
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://nagoya.apache.org/bugzilla/show_bug.cgi?id=22736>.
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

Mime
View raw message