Uploaded image for project: 'Bitbucket Data Center'
  1. Bitbucket Data Center
  2. BSERV-3052

Stop duplicate rows in cs_indexer_state

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Low
    • 2.1.2
    • None
    • None
    • None

    Description

      The cs_indexer_state table (which represents InternalChangesetIndexerState) does not have a uniqueness constraint on its primary key.

      Customers have reported duplicate rows in the table, which causes issues with deleting repositories.

      1. Write a liquibase patch to delete duplicate rows in cs_indexer_state
        • Must be run before adding the uniqueness constraint!
        • Ideally the liquibase patch should first find all duplicate rows, then delete them and reconstruct 1 row for each set of duplicates.
      2. Write liquibase patch to add a constraint for unique primary key
      3. Track down the cause of duplicate rows

      Attachments

        Activity

          People

            mstudman Michael Studman (Inactive)
            bplump Brent P
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: