<< Back to previous view |
[QB-3235] QuickBuild with
|
|
Status: | Closed |
Project: | QuickBuild |
Component/s: | None |
Affects Version/s: | 8.0.15 |
Fix Version/s: | None |
Type: | Bug | Priority: | Critical |
Reporter: | Adam | Assigned To: | Robin Shen |
Resolution: | Fixed | Votes: | 0 |
Remaining Estimate: | Unknown | Time Spent: | Unknown |
Original Estimate: | Unknown | ||
Environment: | CentOS 7 with external database on PostgreSQL 10.2 |
Description |
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. |
Comments |
Comment by Robin Shen [ 10/Aug/18 01:09 AM ] |
To work with PostgreSQL 10, please upgrade jdbc driver to latest version in "plugins\com.pmease.quickbuild.libs":
https://jdbc.postgresql.org/download.html |