[jira] [Created] (AMBARI-24678) Config group mapping should allow multiple service instances

["Balázs Bence Sári (JIRA)" <ji...@apache.org>]

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)