Cool, I did that change and it worked! Thanks! From: Wei ZHOU <ustcweiz...@gmail.com> Date: Thursday, 2 February 2023, 9:40 AM To: users@cloudstack.apache.org <users@cloudstack.apache.org> Subject: Re: SQL Error in ACS Hi Ricardo,
This may help you https://github.com/apache/cloudstack/issues/4657 -Wei On Mon, 28 Nov 2022 at 11:37, Ricardo Pertuz <ricper...@gmail.com> wrote: > 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) >