0 Replies Latest reply: Jul 31, 2013 12:34 PM by Krishna123 RSS

    getting  weblogic.jdbc.extensions.PoolLimitSQLException: weblogic.common.resourcepool.ResourceLimitException

    Krishna123

      We are using WebLogic Server Version: 10.3.5.0

      I am getting pool limit exception as follows

       

      Full stack trace

      weblogic.jdbc.extensions.PoolLimitSQLException:

      weblogic.common.resourcepool.ResourceLimitException: No resources currently available in pool STMECO-WWW-DATABASE-P to allocate to applications, please increase the size of the pool and retry..

      weblogic.jdbc.extensions.PoolLimitSQLException: weblogic.common.resourcepool.ResourceLimitException: No resources currently available in pool schConnectionDS_new to allocate to applications, please increase the size of the pool and retry..

      at weblogic.jdbc.common.internal.JDBCUtil.wrapAndThrowResourceException(JDBCUtil.java:252)

      at weblogic.jdbc.pool.Driver.connect(Driver.java:161)

      at weblogic.jdbc.jts.Driver.getNonTxConnection(Driver.java:651)

      at weblogic.jdbc.jts.Driver.connect(Driver.java:127)

      at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:364)

      at weblogic.ejb.container.cmp.rdbms.RDBMSPersistenceManager.getConnection(RDBMSPersistenceManager.java:4068)

      at com.vzw.pos.cmw.ejb.entities.StoreRegSummary_1ec9yo__WebLogic_CMP_RDBMS.ejbFindByRegUserDate(StoreRegSummary_1ec9yo__WebLogic_CMP_RDBMS.java:1338)

      at sun.reflect.GeneratedMethodAccessor290.invoke(Unknown Source)

      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

      at java.lang.reflect.Method.invoke(Method.java:597)

      at weblogic.ejb.container.cmp.rdbms.RDBMSPersistenceManager.collectionFinder(RDBMSPersistenceManager.java:508)

      at weblogic.ejb.container.manager.BaseEntityManager.collectionFinder(BaseEntityManager.java:2611)

      at weblogic.ejb.container.manager.BaseEntityManager.collectionFinder(BaseEntityManager.java:2587)

      at weblogic.ejb.container.internal.EntityEJBLocalHome.finder(EntityEJBLocalHome.java:1120)

      at com.vzw.pos.cmw.ejb.entities.StoreRegSummary_1ec9yo_LocalHomeImpl.findByRegUserDate(StoreRegSummary_1ec9yo_LocalHomeImpl.java:205)

      at com.vzw.pos.cmw.ejb.service.RegisterOperationBeanNew.getStoreRegSummaryArray(Unknown Source)

      at com.vzw.pos.cmw.ejb.service.RegisterOperationBeanNew.getRegisterDiscrepancy(Unknown Source)

      at com.vzw.pos.cmw.ejb.service.RegisterOperationBeanNew.getRegisterFullDetails(Unknown Source)

      at com.vzw.pos.cmw.beans.TallysheetProcessBean.getRegisterData(Unknown Source)

      at com.vzw.pos.cmw.delegates.TallysheetDelegate.getRegisterDetails(Unknown Source)

      at com.vzw.pos.cmw.action.TallysheetAction.getRegisterDetails(Unknown Source)

      at sun.reflect.GeneratedMethodAccessor369.invoke(Unknown Source)

      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

      at java.lang.reflect.Method.invoke(Method.java:597)

      at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)

      at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)

      at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)

      at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)

      at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)

      at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)

      at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)

      at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)

      at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)

      at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)

      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

      at com.vzw.pos.cmw.filters.CMWFilter.doFilter(Unknown Source)

      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

      at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3710)

      at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3676)

      at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)

      at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)

      at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2272)

      at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2178)

      at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1454)

      at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)

      at weblogic.work.ExecuteThread.run


      also we are seeing


      Error request updateStoreDailySchedule() processing. : Error request processing. : Transaction Rolledback.: weblogic.transaction.internal.TimedOutException: Transaction timed out after 63 seconds
      at weblogic.transaction.internal.ServerTransactionManagerImpl.processTimedOutTransactions(ServerTransactionManagerImpl.java:1591)
      ; nested exception is: weblogic.transaction.internal.TimedOutException: Transaction timed out after 63 seconds

       

       

       

      Now we are restarting the managed servers when ever we see these kind of  issues and the issue resolves after restart

       

      we have JDBC configuration as follows

       

      Initial Capacity:                  75

      Maximum Capacity:                  75

      Capacity Increment:                    1

      Seconds to trust an idle pool connection:     10

      Shrink Frequency:                    900

      Enable Connection Leak Profiling:          False

      Enable Connection Profiling:               False

      Test Frequency:                         120 seconds

      Test Reserved Connections:               True

      Connection Reserve Timeout:               10 seconds

      Connection Creation Retry Frequency:         1

      Inactive Connection Timeout:               60 second

      Maximum Waiting for Connection:               2147483647

       

      Test Table Name:          select 1 from dual

       

      My question is how a restart is solving the problem?

       

      Thanks

      Krishna