The issues start in SecurityPermissionSeedData.xml file , we try many time to solve........
2024-08-01 17:00:49,311 |main |EntitySaxReader |I| Beginning import from URL: file:/E:/opensource/apache-ofbiz-18.12.14/framework/security/data/SecurityPermissionSeedData.xml 2024-08-01 17:00:49,327 |main |EntitySaxReader |I| Transaction Timeout set to 2 hours (7200 seconds) 2024-08-01 17:00:49,342 |main |GenericDelegator |E| Failure in storeAll operation: 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. On Tue, Jul 30, 2024 at 10:34 PM Sameer Alwosaby <sameeralwos...@gmail.com> wrote: > > > Hello Community > > We received the below issues when we try to configure when > apache-ofbiz-18.12.14 with PostgreSQL db 13 ,but when we try with > apache-ofbiz-18.12.10 with the same PostgreSQL db 13 configuration ,it's > working property. > > > > > 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.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:351) > ~[ofbiz.jar:?] > at > org.apache.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:488) > ~[ofbiz.jar:?] > at > org.apache.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:466) > ~[ofbiz.jar:?] > at > org.apache.ofbiz.entity.datasource.GenericHelperDAO.findByPrimaryKey(GenericHelperDAO.java:81) > ~[ofbiz.jar:?] > at > org.apache.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1314) > ~[ofbiz.jar:?] > at > org.apache.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:258) > ~[ofbiz.jar:?] > at > org.apache.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:228) > ~[ofbiz.jar:?] > at > org.apache.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:205) > ~[ofbiz.jar:?] > at > org.apache.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:268) > ~[ofbiz.jar:?] > at > org.apache.ofbiz.entityext.data.EntityDataLoadContainer.loadData(EntityDataLoadContainer.java:437) > ~[ofbiz.jar:?] > at > org.apache.ofbiz.entityext.data.EntityDataLoadContainer.loadDataForDelegator(EntityDataLoadContainer.java:184) > ~[ofbiz.jar:?] > at > org.apache.ofbiz.entityext.data.EntityDataLoadContainer.init(EntityDataLoadContainer.java:116) > ~[ofbiz.jar:?] > at > org.apache.ofbiz.base.container.ContainerLoader.loadContainer(ContainerLoader.java:134) > ~[ofbiz.jar:?] > at > org.apache.ofbiz.base.container.ContainerLoader.loadContainersFromConfigurations(ContainerLoader.java:99) > ~[ofbiz.jar:?] > at > org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:69) > ~[ofbiz.jar:?] > at > org.apache.ofbiz.base.start.StartupControlPanel.loadStartupLoaders(StartupControlPanel.java:218) > ~[ofbiz.jar:?] > at > org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:71) > ~[ofbiz.jar:?] > at org.apache.ofbiz.base.start.Start.main(Start.java:85) > ~[ofbiz.jar:?] > 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:?] > ... 19 more > Caused by: java.util.NoSuchElementException: Unable to activate object > at > org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:474) > ~[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:?] > ... 19 more > Caused by: org.postgresql.util.PSQLException: This ResultSet is closed. > at > org.postgresql.jdbc2.AbstractJdbc2ResultSet.checkClosed(AbstractJdbc2ResultSet.java:2654) > ~[postgresql-9.1-901.jdbc4.jar:?] > at > org.postgresql.jdbc2.AbstractJdbc2ResultSet.setFetchSize(AbstractJdbc2ResultSet.java:1771) > ~[postgresql-9.1-901.jdbc4.jar:?] > at > org.postgresql.jdbc4.Jdbc4Statement.createResultSet(Jdbc4Statement.java:39) > ~[postgresql-9.1-901.jdbc4.jar:?] > at > org.postgresql.jdbc2.AbstractJdbc2Statement$StatementResultHandler.handleResultRows(AbstractJdbc2Statement.java:211) > ~[postgresql-9.1-901.jdbc4.jar:?] > at > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1773) > ~[postgresql-9.1-901.jdbc4.jar:?] > at > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) > ~[postgresql-9.1-901.jdbc4.jar:?] > at > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512) > ~[postgresql-9.1-901.jdbc4.jar:?] > at > org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374) > ~[postgresql-9.1-901.jdbc4.jar:?] > at > org.postgresql.jdbc2.AbstractJdbc2Connection.execSQLUpdate(AbstractJdbc2Connection.java:263) > ~[postgresql-9.1-901.jdbc4.jar:?] > at > org.postgresql.jdbc2.AbstractJdbc2Connection.getTransactionIsolation(AbstractJdbc2Connection.java:775) > ~[postgresql-9.1-901.jdbc4.jar:?] > at > org.apache.commons.dbcp2.DelegatingConnection.getTransactionIsolation(DelegatingConnection.java:414) > ~[commons-dbcp2-2.5.0.jar:2.5.0] > at > org.apache.commons.dbcp2.PoolableConnectionFactory.activateObject(PoolableConnectionFactory.java:434) > ~[commons-dbcp2-2.5.0.jar:2.5.0] > at > org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:465) > ~[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:?] > ... 19 more > > >
