[AMBARI-24251] Ambari Schema Upgrade is failing after creating views

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Fixed
• Component/s: ambari-server
• Labels: pull-request-available
• Assignee: Dmitry Lysnichenko
• Reporter: Dmitry Lysnichenko
• Created: 05/Jul/18 16:08
• Updated: 10/Aug/18 12:52
• Resolved: 10/Aug/18 12:52

Description

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:

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

Issue Links

• links to: GitHub Pull Request #1682
• links to: GitHub Pull Request #1683