Hello,
Rebuilding and restarting the stable-demo site has not resolved the issue
with the site being down.
There seems to be an underlying database connection issue. Unfortunately
I'm not able to investigate at the moment.
Does anyone recognise the likely cause of this issue?
(stack trace below)
Thanks,
Dan.
2023-09-14 07:49:55,310 |OFBiz-JobPoller |GenericDelegator
|E| Failure in findListIteratorByCondition operation for entity
[DynamicView]: org.apache.ofbiz.entity.GenericDataSourceException: Unable
to establish a connection with the database. (Unable to acquire a new
connection from the pool). Rolling back transaction.
org.apache.ofbiz.entity.GenericDataSourceException: Unable to establish a
connection with the database. (Unable to acquire a new connection from the
pool)
at
org.apache.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:264)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:367)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.datasource.GenericDAO.selectCountByCondition(GenericDAO.java:1049)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.datasource.GenericHelperDAO.findCountByCondition(GenericHelperDAO.java:157)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.GenericDelegator.findCountByCondition(GenericDelegator.java:1691)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.GenericDelegator.findCountByCondition(GenericDelegator.java:1650)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.job.JobManager.isAvailable(JobManager.java:154)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.job.JobPoller$JobManagerPoller.run(JobPoller.java:223)
~[ofbiz.jar:?]
at java.lang.Thread.run(Thread.java:829) ~[?:?]
Caused by: java.sql.SQLException: Unable to acquire a new connection from
the pool
at
org.apache.commons.dbcp2.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:145)
~[commons-dbcp2-2.5.0.jar:2.5.0]
at
org.apache.commons.dbcp2.managed.ManagedConnection.<init>(ManagedConnection.java:75)
~[commons-dbcp2-2.5.0.jar:2.5.0]
at
org.apache.commons.dbcp2.managed.ManagedDataSource.getConnection(ManagedDataSource.java:80)
~[commons-dbcp2-2.5.0.jar:2.5.0]
at
org.apache.ofbiz.entity.connection.DebugManagedDataSource.getConnection(DebugManagedDataSource.java:51)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:66)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.transaction.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:79)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:261)
~[ofbiz.jar:?]
... 8 more
Caused by: java.sql.SQLException: Java exception: ':
java.lang.NullPointerException'.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source) ~[derby-10.14.2.0.jar:?]
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source)
~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.jdbc.Util.javaException(Unknown Source)
~[derby-10.14.2.0.jar:?]
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source) ~[derby-10.14.2.0.jar:?]
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source) ~[derby-10.14.2.0.jar:?]
at
org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown
Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.jdbc.InternalDriver$1.run(Unknown Source)
~[derby-10.14.2.0.jar:?]
at org.apache.derby.jdbc.InternalDriver$1.run(Unknown Source)
~[derby-10.14.2.0.jar:?]
at java.security.AccessController.doPrivileged(Native Method) ~[?:?]
at
org.apache.derby.jdbc.InternalDriver.getNewEmbedConnection(Unknown Source)
~[derby-10.14.2.0.jar:?]
at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
~[derby-10.14.2.0.jar:?]
at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
~[derby-10.14.2.0.jar:?]
at org.apache.derby.jdbc.EmbeddedDriver.connect(Unknown Source)
~[derby-10.14.2.0.jar:?]
at
org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:53)
~[commons-dbcp2-2.5.0.jar:2.5.0]
at
org.apache.commons.dbcp2.managed.LocalXAConnectionFactory.createConnection(LocalXAConnectionFactory.java:66)
~[commons-dbcp2-2.5.0.jar:2.5.0]
at
org.apache.commons.dbcp2.managed.PoolableManagedConnectionFactory.makeObject(PoolableManagedConnectionFactory.java:67)
~[commons-dbcp2-2.5.0.jar:2.5.0]
at
org.apache.commons.pool2.impl.GenericObjectPool.create(GenericObjectPool.java:883)
~[commons-pool2-2.6.0.jar:2.6.0]
at
org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:436)
~[commons-pool2-2.6.0.jar:2.6.0]
at
org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:365)
~[commons-pool2-2.6.0.jar:2.6.0]
at
org.apache.commons.dbcp2.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:142)
~[commons-dbcp2-2.5.0.jar:2.5.0]
at
org.apache.commons.dbcp2.managed.ManagedConnection.<init>(ManagedConnection.java:75)
~[commons-dbcp2-2.5.0.jar:2.5.0]
at
org.apache.commons.dbcp2.managed.ManagedDataSource.getConnection(ManagedDataSource.java:80)
~[commons-dbcp2-2.5.0.jar:2.5.0]
at
org.apache.ofbiz.entity.connection.DebugManagedDataSource.getConnection(DebugManagedDataSource.java:51)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:66)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.transaction.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:79)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:261)
~[ofbiz.jar:?]
... 8 more
Caused by: org.apache.derby.iapi.error.StandardException: Java exception:
': java.lang.NullPointerException'.
at
org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
~[derby-10.14.2.0.jar:?]
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.wrapArgsForTransportAcrossDRDA(Unknown
Source) ~[derby-10.14.2.0.jar:?]
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source) ~[derby-10.14.2.0.jar:?]
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source)
~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.jdbc.Util.javaException(Unknown Source)
~[derby-10.14.2.0.jar:?]
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source) ~[derby-10.14.2.0.jar:?]
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source) ~[derby-10.14.2.0.jar:?]
at
org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown
Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.jdbc.InternalDriver$1.run(Unknown Source)
~[derby-10.14.2.0.jar:?]
at org.apache.derby.jdbc.InternalDriver$1.run(Unknown Source)
~[derby-10.14.2.0.jar:?]
at java.security.AccessController.doPrivileged(Native Method) ~[?:?]
at
org.apache.derby.jdbc.InternalDriver.getNewEmbedConnection(Unknown Source)
~[derby-10.14.2.0.jar:?]
at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
~[derby-10.14.2.0.jar:?]
at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
~[derby-10.14.2.0.jar:?]
at org.apache.derby.jdbc.EmbeddedDriver.connect(Unknown Source)
~[derby-10.14.2.0.jar:?]
at
org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:53)
~[commons-dbcp2-2.5.0.jar:2.5.0]
at
org.apache.commons.dbcp2.managed.LocalXAConnectionFactory.createConnection(LocalXAConnectionFactory.java:66)
~[commons-dbcp2-2.5.0.jar:2.5.0]
at
org.apache.commons.dbcp2.managed.PoolableManagedConnectionFactory.makeObject(PoolableManagedConnectionFactory.java:67)
~[commons-dbcp2-2.5.0.jar:2.5.0]
at
org.apache.commons.pool2.impl.GenericObjectPool.create(GenericObjectPool.java:883)
~[commons-pool2-2.6.0.jar:2.6.0]
at
org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:436)
~[commons-pool2-2.6.0.jar:2.6.0]
at
org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:365)
~[commons-pool2-2.6.0.jar:2.6.0]
at
org.apache.commons.dbcp2.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:142)
~[commons-dbcp2-2.5.0.jar:2.5.0]
at
org.apache.commons.dbcp2.managed.ManagedConnection.<init>(ManagedConnection.java:75)
~[commons-dbcp2-2.5.0.jar:2.5.0]
at
org.apache.commons.dbcp2.managed.ManagedDataSource.getConnection(ManagedDataSource.java:80)
~[commons-dbcp2-2.5.0.jar:2.5.0]
at
org.apache.ofbiz.entity.connection.DebugManagedDataSource.getConnection(DebugManagedDataSource.java:51)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:66)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.transaction.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:79)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:261)
~[ofbiz.jar:?]
... 8 more
--
Daniel Watford
