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