[
https://issues.apache.org/jira/browse/AMBARI-16256?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
DIPAYAN BHOWMICK updated AMBARI-16256:
--------------------------------------
Attachment: AMBARI-16256.trunk.patch
> Upgrade throws error while updating the sequence table
> ------------------------------------------------------
>
> Key: AMBARI-16256
> URL: https://issues.apache.org/jira/browse/AMBARI-16256
> Project: Ambari
> Issue Type: Bug
> Components: ambari-server
> Affects Versions: 2.4.0
> Reporter: DIPAYAN BHOWMICK
> Assignee: DIPAYAN BHOWMICK
> Fix For: 2.4.0
>
> Attachments: AMBARI-16256.trunk.patch
>
>
> Following exception happens while upgrading Ambari:
> {noformat}
> Upgrading database schema
> Error output from schema upgrade command:
> Exception in thread "main" org.apache.ambari.server.AmbariException:
> ResultSet not positioned properly, perhaps you need to call next.
> at
> org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeDMLUpdates(SchemaUpgradeHelper.java:234)
> at
> org.apache.ambari.server.upgrade.SchemaUpgradeHelper.main(SchemaUpgradeHelper.java:308)
> Caused by: org.postgresql.util.PSQLException: ResultSet not positioned
> properly, perhaps you need to call next.
> at
> org.postgresql.jdbc2.AbstractJdbc2ResultSet.checkResultSet(AbstractJdbc2ResultSet.java:2881)
> at
> org.postgresql.jdbc2.AbstractJdbc2ResultSet.getInt(AbstractJdbc2ResultSet.java:2117)
> at
> org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.getAndIncrementSequence(AbstractUpgradeCatalog.java:173)
> at
> org.apache.ambari.server.orm.AmbariJpaLocalTxnInterceptor.invoke(AmbariJpaLocalTxnInterceptor.java:128)
> at
> org.apache.ambari.server.upgrade.UpgradeCatalog240.updateClusterInheritedPermissionsConfig(UpgradeCatalog240.java:274)
> at
> org.apache.ambari.server.upgrade.UpgradeCatalog240.executeDMLUpdates(UpgradeCatalog240.java:264)
> at
> org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.upgradeData(AbstractUpgradeCatalog.java:702)
> at
> org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeDMLUpdates(SchemaUpgradeHelper.java:231)
> ... 1 more
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
