[AMBARI-21169] Service and Patch Upgrade Catalog Changes for 2.6.0

• Type: Task
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 2.6.0
• Fix Version/s: 2.6.0
• Component/s: ambari-upgrade
• Epic Link: Ambari: Patch Upgrades
• Assignee: Dmitry Lysnichenko
• Reporter: Jonathan Hurley
• Created: 01/Jun/17 13:44
• Updated: 10/Aug/17 16:12
• Resolved: 10/Aug/17 16:12

Description

Implement the following upgrade catalog changes related to service/patch upgrades:

servicecomponentdesiredstate

• Remove: desired_stack_id BIGINT NOT NULL
• Remove: desired_version VARCHAR(255) NOT NULL DEFAULT 'UNKNOWN'
• Remove: FK on desired_stack_id (FK_scds_desired_stack_id)
• Add: desired_repo_version_id BIGINT NOT NULL
• Add: FK to repo_version_id (FK_scds_desired_repo_id)

hostcomponentdesiredstate

• Remove: desired_stack_id BIGINT NOT NULL
• Remove: FK on desired_stack_id (FK_hcds_desired_stack_id)

hostcomponentstate

• Remove: current_stack_id BIGINT NOT NULL
• Remove: FK on desired_stack_id (FK_hcs_current_stack_id)

servicedesiredstate

• Remove: desired_stack_id BIGINT NOT NULL
• Add: desired_repo_version_id BIGINT NOT NULL
• Add: FK to repo_version_id (FK_repo_version_id)

host_version

• Change the UNIQUE constraint to allow for multiple CURRENT repositories per host. Restriction should also include the repo_version_id for uniqueness now.

cluster_version

• This table was removed.

servicecomponent_version

• Create this table and populate with data

upgrade

• Add orchestration VARCHAR(255) NOT NULL DEFAULT 'STANDARD'

Issue Links

• is cloned by: AMBARI-21683 Service and Patch Upgrade Catalog Changes for 3.0
• links to: review_request_