[
https://issues.apache.org/jira/browse/AMBARI-24131?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jonathan Hurley resolved AMBARI-24131.
--------------------------------------
Resolution: Fixed
> Unable to Perform Rolling Restarts Because of Outdated Postgres Driver
> ----------------------------------------------------------------------
>
> Key: AMBARI-24131
> URL: https://issues.apache.org/jira/browse/AMBARI-24131
> Project: Ambari
> Issue Type: Bug
> Affects Versions: 2.7.0
> Reporter: Vivek Rathod
> Assignee: Jonathan Hurley
> Priority: Blocker
> Labels: pull-request-available
> Fix For: 2.7.0
>
> Time Spent: 1h
> Remaining Estimate: 0h
>
> When attempting to perform any rolling restart where Ambari's database is
> Postgres 10+, the following error is seen in the logs:
> {code}
> 2018-06-15 20:31:24,606 WARN
> [C3P0PooledConnectionPoolManager[identityToken->1br4e2s9wodqogrilkm7|7536ef0f]-HelperThread-#1]
> BasicResourcePool:223 -
> com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@48d8907f
> -- 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:
> org.postgresql.util.PSQLException: This ResultSet is closed.
> at
> org.postgresql.jdbc2.AbstractJdbc2ResultSet.checkClosed(AbstractJdbc2ResultSet.java:2852)
> at
> org.postgresql.jdbc2.AbstractJdbc2ResultSet.setFetchSize(AbstractJdbc2ResultSet.java:1875)
> at
> org.postgresql.jdbc4.Jdbc4Statement.createResultSet(Jdbc4Statement.java:37)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement$StatementResultHandler.handleResultRows(AbstractJdbc2Statement.java:219)
> at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1816)
> at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:559)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403)
> at
> org.postgresql.jdbc2.AbstractJdbc2Connection.execSQLUpdate(AbstractJdbc2Connection.java:376)
> at
> org.postgresql.jdbc2.AbstractJdbc2Connection.getTransactionIsolation(AbstractJdbc2Connection.java:898)
> at
> com.mchange.v2.c3p0.impl.NewPooledConnection.<init>(NewPooledConnection.java:120)
> at
> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:240)
> at
> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
> at
> com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203)
> at
> com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1138)
> at
> com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1125)
> at
> com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
> at
> com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1870)
> at
> com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
> {code}
> Ambari uses Quartz to schedule the rolling requests and the current Postgres
> driver (9.3) doesn't work against a Postgres 10 database.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
