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

Details

    • Bug
    • Resolution: Unresolved
    • Low
    • None
    • 8.4.3, 7.13.9, 8.5.9, 8.15.0, 8.22.6, 9.15.2
    • DVCS Connector

    Description

      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.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              jrahmadiputra Julian (Inactive)
              Votes:
              14 Vote for this issue
              Watchers:
              16 Start watching this issue

              Dates

                Created:
                Updated: