Balázs Bence Sári created AMBARI-24678: ------------------------------------------
Summary: Config group mapping should allow multiple service instances Key: AMBARI-24678 URL: https://issues.apache.org/jira/browse/AMBARI-24678 Project: Ambari Issue Type: Bug Components: ambari-server Affects Versions: 3.0.0 Reporter: Balázs Bence Sári Assignee: Balázs Bence Sári Unique constraints in {{clusterconfig}} do not allow multiple service instances: {noformat:title=clusterconfig} CONSTRAINT UQ_config_type_tag UNIQUE (cluster_id, type_name, version_tag), CONSTRAINT UQ_config_type_version UNIQUE (cluster_id, type_name, version)); {noformat} Adding {{service_id}} would be trivial, but {{confgroupclusterconfigmapping}} references the first one in a foreign key: {noformat:title=confgroupclusterconfigmapping} CONSTRAINT FK_confg FOREIGN KEY (version_tag, config_type, cluster_id) REFERENCES clusterconfig (version_tag, type_name, cluster_id)) {noformat} I think it should reference {{clusterconfig}} by its surrogate key ({{config_id}}). -- This message was sent by Atlassian JIRA (v7.6.3#76005)