Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-6645

Remove unneccessary SCN related properties from SYSTEM tables on upgrade

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Minor
    • Resolution: Fixed
    • 5.2.0
    • 4.17.0, 5.2.0, 4.16.2, 5.1.3
    • core
    • None
    • Hide
      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.
      Show
      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.

    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.

      Attachments

        Issue Links

          is related to

          New Feature - A new feature of the product, which has yet to be developed. PHOENIX-4575 Phoenix metadata KEEP_DELETED_CELLS and VERSIONS should be property driven

          • Major - Major loss of function.
          • Resolved
          links to

          Web Link GitHub Pull Request #1396

          Activity

            People

              stoty Istvan Toth
              stoty Istvan Toth
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: