[AMBARI-18990] Auto-fix common issues found by the DB consistency checker

• Type: Task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.5.0
• Component/s: ambari-server
• Assignee: Dmitry Lysnichenko
• Reporter: Dmitry Lysnichenko
• Created: 25/Nov/16 15:52
• Updated: 09/Dec/16 14:53
• Resolved: 09/Dec/16 14:48

Description

Proposed auto-fixes
*Inconsistency for table hostcomponentdesiredstate and hostcomponentstate for stack upgrade.
*Deleted services cause config table inconsistent
*Primary key constrain issue from old Ambari version
*Schema name in postgres is not ambari
*Inconsistency view

1. If there are missing states (service, component, host), etc, then automatically add one with a value of UNKNOWN or INSTALLED.
2. If there are no selected configs, then select the latest ones (could be a bit dangerous)
3. If there are multiple selected configs for the same type, then unselect all but the most recent (could be a bit dangerous)

For dangerous options, by default fail with warning, and provide console option to perform fixes anyway (like the fsck does)

Issue Links

• links to: review_request_