[ 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)