Hi QB Support Team,
Have you had a chance to test QuickBuild 8.015 setup with PostgreSQL 10?
According to
https://wiki.pmease.com/display/QB80/Data+Management it should work -> Currently the following database type other than the embedded H2 are supported: PostgreSQL 9.0 or higher
Still I'm ending up with following errors (logging in DEBUG mode) - see extract of console log output:
jvm 1 | 2018-08-08 12:34:50,082 DEBUG - Executing sql: alter table QB_TRIGGER_DEPENDENCE add constraint FK_TRIG_DEPDENT foreign key (QB_DEPENDENT_ID) references QB_CONFIGURATION
jvm 1 | 2018-08-08 12:34:50,084 DEBUG - Executing sql: alter table QB_USER_SHARE add constraint FK_U_SHARE_DASH foreign key (QB_DASHBOARD_ID) references QB_DASHBOARD
jvm 1 | 2018-08-08 12:34:50,086 DEBUG - Executing sql: alter table QB_USER_SHARE add constraint FK_SHARE_USER foreign key (QB_USER_ID) references QB_USER
jvm 1 | 2018-08-08 12:35:20,584 WARN - com.mchange.v2.resourcepool.BasicResourcePool$
ScatteredAcquireTask@61f8fda6 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception:
jvm 1 | org.postgresql.util.PSQLException: This ResultSet is closed.
jvm 1 | at org.postgresql.jdbc2.AbstractJdbc2ResultSet.checkClosed(AbstractJdbc2ResultSet.java:2852)
jvm 1 | at org.postgresql.jdbc2.AbstractJdbc2ResultSet.setFetchSize(AbstractJdbc2ResultSet.java:1875)
jvm 1 | at org.postgresql.jdbc4.Jdbc4Statement.createResultSet(Jdbc4Statement.java:37)
jvm 1 | at org.postgresql.jdbc2.AbstractJdbc2Statement$StatementResultHandler.handleResultRows(AbstractJdbc2Statement.java:219)
jvm 1 | at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1816)
jvm 1 | at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
jvm 1 | at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:559)
jvm 1 | at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403)
jvm 1 | at org.postgresql.jdbc2.AbstractJdbc2Connection.execSQLUpdate(AbstractJdbc2Connection.java:376)
jvm 1 | at org.postgresql.jdbc2.AbstractJdbc2Connection.getTransactionIsolation(AbstractJdbc2Connection.java:898)
jvm 1 | at com.mchange.v2.c3p0.impl.NewPooledConnection.<init>(NewPooledConnection.java:125)
jvm 1 | at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:211)
jvm 1 | at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:184)
jvm 1 | at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:200)
jvm 1 | at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1086)
jvm 1 | at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1073)
jvm 1 | at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:44)
jvm 1 | at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1810)
jvm 1 | at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:648)
jvm 1 | 2018-08-08 12:35:20,585 WARN - Having failed to acquire a resource,
com.mchange.v2.resourcepool.BasicResourcePool@4ffd1e1a is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
jvm 1 | 2018-08-08 12:35:20,584 WARN - com.mchange.v2.resourcepool.BasicResourcePool$
ScatteredAcquireTask@50682854 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception:
jvm 1 | org.postgresql.util.PSQLException: This ResultSet is closed.