From: | itishree sukla <itishree(dot)sukla(at)gmail(dot)com> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
Subject: | SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object |
Date: | 2013-04-17 16:01:31 |
Message-ID: | CAL-g6VRhOJb9xzVCmMmj8cDkVXSKv2rXr+NRS9Av44nB6vX-sg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-performance |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2013-04-17 16:45:31 | Re: How large can a PostgreSQL database get? |
Previous Message | Adrian Klaver | 2013-04-17 15:32:08 | Re: Can you spot the difference? |
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Okner | 2013-04-17 16:59:20 | Query planner ignoring constraints on partitioned tables when joining |
Previous Message | Franck Routier | 2013-04-16 09:16:39 | Re: Postgresql performance degrading... how to diagnose the root cause |