[AMBARI-16030] Ambari operation history: Add ambari_operation_history table for record keeping history of ambari versions and operations

• Type: Task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 2.4.0
• Fix Version/s: 3.0.0
• Component/s: ambari-server
• Assignee: Unassigned
• Reporter: Nahappan Somasundaram
• Created: 22/Apr/16 00:44
• Updated: 31/Dec/22 01:23

Description

When investigating upgrade issues, information about history about Ambari versions is missing. Also information about when the Ambari upgrades actually happened in the past is completely missing.

Instead of relying on this information to be provided, Ambari should record Ambari upgrade history in Ambari DB.

ambari_version_history
Version                    Date                                    Notes
2.2.2.0-1            02/09/2015 01:00:00                Clean Install
2.2.3.0-2            03/10/2015 01:00:00                Upgraded 2.2.2.0-1 -> 2.2.3.0-2
2.4.0.0-3            06/09/2015 01:00:00                Upgraded 2.2.3.0-2 -> 2.4.0.0-3

Issue Links

• relates to: AMBARI-16240 Ambari operation history: Syntax error in Ambari-DDL-Postgres-CREATE.sql causes ambari-server setup to fail in 2.4.0.0-489
• relates to: AMBARI-16029 Ambari version history: Create DB table, constraints and sequence id.