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

Oracle DB table "AO_575BF5_DEV_SUMMARY" holds lot of unwanted data from Bamboo

      Issue Summary

      When Jira is installed with a supported Oracle database, Atlassian Jira - Development Integration Plugin, which manages Bamboo/Jira integration, populates the AO_575BF5_DEV_SUMMARY with build metadata of release versioning, Issue linked to builds. This can causes the table to grow huge in proportion to the number of release versioning and issue key linked with Bamboo.

      • This table has a column called JSON of type CLOB with a max limit of 2GB per tuple/entry
      • Most of this data is not needed for Jira

      This is reproducible on Data Center: yes

      Steps to Reproduce

      1. Install Jira (Any supported version)
      2. Install Oracle supported with the Jira version
      3. Setup the Jira and connect with Oracle DB
      4. Install and setup Bamboo
      5. Integrate Jira and Bamboo with Application Links
      6. Perform a number of actions that will update the Jira table AO_575BF5_DEV_SUMMARY
      7. Notice that the column JSON grows huge.
      8. Most of this data is not used in Jira. However, this makes the table grow more in size.

      Expected Results

      Retrieve only the information that is needed and insert these details into the table rather than the complete JSON output

      Actual Results

      Stores the details of all the deployments.

      {
         "value":{
            "targets":{
               "NPB-1":[
                  {
                     "type":{
                        "id":"build"
                     },
                     "objects":[
                        {
                           "lastUpdated":1658160341405,
                           "buildCount":5,
                           "planKey":"DEV-DTP",
                           "status":"SUCCESS"
                        },
                        {
                           "lastUpdated":1658161503143,
                           "buildCount":2,
                           "planKey":"DEV-PLAN2",
                           "status":"SUCCESS"
                        }
                     ]
                  },
                  {
                     "type":{
                        "id":"deployment-environment"
                     },
                     "objects":[
                        {
                           "projectUrl":"http://192.168.1.21:8085/deploy/viewDeploymentProjectEnvironments.action?id=1146881",
                           "project":"New Project B",
                           "id":1310721,
                           "position":0,
                           "title":"Deployement environment 1",
                           "projectId":1146881,
                           "url":"http://192.168.1.21:8085/deploy/viewEnvironment.action?id=1310721",
                           "status":"DEPLOYED"
                        },
                        {
                           "projectUrl":"http://192.168.1.21:8085/deploy/viewDeploymentProjectEnvironments.action?id=1146881",
                           "project":"New Project B",
                           "id":2654209,
                           "position":1,
                           "title":"Deployement environment 2",
                           "projectId":1146881,
                           "url":"http://192.168.1.21:8085/deploy/viewEnvironment.action?id=2654209",
                           "status":"DEPLOYED"
                        }
                     ]
                  }
               ]
            }
         },
         "expiry":9223371721494775807
      }
      

      Workaround

      Temporary Workaround

      The table AO_575BF5_DEV_SUMMARY is a cache table and can be truncated. This will clear the data.

      1. Stop Jira
      2. Truncate the table * AO_575BF5_DEV_SUMMARY*
      3. Start Jira
        However, the table grows back again as the issue are browsed.

      Only if the deployment environments and build are deleted from Bamboo will this workaround be helpful.

            [JSWSERVER-21407] Oracle DB table "AO_575BF5_DEV_SUMMARY" holds lot of unwanted data from Bamboo

            Marc Dacanay made changes -
            Labels Original: dob-pr rbst New: dob-pr rbst ril
            Marc Dacanay made changes -
            Remote Link New: This issue links to "Internal ticket (Web Link)" [ 956792 ]
            VICTOR-OSEGHALE (Inactive) made changes -
            Remote Link Original: This issue links to "Page (Confluence)" [ 667698 ]
            SET Analytics Bot made changes -
            UIS Original: 10 New: 7
            SET Analytics Bot made changes -
            Support reference count Original: 1 New: 2
            SET Analytics Bot made changes -
            UIS Original: 28 New: 10
            Marcin Sasinowski made changes -
            Status Original: Long Term Backlog [ 12073 ] New: Gathering Impact [ 12072 ]
            SET Analytics Bot made changes -
            UIS Original: 27 New: 28
            SET Analytics Bot made changes -
            UIS Original: 28 New: 27
            SET Analytics Bot made changes -
            UIS Original: 27 New: 28

              Unassigned Unassigned
              f956e0e022e9 skavatekar
              Affected customers:
              6 This affects my team
              Watchers:
              9 Start watching this issue

                Created:
                Updated: