Обсуждение: SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object
SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object
От
itishree sukla
Дата:
Dear All,
Can any one please help me to fix this issue, i am getting this error from our application, currently Database is running on 9.2.
2013-04-17 11:37:25:151 - {ERROR} database.ConnectionManager Thread [http-8080-1]; --- getConnection() Exception:
org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:114)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
at com.tenkinfo.b2g.database.ConnectionManager.getConnection(ConnectionManager.java:39)
at com.tenkinfo.b2g.usermanagement.dao.UserManagementDAOImpl.getSessionData(UserManagementDAOImpl.java:228)
at com.tenkinfo.mapnsav.common.action.BaseAction.execute(BaseAction.java:156)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176)
at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145)
org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:114)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
at com.tenkinfo.b2g.database.ConnectionManager.getConnection(ConnectionManager.java:39)
at com.tenkinfo.b2g.usermanagement.dao.UserManagementDAOImpl.getSessionData(UserManagementDAOImpl.java:228)
at com.tenkinfo.mapnsav.common.action.BaseAction.execute(BaseAction.java:156)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176)
at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145)
Do i have to set tcp _keepalive * paramter to less sec, or need to kill the idle connection ?
Regards,
Itishree
Re: SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object
От
Alfonso Afonso
Дата:
Hi Itsrhree From the machine where is running the tomcat, do you check that you can connect to postgresql server (remember check parametersof connection, user, password, ip)? Having this first step tested, then: Do you have the correct connection pool configured on Catalina (Tomcat) and let this software to configure the pool of databaseconnections? Good luck :) El 17/04/2013, a las 17:01, itishree sukla <itishree.sukla@gmail.com> escribió: > Dear All, > > Can any one please help me to fix this issue, i am getting this error from our application, currently Database is runningon 9.2. > > 2013-04-17 11:37:25:151 - {ERROR} database.ConnectionManager Thread [http-8080-1]; --- getConnection() Exception: > org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object > at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:114) > at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) > at com.tenkinfo.b2g.database.ConnectionManager.getConnection(ConnectionManager.java:39) > at com.tenkinfo.b2g.usermanagement.dao.UserManagementDAOImpl.getSessionData(UserManagementDAOImpl.java:228) > at com.tenkinfo.mapnsav.common.action.BaseAction.execute(BaseAction.java:156) > at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) > at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) > at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) > at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) > at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) > at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176) > at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145) > > Do i have to set tcp _keepalive * paramter to less sec, or need to kill the idle connection ? > > Regards, > Itishree Alfonso Afonso (personal)
Re: [PERFORM] SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object
От
Vitalii Tymchyshyn
Дата:
I'd say you either have overloaded application (try increasing timeout), too small pool (increase pool) or connection leaks (find and fix).
18 квіт. 2013 23:45, "itishree sukla" <itishree.sukla@gmail.com> напис.
Dear All,Can any one please help me to fix this issue, i am getting this error from our application, currently Database is running on 9.2.2013-04-17 11:37:25:151 - {ERROR} database.ConnectionManager Thread [http-8080-1]; --- getConnection() Exception:
org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:114)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
at com.tenkinfo.b2g.database.ConnectionManager.getConnection(ConnectionManager.java:39)
at com.tenkinfo.b2g.usermanagement.dao.UserManagementDAOImpl.getSessionData(UserManagementDAOImpl.java:228)
at com.tenkinfo.mapnsav.common.action.BaseAction.execute(BaseAction.java:156)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176)
at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145)Do i have to set tcp _keepalive * paramter to less sec, or need to kill the idle connection ?Regards,Itishree