You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ambari.apache.org by "Myroslav Papirkovskyy (JIRA)" <ji...@apache.org> on 2014/11/01 20:50:33 UTC
[jira] [Resolved] (AMBARI-8096) 1.4.1 -> 1.7.0 upgrade throws
exception
[ https://issues.apache.org/jira/browse/AMBARI-8096?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Myroslav Papirkovskyy resolved AMBARI-8096.
-------------------------------------------
Resolution: Fixed
pushed to trunk and branch-1.7.0
> 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)