You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cloudstack.apache.org by Ricardo Pertuz <ri...@gmail.com> on 2022/11/25 21:26:23 UTC
SQL Error in ACS
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)
Re: SQL Error in ACS
Posted by Daan Hoogland <da...@gmail.com>.
Ricardo,
Have you tried restarting the DB and next ACS? (it needs to be in that
order) Does that help?
On Mon, Nov 28, 2022 at 11:37 AM Ricardo Pertuz <ri...@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)
>
--
Daan
Re: SQL Error in ACS
Posted by Ricardo Pertuz <ri...@kuasar.co>.
Cool, I did that change and it worked! Thanks!
From: Wei ZHOU <us...@gmail.com>
Date: Thursday, 2 February 2023, 9:40 AM
To: users@cloudstack.apache.org <us...@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 <ri...@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)
>
Re: SQL Error in ACS
Posted by Wei ZHOU <us...@gmail.com>.
Hi Ricardo,
This may help you
https://github.com/apache/cloudstack/issues/4657
-Wei
On Mon, 28 Nov 2022 at 11:37, Ricardo Pertuz <ri...@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)
>