History | Log In     View a printable version of the current page.  
Issue Details (XML | Word | Printable)

Key: QB-3235
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Critical Critical
Assignee: Robin Shen
Reporter: Adam
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
QuickBuild

QuickBuild with

Created: 09/Aug/18 02:47 PM   Updated: 10/Aug/18 01:09 AM
Component/s: None
Affects Version/s: 8.0.15
Fix Version/s: None

Original Estimate: Unknown Remaining Estimate: Unknown Time Spent: Unknown
Environment: CentOS 7 with external database on PostgreSQL 10.2


 Description  « Hide
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.




 All   Comments   Work Log   Change History      Sort Order:
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