[
https://issues.apache.org/jira/browse/AMBARI-8096?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14193456#comment-14193456
]
Hudson commented on AMBARI-8096:
--------------------------------
SUCCESS: Integrated in Ambari-branch-1.7.0 #288 (See
[https://builds.apache.org/job/Ambari-branch-1.7.0/288/])
AMBARI-8096. 1.4.1 -> 1.7.0 upgrade throws exception. (mpapirkovskyy)
(mpapyrkovskyy:
http://git-wip-us.apache.org/repos/asf?p=ambari.git&a=commit&h=d2c5159454018fde6207888d9274a02093c28c08)
*
ambari-server/src/main/java/org/apache/ambari/server/upgrade/UpgradeCatalog150.java
* ambari-server/src/main/java/org/apache/ambari/server/orm/DBAccessorImpl.java
> 1.4.1 -> 1.7.0 upgrade throws exception
> ---------------------------------------
>
> Key: AMBARI-8096
> URL: https://issues.apache.org/jira/browse/AMBARI-8096
> Project: Ambari
> Issue Type: Bug
> Components: ambari-server
> Affects Versions: 1.7.0
> Reporter: Myroslav Papirkovskyy
> Assignee: Myroslav Papirkovskyy
> Priority: Critical
> Fix For: 1.7.0
>
>
> installed 1.4.1 with HDP 2.0, using embedded postgres. upgraded ambari to
> 1.7.0.
> Upgrade complete but exception shown in log.
> {code}
> 16:17:20,545 ERROR [main] DBAccessorImpl:535 - Error executing query: INSERT
> INTO ambari_sequences(sequence_name, sequence_value) SELECT 'cluster_id_seq',
> nextval('clusters_cluster_id_seq') UNION ALL SELECT 'user_id_seq',
> nextval('users_user_id_seq') UNION ALL SELECT 'host_role_command_id_seq',
> COALESCE((SELECT max(task_id) FROM host_role_command), 1) + 50
> org.postgresql.util.PSQLException: ERROR: relation "clusters_cluster_id_seq"
> does not exist
> Position: 94
> at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2161)
> at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1890)
> 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.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:395)
> at
> org.apache.ambari.server.orm.DBAccessorImpl.executeQuery(DBAccessorImpl.java:532)
> at
> org.apache.ambari.server.orm.DBAccessorImpl.executeQuery(DBAccessorImpl.java:518)
> at
> org.apache.ambari.server.upgrade.UpgradeCatalog150.executeDMLUpdates(UpgradeCatalog150.java:443)
> at
> org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.upgradeData(AbstractUpgradeCatalog.java:388)
> at
> org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeDMLUpdates(SchemaUpgradeHelper.java:194)
> at
> org.apache.ambari.server.upgrade.SchemaUpgradeHelper.main(SchemaUpgradeHelper.java:243)
> 16:17:20,557 WARN [main] UpgradeCatalog150:449 - Sequence update threw
> exception.
> org.postgresql.util.PSQLException: ERROR: relation "clusters_cluster_id_seq"
> does not exist
> Position: 94
> at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2161)
> at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1890)
> 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.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:395)
> at
> org.apache.ambari.server.orm.DBAccessorImpl.executeQuery(DBAccessorImpl.java:532)
> at
> org.apache.ambari.server.orm.DBAccessorImpl.executeQuery(DBAccessorImpl.java:518)
> at
> org.apache.ambari.server.upgrade.UpgradeCatalog150.executeDMLUpdates(UpgradeCatalog150.java:443)
> at
> org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.upgradeData(AbstractUpgradeCatalog.java:388)
> at
> org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeDMLUpdates(SchemaUpgradeHelper.java:194)
> at
> org.apache.ambari.server.upgrade.SchemaUpgradeHelper.main(SchemaUpgradeHelper.java:243)
> 16:17:20,557 INFO [main] DBAccessorImpl:529 - Executing query: INSERT INTO
> ambari_sequences(sequence_name, sequence_value) VALUES('configgroup_id_seq',
> 1)
> 16:17:20,559 INFO [main] DBAccessorImpl:529 - Executing query: INSERT INTO
> ambari_sequences(sequence_name, sequence_value)
> VALUES('requestschedule_id_seq', 1)
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
