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 19:58:33 UTC
[jira] [Created] (AMBARI-8096) 1.4.1 -> 1.7.0 upgrade throws
exception
Myroslav Papirkovskyy created AMBARI-8096:
---------------------------------------------
Summary: 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)