Caused by: org.apache.derby.iapi.error.StandardException: Java exception: ': java.lang.NullPointerException'.
Not sure what could cause a NPE in the JDBC code. Missing configuration setting or something? Or maybe a blank for the Port number for the DB in the config file?
Regards, Steve On 9/14/23 02:54, Daniel Watford wrote:
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
OpenPGP_signature
Description: OpenPGP digital signature