HTTP Status 500 - org.apache.torque.TorqueException: org.apache.commons.dbcp.SQLNestedException: Could not retrieve connection info from pool


type Exception report

message org.apache.torque.TorqueException: org.apache.commons.dbcp.SQLNestedException: Could not retrieve connection info from pool

description The server encountered an internal error that prevented it from fulfilling this request.

exception

javax.servlet.ServletException: org.apache.torque.TorqueException: org.apache.commons.dbcp.SQLNestedException: Could not retrieve connection info from pool
	org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:516)
	org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:423)
	org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
	org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
	org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
	org.tuckey.web.filters.urlrewrite.RewrittenUrl.doRewrite(RewrittenUrl.java:176)
	org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:728)
	au.com.madman.filters.MadmanFilter.doFilter(MadmanFilter.java:181)

root cause

org.apache.torque.TorqueException: org.apache.commons.dbcp.SQLNestedException: Could not retrieve connection info from pool
	org.apache.torque.TorqueInstance.getConnection(TorqueInstance.java:919)
	org.apache.torque.TorqueInstance.getConnection(TorqueInstance.java:891)
	org.apache.torque.Torque.getConnection(Torque.java:300)
	au.com.madman.struts.actions.CatalogueAction.getWebChannel(CatalogueAction.java:3601)
	au.com.madman.struts.actions.CatalogueAction.legacyBrowse(CatalogueAction.java:330)
	sun.reflect.GeneratedMethodAccessor1907.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:498)
	org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:276)
	org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:196)
	au.com.madman.struts.actions.CatalogueAction.execute(CatalogueAction.java:254)
	org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
	org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
	org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
	org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
	org.tuckey.web.filters.urlrewrite.RewrittenUrl.doRewrite(RewrittenUrl.java:176)
	org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:728)
	au.com.madman.filters.MadmanFilter.doFilter(MadmanFilter.java:181)

root cause

org.apache.commons.dbcp.SQLNestedException: Could not retrieve connection info from pool
	org.apache.commons.dbcp.datasources.SharedPoolDataSource.getPooledConnectionAndInfo(SharedPoolDataSource.java:171)
	org.apache.commons.dbcp.datasources.InstanceKeyDataSource.getConnection(InstanceKeyDataSource.java:669)
	org.apache.commons.dbcp.datasources.InstanceKeyDataSource.getConnection(InstanceKeyDataSource.java:653)
	org.apache.torque.TorqueInstance.getConnection(TorqueInstance.java:912)
	org.apache.torque.TorqueInstance.getConnection(TorqueInstance.java:891)
	org.apache.torque.Torque.getConnection(Torque.java:300)
	au.com.madman.struts.actions.CatalogueAction.getWebChannel(CatalogueAction.java:3601)
	au.com.madman.struts.actions.CatalogueAction.legacyBrowse(CatalogueAction.java:330)
	sun.reflect.GeneratedMethodAccessor1907.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:498)
	org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:276)
	org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:196)
	au.com.madman.struts.actions.CatalogueAction.execute(CatalogueAction.java:254)
	org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
	org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
	org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
	org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
	org.tuckey.web.filters.urlrewrite.RewrittenUrl.doRewrite(RewrittenUrl.java:176)
	org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:728)
	au.com.madman.filters.MadmanFilter.doFilter(MadmanFilter.java:181)

