Siddharth Wagle created AMBARI-5232:
---------------------------------------
Summary: 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)
