Hi team,
We are experiencing SQL DB error in ACS 4.15.2, it started happening suddenly
without any change, the database MariaDB is working well. Have you seen the
error below? any suggestion on changing a parameter in db.properties, like
timeout, active pool or wait time?
java.sql.SQLException: Cannot get a connection, pool error Timeout waiting for
idle object
at
org.apache.commons.dbcp2.PoolingDataSource.getConnection(PoolingDataSource.java:142)
at
com.cloud.utils.db.TransactionLegacy.getStandaloneConnectionWithException(TransactionLegacy.java:211)
at
com.cloud.utils.db.TransactionLegacy.getStandaloneConnection(TransactionLegacy.java:220)
at com.cloud.utils.db.DbUtil.getConnectionForGlobalLocks(DbUtil.java:61)
at com.cloud.utils.db.DbUtil.getGlobalLock(DbUtil.java:199)
at com.cloud.utils.db.GlobalLock.lock(GlobalLock.java:154)
at
com.cloud.storage.snapshot.SnapshotSchedulerImpl.poll(SnapshotSchedulerImpl.java:147)
at
com.cloud.storage.snapshot.SnapshotSchedulerImpl$1.runInContext(SnapshotSchedulerImpl.java:480)
at
org.apache.cloudstack.managed.context.ManagedContextTimerTask$1.runInContext(ManagedContextTimerTask.java:30)
at
org.apache.cloudstack.managed.context.ManagedContextRunnable$1.run(ManagedContextRunnable.java:48)
at
org.apache.cloudstack.managed.context.impl.DefaultManagedContext$1.call(DefaultManagedContext.java:55)
at
org.apache.cloudstack.managed.context.impl.DefaultManagedContext.callWithContext(DefaultManagedContext.java:102)
at
org.apache.cloudstack.managed.context.impl.DefaultManagedContext.runWithContext(DefaultManagedContext.java:52)
at
org.apache.cloudstack.managed.context.ManagedContextRunnable.run(ManagedContextRunnable.java:45)
at
org.apache.cloudstack.managed.context.ManagedContextTimerTask.run(ManagedContextTimerTask.java:32)
at java.base/java.util.TimerThread.mainLoop(Timer.java:556)
at java.base/java.util.TimerThread.run(Timer.java:506)
"management-server.log" 323700L, 43977309C
104517,49 32%
at java.base/java.util.TimerThread.mainLoop(Timer.java:556)
at java.base/java.util.TimerThread.run(Timer.java:506)
Caused by: java.util.NoSuchElementException: Timeout waiting for idle object
at
org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:446)
at
org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:356)
at
org.apache.commons.dbcp2.PoolingDataSource.getConnection(PoolingDataSource.java:134)
