Uploaded image for project: 'Jira Software Data Center'
  1. Jira Software Data Center
  2. JSWSERVER-25929

Better scaling for "AO_E8B6CC_MESSAGE_TAG" table

XMLWordPrintable

      Problem Definition:

      At the moment, the limit for this table "ID" column is 2147483647 due to its INT data type. But, due to the amount of operation that will create a new row into the table, the bigger the Repositories that are connected through DVCS the ID will soon reach its limit and the effect of this will be the DVCS Sync to be not possible.

      Suggested Solution:

      Several suggestions that I could provide is to:

      1. Change the Column ID Data Type to BIGINT to hold a bigger amount of Rows.
      2. There is a cleaning job that will remove older rows so it could be used again.

            [JSWSERVER-25929] Better scaling for "AO_E8B6CC_MESSAGE_TAG" table

            Puneet Saini made changes -
            Remote Link New: This issue links to "Page (Confluence)" [ 982546 ]
            Renata Dornelas made changes -
            Remote Link Original: This issue links to "Page (Atlassian Documentation)" [ 961958 ]
            Jira Server Release Automation Bot[ADM-107524] made changes -
            Resolution New: Fixed [ 1 ]
            Status Original: Waiting for Release [ 12075 ] New: Closed [ 6 ]
            SET Analytics Bot made changes -
            UIS Original: 2 New: 1
            SET Analytics Bot made changes -
            UIS Original: 1 New: 2
            Patrick Turbett made changes -
            Remote Link New: This issue links to "Page (Atlassian Documentation)" [ 961958 ]
            Rob made changes -
            Remote Link Original: This issue links to "Page (Confluence)" [ 956882 ]
            Sandip Shrivastava made changes -
            Remote Link New: This issue links to "Page (Confluence)" [ 957914 ]
            Rob made changes -
            Remote Link New: This issue links to "Page (Confluence)" [ 956882 ]
            Benjamin Suess made changes -
            Fix Version/s New: 10.2.0 [ 108819 ]

              c8bcca445054 Benjamin Suess
              jrahmadiputra Julian (Inactive)
              Affected customers:
              16 This affects my team
              Watchers:
              19 Start watching this issue

                Created:
                Updated:
                Resolved: