You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ambari.apache.org by "Siddharth Wagle (JIRA)" <ji...@apache.org> on 2014/03/26 23:58:15 UTC
[jira] [Resolved] (AMBARI-5232) Warnings/exceptions when updating
DB (1.4.1->current trunk)
[ https://issues.apache.org/jira/browse/AMBARI-5232?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Siddharth Wagle resolved AMBARI-5232.
-------------------------------------
Resolution: Fixed
Committed to 1.5.0 and trunk.
> Warnings/exceptions when updating DB (1.4.1->current trunk)
> -----------------------------------------------------------
>
> Key: AMBARI-5232
> URL: https://issues.apache.org/jira/browse/AMBARI-5232
> Project: Ambari
> Issue Type: Bug
> Components: controller
> Affects Versions: 1.5.0
> Reporter: Siddharth Wagle
> Assignee: Siddharth Wagle
> Fix For: 1.5.0
>
>
> 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
> {code}
> 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)
> {code}
--
This message was sent by Atlassian JIRA
(v6.2#6252)