[ 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)