SEPM shows "Unexpected server error", scm log says "Caused by: ...dbcp.SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object"

book

Article ID: 157724

calendar_today

Updated On:

Products

Endpoint Protection

Issue/Introduction

unable to log in SEPM.

scm-server-0.log
2013-01-30 01:49:11.292 THREAD 26 심각: 예상치 못한 서버 오류입니다. in: com.sygate.scm.server.task.PackageTask
com.sygate.scm.server.metadata.MetadataException:
at com.sygate.scm.server.metadata.MetadataManager.getConnectionNoCheckRequireTransactionId(MetadataManager.java:925)
at com.sygate.scm.server.metadata.MetadataManager.getConnection(MetadataManager.java:891)
at com.sygate.scm.server.metadata.MetadataManager.getLastestUsnForCollection(MetadataManager.java:167)
at com.sygate.scm.server.configmanager.ConfigManager.getLatestUsnForCollection(ConfigManager.java:2001)
at com.sygate.scm.server.task.PackageTask.run(PackageTask.java:358)
at java.util.TimerThread.mainLoop(Timer.java:512)
at java.util.TimerThread.run(Timer.java:462)
Caused by: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object
at org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:114)

2013-01-30 10:08:15.667 THREAD 64 심각:
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object
at org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:114)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
at com.sygate.scm.server.db.util.DatabaseUtilities.getDataSourceDBConnection(DatabaseUtilities.java:525)
Caused by: java.util.NoSuchElementException: Timeout waiting for idle object
at org.apache.tomcat.dbcp.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1167)
at org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
... 26 more

 

Cause

Hasn't close the DatabaseInputStream, so the relevant db connection would also not be released.
 

Resolution

This was fixed in 12.1 RU2.