Question

5
Replies
1885
Views
rakshiths3554 Member since 2016 2 posts
societe generale
Posted: 3 years ago
Last activity: 2 years 11 months ago
Closed

spike database connection pool and pega agents are failing

Hi,

We are facing a problem in application, where we sudden spike in database connection pool and it is reaching maximum which caused all the running agents go into exception. We observed this behavior even when there was the minimal load and just after 90 mints of web node restart. We checked with all our teams(web , database) but we dont see any issue.

Please see the below log information on the log.

<Sep 10, 2017 3:00:39 PM CEST> <Error> <HTTP> <BEA-101215> <Malformed request "null". Request parsing failed, Code: -1>
2017-09-10 15:00:57,141 [fault (self-tuning)'] [ STANDARD] [ ] [ OPERCMTAdmin:01.17] (.access.DatabaseConnectionImpl) ERROR - Couldn't
obtain a connection. Refresh the DataSource, and try again
2017-09-10 15:00:58,087 [fault (self-tuning)'] [ STANDARD] [ ] [ OPERCMTAdmin:01.17] (.access.DatabaseConnectionImpl) ERROR - Couldn't
obtain a connection. Refresh the DataSource, and try again
2017-09-10 15:00:58,250 [fault (self-tuning)'] [ STANDARD] [ ] [ OPERCMTAdmin:01.17] (.access.DatabaseConnectionImpl) ERROR - Couldn't
obtain a connection. Refresh the DataSource, and try again
2017-09-10 15:00:58,250 [fault (self-tuning)'] [ STANDARD] [ ] [ OPERCMTAdmin:01.17] (.access.DatabaseConnectionImpl) ERROR - Couldn't
obtain a connection. Refresh the DataSource, and try again
2017-09-10 15:00:58,279 [fault (self-tuning)'] [ STANDARD] [ ] [ OPERCMTAdmin:01.17] (.access.DatabaseConnectionImpl) ERROR - Couldn't
obtain a connection. Refresh the DataSource, and try again
2017-09-10 15:00:58,613 [fault (self-tuning)'] [ STANDARD] [ ] [ OPERCMTAdmin:01.17] (.access.DatabaseConnectionImpl) ERROR - Couldn't
obtain a connection. Refresh the DataSource, and try again
2017-09-10 15:00:59,177 [fault (self-tuning)'] [ STANDARD] [ ] [ OPERCMTAdmin:01.17] (.access.DatabaseConnectionImpl) ERROR - Couldn't
obtain a connection. Refresh the DataSource, and try again
2017-09-10 15:00:59,725 [fault (self-tuning)'] [ STANDARD] [ ] [ OPERCMTAdmin:01.17] (.access.DatabaseConnectionImpl) ERROR - Couldn't
obtain a connection. Refresh the DataSource, and try again
2017-09-10 15:00:59,987 [fault (self-tuning)'] [ STANDARD] [ ] [ OPERCMTAdmin:01.17] (.access.DatabaseConnectionImpl) ERROR - Couldn't
obtain a connection. Refresh the DataSource, and try again
2017-09-10 15:01:00,122 [fault (self-tuning)'] [ STANDARD] [ ] [ ] (.access.DatabaseConnectionImpl) ERROR - Couldn't
obtain a connection. Refresh the DataSource, and try again
2017-09-10 15:01:00,122 [fault (self-tuning)'] [ STANDARD] [ ] [ OPERCMTAdmin:01.17] (.access.DatabaseConnectionImpl) ERROR - Couldn't
obtain a connection. Refresh the DataSource, and try again
2017-09-10 15:01:00,122 [fault (self-tuning)'] [ STANDARD] [ ] [ ] (.access.DatabaseConnectionImpl) ERROR - Couldn't
obtain a connection. Refresh the DataSource, and try again
2017-09-10 15:01:00,415 [fault (self-tuning)'] [ STANDARD] [ ] [ OPERCMTAdmin:01.17] (.access.DatabaseConnectionImpl) ERROR - Couldn't
obtain a connection. Refresh the DataSource, and try again
2017-09-10 15:01:00,416 [fault (self-tuning)'] [ STANDARD] [ ] [ OPERCMTAdmin:01.17] (.access.DatabaseConnectionImpl) ERROR - Couldn't
obtain a connection. Refresh the DataSource, and try again
2017-09-10 15:01:00,422 [fault (self-tuning)'] [ STANDARD] [ ] [ OPERCMTAdmin:01.17] (.access.DatabaseConnectionImpl) ERROR - Couldn't
obtain a connection. Refresh the DataSource, and try again
2017-09-10 15:01:00,475 [fault (self-tuning)'] [ STANDARD] [ ] [ OPERCMTAdmin:01.17] (.access.DatabaseConnectionImpl) ERROR - Couldn't
obtain a connection. Refresh the DataSource, and try again
2017-09-10 15:01:00,475 [fault (self-tuning)'] [ STANDARD] [ ] [ OPERCMTAdmin:01.17] (.access.DatabaseConnectionImpl) ERROR - Couldn't
obtain a connection. Refresh the DataSource, and try again
2017-09-10 15:01:00,476 [fault (self-tuning)'] [ STANDARD] [ ] [ OPERCMTAdmin:01.17] (.access.DatabaseConnectionImpl) ERROR - Couldn't
obtain a connection. Refresh the DataSource, and try again
2017-09-10 15:01:00,615 [fault (self-tuning)'] [ STANDARD] [ ] [ ] (.access.DatabaseConnectionImpl) ERROR - Couldn't
obtain a connection. Refresh the DataSource, and try again
2017-09-10 15:01:01,206 [fault (self-tuning)'] [ STANDARD] [ ] [ ] (.access.DatabaseConnectionImpl) ERROR - Couldn't
obtain a connection. Refresh the DataSource, and try again
2017-09-10 15:01:01,207 [fault (self-tuning)'] [ STANDARD] [ ] [ ] (.access.DatabaseConnectionImpl) ERROR - Couldn't
obtain a connection. Refresh the DataSource, and try again
2017-09-10 15:01:01,799 [fault (self-tuning)'] [ STANDARD] [ ] [ OPERCMTAdmin:01.17] (.access.DatabaseConnectionImpl) ERROR - Couldn't
obtain a connection. Refresh the DataSource, and try again
2017-09-10 15:01:02,662 [fault (self-tuning)'] [ STANDARD] [ ] [ ] (.access.DatabaseConnectionImpl) ERROR - Couldn't
obtain a connection. Refresh the DataSource, and try again
2017-09-10 15:01:02,705 [fault (self-tuning)'] [ STANDARD] [ ] [ ] (.access.DatabaseConnectionImpl) ERROR - Couldn't
obtain a connection. Refresh the DataSource, and try again
2017-09-10 15:01:02,816 [fault (self-tuning)'] [ STANDARD] [ ] [ OPERCMTAdmin:01.17] (.access.DatabaseConnectionImpl) ERROR - Couldn't
obtain a connection. Refresh the DataSource, and try again
2017-09-10 15:01:03,127 [fault (self-tuning)'] [ STANDARD] [ ] [ ] (.access.DatabaseConnectionImpl) ERROR - Couldn't
obtain a connection. Refresh the DataSource, and try again
2017-09-10 15:01:05,191 [fault (self-tuning)'] [ STANDARD] [ ] [ OPERCMTAdmin:01.17] (.access.DatabaseConnectionImpl) ERROR - Couldn't
obtain a connection. Refresh the DataSource, and try again
2017-09-10 15:01:06,974 [fault (self-tuning)'] [ STANDARD] [ ] [ OPERCMTAdmin:01.17] (.access.DatabaseConnectionImpl) ERROR - Couldn't
obtain a connection. Refresh the DataSource, and try again

2017-09-10 15:01:13,129 [15624.IO.thread-in-1] [ STANDARD] [ ] [ ] ( nio.tcp.TcpIpConnection) INFO - [xx.xx.xx.xx]:5701 [1ac07b8356846befc505fb795b115624] [3.4.1] Connection [xx.xx.xx.xx/xx.xx.xx.xx:43335] lost. Reason: java.io.EOFException[Remote socket closed!]
2017-09-10 15:01:13,717 [fault (self-tuning)'] [ STANDARD] [ ] [ ] ( internal.access.DatabaseImpl) ERROR - There wa
s a problem with the database when getting a list:
:
com.pega.pegarules.pub.database.ConnectionException: Database-General Problem encountered when getting connection for database pegarules 0
weblogic.common.resourcepool.ResourceLimitException: No resources currently available in pool PegaRULES to allocate to applications, please increase the size of the pool and retry..
DatabaseException caused by prior exception: weblogic.jdbc.extensions.PoolLimitSQLException: weblogic.common.resourcepool.ResourceLimitException: No resources currently available in pool PegaRULES to allocate to applications, please increase the size of the pool and retry..
| SQL Code: 0 | SQL State: null

DatabaseException caused by prior exception: java.sql.SQLException: Cannot obtain connection: driverURL = jdbc:weblogic:pool:PegaRULES, props = {EmulateTwoPhaseCommit=false, connectionPoolID=PegaRULES, jdbcTxDataSource=true, LoggingLastResource=false, dataSourceName=PegaRULES}
| SQL Code: 0 | SQL State: null

From: (B7B4A7F2111AB6D90E25CC97915CCA9F7)
Caused by SQL Problems.
Problem #1, SQLState null, Error code 0: weblogic.jdbc.extensions.PoolLimitSQLException: weblogic.common.resourcepool.ResourceLimitException: No resources currently available in pool PegaRULES to allocate to applications, please increase the size of the pool and retry..
Problem #2, SQLState null, Error code 0: java.sql.SQLException: Cannot obtain connection: driverURL = jdbc:weblogic:pool:PegaRULES, props = {EmulateTwoPhaseCommit=false, connectionPoolID=PegaRULES, jdbcTxDataSource=true, LoggingLastResource=false, dataSourceName=PegaRULES}
at com.pega.pegarules.data.internal.access.ExceptionInformation.createExceptionDueToDBFailure(ExceptionInformation.java:256)
at com.pega.pegarules.data.internal.access.ConnectionManagerImpl.getConnectionFromDataSourceIdentity(ConnectionManagerImpl.java:1087)
at com.pega.pegarules.data.internal.access.ConnectionManagerImpl.getConnection(ConnectionManagerImpl.java:1216)
at com.pega.pegarules.data.internal.access.ConnectionManagerImpl.getConnection(ConnectionManagerImpl.java:1156)
at com.pega.pegarules.data.internal.access.ConnectionManagerImpl.getConnection(ConnectionManagerImpl.java:347)
at com.pega.pegarules.data.internal.access.ThreadConnectionStoreImpl.getConnection(ThreadConnectionStoreImpl.java:426)
at com.pega.pegarules.data.internal.access.RDBPageResultPackager.getConnection(RDBPageResultPackager.java:924)
at com.pega.pegarules.data.internal.access.DatabaseImpl.list(DatabaseImpl.java:6279)
at com.pega.pegarules.data.internal.access.DatabaseImpl.executeRDB(DatabaseImpl.java:6932)
at com.pega.pegarules.data.internal.access.DatabaseImpl.executeRDB(DatabaseImpl.java:6885)
at com.pega.pegarules.data.internal.access.DatabaseImpl.executeRDB(DatabaseImpl.java:6865)
at com.pega.pegarules.session.internal.authorization.context.AppCentricRulesetIndexWriter.doesTopAppHashNeedToBeInsertedIntoFlattenedHierarchy(AppCentricRulesetIndexWriter.java:562)
at com.pega.pegarules.session.internal.authorization.context.AppCentricRulesetIndexWriter.populateApplicationRuleHierarchy(AppCentricRulesetIndexWriter.java:501)
at com.pega.pegarules.session.internal.authorization.context.AppCentricRulesetIndexWriter.populateApplicationRuleHierarchy(AppCentricRulesetIndexWriter.java:613)
at com.pega.pegarules.session.internal.authorization.context.AppCentricRulesetIndexWriter.populateApplicationRuleHierarchy(AppCentricRulesetIndexWriter.java:634)
at com.pega.pegarules.session.internal.authorization.context.AppCentricRulesetIndexWriter.writeApplicationInfoToDatabase(AppCentricRulesetIndexWriter.java:193)
at com.pega.pegarules.session.internal.authorization.context.custom.ManagedApplicationContext.updateDBRSLAndAppStack(ManagedApplicationContext.java:860)
at com.pega.pegarules.session.internal.authorization.context.custom.ManagedApplicationContext.updateToParent(ManagedApplicationContext.java:430)
at com.pega.pegarules.session.internal.authorization.context.custom.ManagedApplicationContext.getChangeCount(ManagedApplicationContext.java:390)
at com.pega.pegarules.session.internal.authorization.context.AbstractApplicationContext.getAppInfo(AbstractApplicationContext.java:45)
at com.pega.pegarules.session.internal.authorization.context.AppCentricRulesetIndexWriter.populateApplicationRuleHierarchy(AppCentricRulesetIndexWriter.java:629)
at com.pega.pegarules.session.internal.authorization.context.AppCentricRulesetIndexWriter.writeApplicationInfoToDatabase(AppCentricRulesetIndexWriter.java:193)
at com.pega.pegarules.session.internal.authorization.context.custom.ManagedApplicationContext.updateDBRSLAndAppStack(ManagedApplicationContext.java:860)
at com.pega.pegarules.session.internal.authorization.context.custom.ManagedApplicationContext.<init>(ManagedApplicationContext.java:107)
at com.pega.pegarules.session.internal.authorization.context.custom.CustomApplicationContext.<init>(CustomApplicationContext.java:75)
at com.pega.pegarules.session.internal.authorization.context.ContextUtils.ensureCustomizable(ContextUtils.java:867)
at com.pega.pegarules.session.internal.authorization.Authorization.alterRuleSetList(Authorization.java:1048)
at com.pega.pegarules.session.internal.authorization.Authorization.alterRuleSetList(Authorization.java:1041)
at com.pega.pegarules.session.internal.async.BatchRequestorTask.run(BatchRequestorTask.java:839)
at com.pega.pegarules.session.internal.PRSessionProviderImpl.performTargetActionWithLock(PRSessionProviderImpl.java:1266)
at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:1015)
at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:908)
at com.pega.pegarules.session.internal.async.BatchRequestorTask.run(BatchRequestorTask.java:684)
at com.pega.pegarules.session.internal.async.Agent.queueBatchActivityForAgent(Agent.java:1526)
at com.pega.pegarules.session.internal.async.Agent.queueBatchActivityForAgent(Agent.java:1299)

***Edited by Moderator Marissa to update categories***

Data Integration
Moderation Team has archived post
Share this page LinkedIn