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

Clean up for non-existence issue_id in AO_60DB71_ISSUERANKING table

    XMLWordPrintable

Details

    • Bug
    • Resolution: Not a bug
    • Low
    • None
    • 6.3.2.1
    • None

    Description

      When you run the following SQL it will return some issue IDs that are ranked by GH but that do not exist in Jira.

      select count(*) from "AO_60DB71_ISSUERANKING" 
      LEFT JOIN jiraissue ON "ISSUE_ID"=jiraissue.id
      where 
      ("ISSUE_ID" >0) AND jiraissue.id IS NULL

      This potentially create some confusion among customers as it looks like there is some inconsistency in the ranking table. Ideally, JA should have a cleaning service to periodically cleanup those non-existing issue id rows.

      Note that there is NO functionality broken, this is just how the current issueranking table works.

      Attachments

        1. gh-ranking.png
          21 kB
          Sorin Sbarnea

        Issue Links

          Activity

            People

              Unassigned Unassigned
              vkharisma vkharisma (Inactive)
              Votes:
              2 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: