Support Article
Server hangs and runs out of database connections
SA-70276
Summary
Server hangs and runs out of database connections after a few Business Intelligence Exchange (BIX) extraction processes. This occurs after installing the Business Intelligence Exchange (BIX) hotfixes of HFix-33295.jar, HFix-38109.jar and HFix-46693. The extraction retrieves a workitem through the Designer Studio. After a few iterations, the extraction does not complete. Designer Studio does not respond to the user interaction. However, the server nodes must be restarted to overcome the hang scenario. The system runs on the Tomcat against the Postgres database. The structure of workitem is complex with a number of nested pagelist and pagegroups. Thread Dump displays when the server hangs. Issue in obtaining the database connection.
Error Messages
at sun.misc.Unsafe.park(Native Method)
at java.util.concurrent.locks.LockSupport.park(LockSupport.java:175)
at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2039)
at org.apache.tomcat.dbcp.pool2.impl.LinkedBlockingDeque.takeFirst(LinkedBlockingDeque.java:582)
at org.apache.tomcat.dbcp.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:439)
at org.apache.tomcat.dbcp.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:360)
at org.apache.tomcat.dbcp.dbcp2.PoolingDataSource.getConnection(PoolingDataSource.java:118)
at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1412)
at pega.pegarules.data.internal.access.DataSourceManager.getConnection(DataSourceManager.java:221)
at pega.pegarules.data.internal.store.DatabaseConnectionImpl.activate(DatabaseConnectionImpl.java:1445)
at pega.pegarules.data.internal.access.ConnectionManagerImpl.getConnectionFromDataSourceIdentity(ConnectionManagerImpl.java:1055)
at pega.pegarules.data.internal.access.ConnectionManagerImpl.getConnection(ConnectionManagerImpl.java:1221)
at pega.pegarules.data.internal.access.ConnectionManagerImpl.getConnection(ConnectionManagerImpl.java:1161)
at pega.pegarules.data.internal.access.ConnectionManagerImpl.getConnection(ConnectionManagerImpl.java:354)
at pega.pegarules.data.internal.access.ThreadConnectionStoreImpl.getConnection(ThreadConnectionStoreImpl.java:427)
at pega.pegarules.data.internal.access.RDBPageResultPackager.getConnection(RDBPageResultPackager.java:925)
at pega.pegarules.data.internal.access.DatabaseImpl.list(DatabaseImpl.java:4600)
Steps to Reproduce
Run the Business Intelligence Exchange (BIX) extract multiple times on the Designer Studio.
Root Cause
A defect in Pegasystems’ code or rules.Resolution
Apply HFix-49697.
Published May 22, 2019 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.