You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ambari.apache.org by "Dmitry Lysnichenko (JIRA)" <ji...@apache.org> on 2018/07/05 16:09:00 UTC
[jira] [Created] (AMBARI-24251) Ambari Schema Upgrade is failing
after creating views
Dmitry Lysnichenko created AMBARI-24251:
-------------------------------------------
Summary: Ambari Schema Upgrade is failing after creating views
Key: AMBARI-24251
URL: https://issues.apache.org/jira/browse/AMBARI-24251
Project: Ambari
Issue Type: Bug
Reporter: Dmitry Lysnichenko
Assignee: Dmitry Lysnichenko
Created below Views On Cluster with ambari 2.6.0 :
1. Workflow Manager (Create a workflow and save it)
2. Hive
3. Pig
4. Files
Upgrading the Ambari Server to 2.7.0, below is the stacktrace:
{code}
SchemaUpgradeHelper:238 - Upgrade failed.
org.postgresql.util.PSQLException: ERROR: update or delete on table "servicecomponentdesiredstate" violates foreign key constraint "fk_hostcomponentdesiredstate_component_name" on table "hostcomponentdesiredstate"
Detail: Key (component_name, service_name, cluster_id)=(INFRA_SOLR_CLIENT, AMBARI_INFRA, 2) is still referenced from table "hostcomponentdesiredstate".
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2433)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2178)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
at org.postgresql.jdbc.PgStatement.executeUpdate(PgStatement.java:244)
at org.apache.ambari.server.orm.DBAccessorImpl.updateTable(DBAccessorImpl.java:822)
at org.apache.ambari.server.upgrade.UpgradeCatalog270.renameAmbariInfra(UpgradeCatalog270.java:1056)
at org.apache.ambari.server.upgrade.UpgradeCatalog270.executeDMLUpdates(UpgradeCatalog270.java:1033)
at org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.upgradeData(AbstractUpgradeCatalog.java:985)
at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeDMLUpdates(SchemaUpgradeHelper.java:236)
at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.main(SchemaUpgradeHelper.java:456)
2018-06-29 14:12:03,840 ERROR [main] SchemaUpgradeHelper:473 - Exception occurred during upgrade, failed
org.apache.ambari.server.AmbariException: ERROR: update or delete on table "servicecomponentdesiredstate" violates foreign key constraint "fk_hostcomponentdesiredstate_component_name" on table "hostcomponentdesiredstate"
Detail: Key (component_name, service_name, cluster_id)=(INFRA_SOLR_CLIENT, AMBARI_INFRA, 2) is still referenced from table "hostcomponentdesiredstate".
at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeDMLUpdates(SchemaUpgradeHelper.java:239)
at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.main(SchemaUpgradeHelper.java:456)
Caused by: org.postgresql.util.PSQLException: ERROR: update or delete on table "servicecomponentdesiredstate" violates foreign key constraint "fk_hostcomponentdesiredstate_component_name" on table "hostcomponentdesiredstate"
Detail: Key (component_name, service_name, cluster_id)=(INFRA_SOLR_CLIENT, AMBARI_INFRA, 2) is still referenced from table "hostcomponentdesiredstate".
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2433)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2178)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
at org.postgresql.jdbc.PgStatement.executeUpdate(PgStatement.java:244)
at org.apache.ambari.server.orm.DBAccessorImpl.updateTable(DBAccessorImpl.java:822)
at org.apache.ambari.server.upgrade.UpgradeCatalog270.renameAmbariInfra(UpgradeCatalog270.java:1056)
at org.apache.ambari.server.upgrade.UpgradeCatalog270.executeDMLUpdates(UpgradeCatalog270.java:1033)
at org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.upgradeData(AbstractUpgradeCatalog.java:985)
at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeDMLUpdates(SchemaUpgradeHelper.java:236)
... 1 more
{code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)