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/08/10 12:53:00 UTC
[jira] [Resolved] (AMBARI-24251) Ambari Schema Upgrade is failing
after creating views
[ https://issues.apache.org/jira/browse/AMBARI-24251?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dmitry Lysnichenko resolved AMBARI-24251.
-----------------------------------------
Resolution: Fixed
> 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
> Components: ambari-server
> Reporter: Dmitry Lysnichenko
> Assignee: Dmitry Lysnichenko
> Priority: Blocker
> Labels: pull-request-available
> Time Spent: 1.5h
> Remaining Estimate: 0h
>
> 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)