root cause

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
	sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
	com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1121)
	com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:357)
	com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2479)
	com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2516)
	com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2301)
	com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:834)
	com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
	sun.reflect.GeneratedConstructorAccessor1415.newInstance(Unknown Source)
	sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
	com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:416)
	com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:346)
	java.sql.DriverManager.getConnection(DriverManager.java:664)
	java.sql.DriverManager.getConnection(DriverManager.java:247)
	org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS.getPooledConnection(DriverAdapterCPDS.java:177)
	org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS.getPooledConnection(DriverAdapterCPDS.java:132)
	org.apache.commons.dbcp.datasources.KeyedCPDSConnectionFactory.makeObject(KeyedCPDSConnectionFactory.java:158)
	org.apache.commons.pool.impl.GenericKeyedObjectPool.borrowObject(GenericKeyedObjectPool.java:747)
	org.apache.commons.dbcp.datasources.SharedPoolDataSource.getPooledConnectionAndInfo(SharedPoolDataSource.java:167)
	org.apache.commons.dbcp.datasources.InstanceKeyDataSource.getConnection(InstanceKeyDataSource.java:669)
	org.apache.commons.dbcp.datasources.InstanceKeyDataSource.getConnection(InstanceKeyDataSource.java:653)
	org.apache.torque.TorqueInstance.getConnection(TorqueInstance.java:912)
	org.apache.torque.TorqueInstance.getConnection(TorqueInstance.java:891)
	org.apache.torque.Torque.getConnection(Torque.java:300)
	au.com.madman.struts.actions.CatalogueAction.getWebChannel(CatalogueAction.java:3601)
	au.com.madman.struts.actions.CatalogueAction.legacyBrowse(CatalogueAction.java:330)
	sun.reflect.GeneratedMethodAccessor1907.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:498)
	org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:276)
	org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:196)
	au.com.madman.struts.actions.CatalogueAction.execute(CatalogueAction.java:254)
	org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
	org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
	org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
	org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
	org.tuckey.web.filters.urlrewrite.RewrittenUrl.doRewrite(RewrittenUrl.java:176)
	org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:728)
	au.com.madman.filters.MadmanFilter.doFilter(MadmanFilter.java:181)

root cause

java.net.UnknownHostException: db.madman.com.au: Name or service not known
	java.net.Inet6AddressImpl.lookupAllHostAddr(Native Method)
	java.net.InetAddress$2.lookupAllHostAddr(InetAddress.java:929)
	java.net.InetAddress.getAddressesFromNameService(InetAddress.java:1324)
	java.net.InetAddress.getAllByName0(InetAddress.java:1277)
	java.net.InetAddress.getAllByName(InetAddress.java:1193)
	java.net.InetAddress.getAllByName(InetAddress.java:1127)
	com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:249)
	com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:307)
	com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2479)
	com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2516)
	com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2301)
	com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:834)
	com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
	sun.reflect.GeneratedConstructorAccessor1415.newInstance(Unknown Source)
	sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
	com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:416)
	com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:346)
	java.sql.DriverManager.getConnection(DriverManager.java:664)
	java.sql.DriverManager.getConnection(DriverManager.java:247)
	org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS.getPooledConnection(DriverAdapterCPDS.java:177)
	org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS.getPooledConnection(DriverAdapterCPDS.java:132)
	org.apache.commons.dbcp.datasources.KeyedCPDSConnectionFactory.makeObject(KeyedCPDSConnectionFactory.java:158)
	org.apache.commons.pool.impl.GenericKeyedObjectPool.borrowObject(GenericKeyedObjectPool.java:747)
	org.apache.commons.dbcp.datasources.SharedPoolDataSource.getPooledConnectionAndInfo(SharedPoolDataSource.java:167)
	org.apache.commons.dbcp.datasources.InstanceKeyDataSource.getConnection(InstanceKeyDataSource.java:669)
	org.apache.commons.dbcp.datasources.InstanceKeyDataSource.getConnection(InstanceKeyDataSource.java:653)
	org.apache.torque.TorqueInstance.getConnection(TorqueInstance.java:912)
	org.apache.torque.TorqueInstance.getConnection(TorqueInstance.java:891)
	org.apache.torque.Torque.getConnection(Torque.java:300)
	au.com.madman.struts.actions.CatalogueAction.getWebChannel(CatalogueAction.java:3601)
	au.com.madman.struts.actions.CatalogueAction.legacyBrowse(CatalogueAction.java:330)
	sun.reflect.GeneratedMethodAccessor1907.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:498)
	org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:276)
	org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:196)
	au.com.madman.struts.actions.CatalogueAction.execute(CatalogueAction.java:254)
	org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
	org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
	org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
	org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
	org.tuckey.web.filters.urlrewrite.RewrittenUrl.doRewrite(RewrittenUrl.java:176)
	org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:728)
	au.com.madman.filters.MadmanFilter.doFilter(MadmanFilter.java:181)

note The full stack trace of the root cause is available in the Apache Tomcat/6.0.45 logs.


Apache Tomcat/6.0.45