[PHOENIX-6645] Remove unneccessary SCN related properties from SYSTEM tables on upgrade

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 5.2.0
• Fix Version/s: 4.17.0, 5.2.0, 4.16.2, 5.1.3
• Component/s: core

Release Note

The KEEP_DELETED_CELLS property is removed, and the VERSIONS property is set to 1 for the SYSTEM.STATS and SYSTEM.LOG tables on upgrade now.

• Assignee: Istvan Toth
• Reporter: Istvan Toth
• Created: 07/Feb/22 05:57
• Updated: 24/Feb/22 16:38
• Resolved: 24/Feb/22 16:00

Description

Before PHOENIX-4575, we used to create all SYSTEM tables with the KEEP_DELETED_CELLS and VERSIONS attribute set.
PHOENIX-4575 removes this flags from tables where it doesn't make sense, SYSTEM.STATS and SYSTEM.LOG, but this is not done automatically when upgrading. 

Having KEEP_DELETED_CELLS and VERSIONS set on SYSTEM.STATS is a major performance problem, so we should fix the table properties on upgrade.

Issue Links

• is related to: PHOENIX-4575 Phoenix metadata KEEP_DELETED_CELLS and VERSIONS should be property driven
• links to: GitHub Pull Request #1396