Details
-
Bug
-
Status: Resolved
-
Major
-
Resolution: Fixed
-
1.5.0
-
None
Description
Noticed few exceptions at server log when trying to update ambari-server from version 1.4.1 to current trunk c2f3eb7 . Not sure how critical that is because ambari-server seems to work after update
1:54:13,537 WARN [main] DBAccessorImpl:415 - Error executing query: ALTER TABLE hostcomponentdesiredconfigmapping rename to hcdesiredconfigmapping; org.postgresql.util.PSQLException: ERROR: relation "hostcomponentdesiredconfigmapping" does not exist at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:366) at org.apache.ambari.server.orm.DBAccessorImpl.executeQuery(DBAccessorImpl.java:413) at org.apache.ambari.server.upgrade.UpgradeCatalog150.executeDDLUpdates(UpgradeCatalog150.java:263) at org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.upgradeSchema(AbstractUpgradeCatalog.java:177) at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeUpgrade(SchemaUpgradeHelper.java:174) at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.main(SchemaUpgradeHelper.java:234) 21:54:13,539 INFO [main] DBAccessorImpl:410 - Executing query: ALTER TABLE users ALTER column user_id DROP DEFAULT; 21:54:13,540 INFO [main] DBAccessorImpl:410 - Executing query: ALTER TABLE users ALTER column ldap_user TYPE INTEGER USING CASE WHEN ldap_user=true THEN 1 ELSE 0 END; 21:54:13,548 WARN [main] DBAccessorImpl:415 - Error executing query: ALTER TABLE users ALTER column ldap_user TYPE INTEGER USING CASE WHEN ldap_user=true THEN 1 ELSE 0 END; org.postgresql.util.PSQLException: ERROR: operator does not exist: integer = boolean Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:366) at org.apache.ambari.server.orm.DBAccessorImpl.executeQuery(DBAccessorImpl.java:413) at org.apache.ambari.server.upgrade.UpgradeCatalog150.executeDDLUpdates(UpgradeCatalog150.java:265) at org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.upgradeSchema(AbstractUpgradeCatalog.java:177) at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeUpgrade(SchemaUpgradeHelper.java:174) at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.main(SchemaUpgradeHelper.java:234) 21:54:13,548 INFO [main] DBAccessorImpl:410 - Executing query: ALTER TABLE hosts DROP COLUMN disks_info; 21:54:13,554 INFO [main] DBAccessorImpl:410 - Executing query: insert into ambari.request(request_id, cluster_id, request_context, start_time, end_time, create_time) ( select distinct s.request_id, s.cluster_id, s.request_context, coalesce (cmd.start_time, -1), coalesce (cmd.end_time, -1), -1 from (select distinct request_id, cluster_id, request_context from ambari.stage ) s left join (select request_id, min(start_time) as start_time, max(end_time) as end_time from ambari.host_role_command group by request_id) cmd on s.request_id=cmd.request_id ) 21:54:13,559 INFO [main] DBAccessorImpl:410 - Executing query: ALTER TABLE clusterconfigmapping DROP CONSTRAINT FK_clusterconfigmapping_cluster_id 21:54:13,561 INFO [main] DBAccessorImpl:410 - Executing query: ALTER TABLE hostcomponentdesiredstate DROP CONSTRAINT FK_hostcomponentdesiredstate_host_name 21:54:13,562 INFO [main] DBAccessorImpl:410 - Executing query: ALTER TABLE hostcomponentdesiredstate DROP CONSTRAINT FK_hostcomponentdesiredstate_component_name 21:54:13,564 INFO [main] DBAccessorImpl:410 - Executing query: ALTER TABLE hostcomponentstate DROP CONSTRAINT FK_hostcomponentstate_component_name 21:54:13,566 INFO [main] DBAccessorImpl:410 - Executing query: ALTER TABLE hostcomponentstate DROP CONSTRAINT FK_hostcomponentstate_host_name 21:54:13,568 INFO [main] DBAccessorImpl:410 - Executing query: ALTER TABLE servicecomponentdesiredstate DROP CONSTRAINT FK_servicecomponentdesiredstate_service_name 21:54:13,571 INFO [main] DBAccessorImpl:410 - Executing query: ALTER TABLE servicedesiredstate DROP CONSTRAINT FK_servicedesiredstate_service_name 21:54:13,573 INFO [main] DBAccessorImpl:410 - Executing query: ALTER TABLE role_success_criteria DROP CONSTRAINT FK_role_success_criteria_stage_id 21:54:13,575 INFO [main] DBAccessorImpl:410 - Executing query: ALTER TABLE ClusterHostMapping DROP CONSTRAINT FK_ClusterHostMapping_host_name 21:54:13,577 INFO [main] DBAccessorImpl:410 - Executing query: ALTER TABLE ClusterHostMapping DROP CONSTRAINT FK_ClusterHostMapping_cluster_id 21:54:13,619 INFO [main] DBAccessorImpl:410 - Executing query: ALTER TABLE clusterconfigmapping ADD CONSTRAINT clusterconfigmappingcluster_id FOREIGN KEY (cluster_id) REFERENCES clusters (cluster_id) 21:54:13,639 INFO [main] DBAccessorImpl:410 - Executing query: ALTER TABLE hostcomponentdesiredstate ADD CONSTRAINT hstcmponentdesiredstatehstname FOREIGN KEY (host_name) REFERENCES hosts (host_name) 21:54:13,643 INFO [main] DBAccessorImpl:410 - Executing query: ALTER TABLE hostcomponentdesiredstate ADD CONSTRAINT hstcmpnntdesiredstatecmpnntnme FOREIGN KEY (component_name, cluster_id, service_name) REFERENCES servicecomponentdesiredstate (component_name, cluster_id, service_name) 21:54:13,645 INFO [main] DBAccessorImpl:410 - Executing query: ALTER TABLE hostcomponentstate ADD CONSTRAINT hstcomponentstatecomponentname FOREIGN KEY (component_name, cluster_id, service_name) REFERENCES servicecomponentdesiredstate (component_name, cluster_id, service_name) 21:54:13,666 INFO [main] DBAccessorImpl:410 - Executing query: ALTER TABLE hostcomponentstate ADD CONSTRAINT hostcomponentstate_host_name FOREIGN KEY (host_name) REFERENCES hosts (host_name) 21:54:13,670 INFO [main] DBAccessorImpl:410 - Executing query: ALTER TABLE servicecomponentdesiredstate ADD CONSTRAINT srvccmponentdesiredstatesrvcnm FOREIGN KEY (service_name, cluster_id) REFERENCES clusterservices (service_name, cluster_id) 21:54:13,672 INFO [main] DBAccessorImpl:410 - Executing query: ALTER TABLE servicedesiredstate ADD CONSTRAINT servicedesiredstateservicename FOREIGN KEY (service_name, cluster_id) REFERENCES clusterservices (service_name, cluster_id) 21:54:13,674 INFO [main] DBAccessorImpl:410 - Executing query: ALTER TABLE role_success_criteria ADD CONSTRAINT role_success_criteria_stage_id FOREIGN KEY (stage_id, request_id) REFERENCES stage (stage_id, request_id) 21:54:13,701 INFO [main] DBAccessorImpl:410 - Executing query: ALTER TABLE ClusterHostMapping ADD CONSTRAINT ClusterHostMapping_cluster_id FOREIGN KEY (cluster_id) REFERENCES clusters (cluster_id) 21:54:13,719 INFO [main] DBAccessorImpl:410 - Executing query: ALTER TABLE ClusterHostMapping ADD CONSTRAINT ClusterHostMapping_host_name FOREIGN KEY (host_name) REFERENCES hosts (host_name) 21:54:13,722 INFO [main] DBAccessorImpl:410 - Executing query: ALTER TABLE confgroupclusterconfigmapping DROP CONSTRAINT FK_confgroupclusterconfigmapping_config_tag 21:54:13,723 WARN [main] DBAccessorImpl:415 - Error executing query: ALTER TABLE confgroupclusterconfigmapping DROP CONSTRAINT FK_confgroupclusterconfigmapping_config_tag org.postgresql.util.PSQLException: ERROR: constraint "fk_confgroupclusterconfigmapping_config_tag" of relation "confgroupclusterconfigmapping" does not exist at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:366) at org.apache.ambari.server.orm.DBAccessorImpl.executeQuery(DBAccessorImpl.java:413) at org.apache.ambari.server.orm.DBAccessorImpl.dropConstraint(DBAccessorImpl.java:453) at org.apache.ambari.server.upgrade.UpgradeCatalog150.executeDDLUpdates(UpgradeCatalog150.java:344) at org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.upgradeSchema(AbstractUpgradeCatalog.java:177) at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeUpgrade(SchemaUpgradeHelper.java:174) at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.main(SchemaUpgradeHelper.java:234) 21:54:13,723 INFO [main] DBAccessorImpl:410 - Executing query: ALTER TABLE confgroupclusterconfigmapping DROP CONSTRAINT FK_confgroupclusterconfigmapping_group_id 21:54:13,723 WARN [main] DBAccessorImpl:415 - Error executing query: ALTER TABLE confgroupclusterconfigmapping DROP CONSTRAINT FK_confgroupclusterconfigmapping_group_id org.postgresql.util.PSQLException: ERROR: constraint "fk_confgroupclusterconfigmapping_group_id" of relation "confgroupclusterconfigmapping" does not exist at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:366) at org.apache.ambari.server.orm.DBAccessorImpl.executeQuery(DBAccessorImpl.java:413) at org.apache.ambari.server.orm.DBAccessorImpl.dropConstraint(DBAccessorImpl.java:453) at org.apache.ambari.server.upgrade.UpgradeCatalog150.executeDDLUpdates(UpgradeCatalog150.java:345) at org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.upgradeSchema(AbstractUpgradeCatalog.java:177) at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeUpgrade(SchemaUpgradeHelper.java:174) at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.main(SchemaUpgradeHelper.java:234) 21:54:13,724 INFO [main] DBAccessorImpl:410 - Executing query: ALTER TABLE configgrouphostmapping DROP CONSTRAINT FK_configgrouphostmapping_configgroup_id 21:54:13,724 WARN [main] DBAccessorImpl:415 - Error executing query: ALTER TABLE configgrouphostmapping DROP CONSTRAINT FK_configgrouphostmapping_configgroup_id org.postgresql.util.PSQLException: ERROR: constraint "fk_configgrouphostmapping_configgroup_id" of relation "configgrouphostmapping" does not exist at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:366) at org.apache.ambari.server.orm.DBAccessorImpl.executeQuery(DBAccessorImpl.java:413) at org.apache.ambari.server.orm.DBAccessorImpl.dropConstraint(DBAccessorImpl.java:453) at org.apache.ambari.server.upgrade.UpgradeCatalog150.executeDDLUpdates(UpgradeCatalog150.java:346) at org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.upgradeSchema(AbstractUpgradeCatalog.java:177) at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeUpgrade(SchemaUpgradeHelper.java:174) at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.main(SchemaUpgradeHelper.java:234) 21:54:13,725 INFO [main] DBAccessorImpl:410 - Executing query: ALTER TABLE configgrouphostmapping DROP CONSTRAINT FK_configgrouphostmapping_host_name 21:54:13,725 WARN [main] DBAccessorImpl:415 - Error executing query: ALTER TABLE configgrouphostmapping DROP CONSTRAINT FK_configgrouphostmapping_host_name org.postgresql.util.PSQLException: ERROR: constraint "fk_configgrouphostmapping_host_name" of relation "configgrouphostmapping" does not exist at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:366) at org.apache.ambari.server.orm.DBAccessorImpl.executeQuery(DBAccessorImpl.java:413) at org.apache.ambari.server.orm.DBAccessorImpl.dropConstraint(DBAccessorImpl.java:453) at org.apache.ambari.server.upgrade.UpgradeCatalog150.executeDDLUpdates(UpgradeCatalog150.java:347) at org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.upgradeSchema(AbstractUpgradeCatalog.java:177) at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeUpgrade(SchemaUpgradeHelper.java:174) at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.main(SchemaUpgradeHelper.java:234) 21:54:13,742 INFO [main] DBAccessorImpl:410 - Executing query: ALTER TABLE stage ADD CONSTRAINT FK_stage_request_id FOREIGN KEY (request_id) REFERENCES request (request_id) 21:54:13,767 INFO [main] DBAccessorImpl:410 - Executing query: ALTER TABLE request ADD CONSTRAINT FK_request_cluster_id FOREIGN KEY (cluster_id) REFERENCES clusters (cluster_id) 21:54:13,790 INFO [main] DBAccessorImpl:410 - Executing query: ALTER TABLE request ADD CONSTRAINT FK_request_schedule_id FOREIGN KEY (request_schedule_id) REFERENCES requestschedule (schedule_id) 21:54:13,808 INFO [main] DBAccessorImpl:410 - Executing query: ALTER TABLE requestschedulebatchrequest ADD CONSTRAINT FK_rsbatchrequest_schedule_id FOREIGN KEY (schedule_id) REFERENCES requestschedule (schedule_id) 21:54:13,823 INFO [main] DBAccessorImpl:410 - Executing query: ALTER TABLE hostconfigmapping ADD CONSTRAINT FK_hostconfmapping_cluster_id FOREIGN KEY (cluster_id) REFERENCES clusters (cluster_id) 21:54:13,839 INFO [main] DBAccessorImpl:410 - Executing query: ALTER TABLE hostconfigmapping ADD CONSTRAINT FK_hostconfmapping_host_name FOREIGN KEY (host_name) REFERENCES hosts (host_name) 21:54:13,855 INFO [main] DBAccessorImpl:410 - Executing query: ALTER TABLE configgroup ADD CONSTRAINT FK_configgroup_cluster_id FOREIGN KEY (cluster_id) REFERENCES clusters (cluster_id) 21:54:13,857 INFO [main] DBAccessorImpl:410 - Executing query: ALTER TABLE confgroupclusterconfigmapping ADD CONSTRAINT FK_confg FOREIGN KEY (version_tag, config_type, cluster_id) REFERENCES clusterconfig (version_tag, type_name, cluster_id) 21:54:13,873 INFO [main] DBAccessorImpl:410 - Executing query: ALTER TABLE confgroupclusterconfigmapping ADD CONSTRAINT FK_cgccm_gid FOREIGN KEY (config_group_id) REFERENCES configgroup (group_id) 21:54:13,894 INFO [main] DBAccessorImpl:410 - Executing query: ALTER TABLE configgrouphostmapping ADD CONSTRAINT FK_cghm_cgid FOREIGN KEY (config_group_id) REFERENCES configgroup (group_id) 21:54:13,910 INFO [main] DBAccessorImpl:410 - Executing query: ALTER TABLE configgrouphostmapping ADD CONSTRAINT FK_cghm_hname FOREIGN KEY (host_name) REFERENCES hosts (host_name) 21:54:13,925 INFO [main] DBAccessorImpl:410 - Executing query: ALTER TABLE clusterconfigmapping ADD CONSTRAINT FK_clustercfgmap_cluster_id FOREIGN KEY (cluster_id) REFERENCES clusters (cluster_id) 21:54:13,941 INFO [main] DBAccessorImpl:410 - Executing query: ALTER TABLE requestresourcefilter ADD CONSTRAINT FK_reqresfilter_req_id FOREIGN KEY (request_id) REFERENCES request (request_id) 21:54:13,959 INFO [main] DBAccessorImpl:410 - Executing query: ALTER TABLE hostgroup ADD CONSTRAINT FK_hostgroup_blueprint_name FOREIGN KEY (blueprint_name) REFERENCES blueprint (blueprint_name) 21:54:13,980 INFO [main] DBAccessorImpl:410 - Executing query: ALTER TABLE hostgroup_component ADD CONSTRAINT FK_hg_blueprint_name FOREIGN KEY (blueprint_name) REFERENCES hostgroup (blueprint_name) 21:54:13,981 WARN [main] DBAccessorImpl:415 - Error executing query: ALTER TABLE hostgroup_component ADD CONSTRAINT FK_hg_blueprint_name FOREIGN KEY (blueprint_name) REFERENCES hostgroup (blueprint_name) org.postgresql.util.PSQLException: ERROR: there is no unique constraint matching given keys for referenced table "hostgroup" at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:366) at org.apache.ambari.server.orm.DBAccessorImpl.executeQuery(DBAccessorImpl.java:413) at org.apache.ambari.server.orm.DBAccessorImpl.executeQuery(DBAccessorImpl.java:399) at org.apache.ambari.server.orm.DBAccessorImpl.addFKConstraint(DBAccessorImpl.java:262) at org.apache.ambari.server.upgrade.UpgradeCatalog150.executeDDLUpdates(UpgradeCatalog150.java:369) at org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.upgradeSchema(AbstractUpgradeCatalog.java:177) at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeUpgrade(SchemaUpgradeHelper.java:174) at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.main(SchemaUpgradeHelper.java:234) 21:54:13,982 WARN [main] DBAccessorImpl:264 - Add FK constraint failed, constraintName = FK_hg_blueprint_name, tableName = hostgroup_component, errorCode = 0, message = ERROR: there is no unique constraint matching given keys for referenced table "hostgroup" 21:54:14,002 INFO [main] DBAccessorImpl:410 - Executing query: ALTER TABLE hostgroup_component ADD CONSTRAINT FK_hgc_blueprint_name FOREIGN KEY (hostgroup_name) REFERENCES hostgroup (name) 21:54:14,004 WARN [main] DBAccessorImpl:415 - Error executing query: ALTER TABLE hostgroup_component ADD CONSTRAINT FK_hgc_blueprint_name FOREIGN KEY (hostgroup_name) REFERENCES hostgroup (name) org.postgresql.util.PSQLException: ERROR: there is no unique constraint matching given keys for referenced table "hostgroup" at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:366) at org.apache.ambari.server.orm.DBAccessorImpl.executeQuery(DBAccessorImpl.java:413) at org.apache.ambari.server.orm.DBAccessorImpl.executeQuery(DBAccessorImpl.java:399) at org.apache.ambari.server.orm.DBAccessorImpl.addFKConstraint(DBAccessorImpl.java:262) at org.apache.ambari.server.upgrade.UpgradeCatalog150.executeDDLUpdates(UpgradeCatalog150.java:370) at org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.upgradeSchema(AbstractUpgradeCatalog.java:177) at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeUpgrade(SchemaUpgradeHelper.java:174) at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.main(SchemaUpgradeHelper.java:234) 21:54:14,005 WARN [main] DBAccessorImpl:264 - Add FK constraint failed, constraintName = FK_hgc_blueprint_name, tableName = hostgroup_component, errorCode = 0, message = ERROR: there is no unique constraint matching given keys for referenced table "hostgroup" 21:54:14,026 INFO [main] DBAccessorImpl:410 - Executing query: ALTER TABLE blueprint_configuration ADD CONSTRAINT FK_cfg_blueprint_name FOREIGN KEY (blueprint_name) REFERENCES blueprint (blueprint_name) 21:54:14,397 INFO [main] SchemaUpgradeHelper:190 - Execution DML changes. 21:54:15,181 INFO [main] DBAccessorImpl:410 - Executing query: INSERT INTO ambari_sequences(sequence_name, "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 21:54:15,183 WARN [main] DBAccessorImpl:415 - Error executing query: INSERT INTO ambari_sequences(sequence_name, "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: 87 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:366) at org.apache.ambari.server.orm.DBAccessorImpl.executeQuery(DBAccessorImpl.java:413) at org.apache.ambari.server.orm.DBAccessorImpl.executeQuery(DBAccessorImpl.java:399) at org.apache.ambari.server.upgrade.UpgradeCatalog150.executeDMLUpdates(UpgradeCatalog150.java:415) at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeDMLUpdates(SchemaUpgradeHelper.java:195) at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.main(SchemaUpgradeHelper.java:238) 21:54:15,183 WARN [main] UpgradeCatalog150:421 - Sequence update threw exception. org.postgresql.util.PSQLException: ERROR: relation "clusters_cluster_id_seq" does not exist Position: 87 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:366) at org.apache.ambari.server.orm.DBAccessorImpl.executeQuery(DBAccessorImpl.java:413) at org.apache.ambari.server.orm.DBAccessorImpl.executeQuery(DBAccessorImpl.java:399) at org.apache.ambari.server.upgrade.UpgradeCatalog150.executeDMLUpdates(UpgradeCatalog150.java:415) at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeDMLUpdates(SchemaUpgradeHelper.java:195) at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.main(SchemaUpgradeHelper.java:238)