[AMBARI-24678] Config group mapping should allow multiple service instances

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 3.0.0
• Fix Version/s: 3.0.0
• Component/s: ambari-server
• Assignee: Balázs Bence Sári
• Reporter: Balázs Bence Sári
• Created: 24/Sep/18 16:52
• Updated: 26/Sep/18 18:05
• Resolved: 26/Sep/18 18:01

Description

Unique constraints in clusterconfig do not allow multiple service instances:

clusterconfig

CONSTRAINT UQ_config_type_tag UNIQUE (cluster_id, type_name, version_tag),
CONSTRAINT UQ_config_type_version UNIQUE (cluster_id, type_name, version));

Adding service_id would be trivial, but confgroupclusterconfigmapping references the first one in a foreign key:

confgroupclusterconfigmapping

CONSTRAINT FK_confg FOREIGN KEY (version_tag, config_type, cluster_id) REFERENCES clusterconfig (version_tag, type_name, cluster_id))

I think it should reference clusterconfig by its surrogate key (config_id).

Issue Links

• links to: pull request