-
Bug
-
Resolution: Unresolved
-
Medium (View bug fix roadmap)
-
None
-
9.0.0, 8.20.9
-
8.2
-
2
-
Severity 1 - Critical
-
7
-
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
- Install Jira (Any supported version)
- Install Oracle supported with the Jira version
- Setup the Jira and connect with Oracle DB
- Install and setup Bamboo
- Integrate Jira and Bamboo with Application Links
- Perform a number of actions that will update the Jira table AO_575BF5_DEV_SUMMARY
- Notice that the column JSON grows huge.
- 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
The table AO_575BF5_DEV_SUMMARY is a cache table and can be truncated. This will clear the data.
- Stop Jira
- Truncate the table * AO_575BF5_DEV_SUMMARY*
- 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.
- links to
[JSWSERVER-21407] Oracle DB table "AO_575BF5_DEV_SUMMARY" holds lot of unwanted data from Bamboo
Labels | Original: dob-pr rbst | New: dob-pr rbst ril |
Remote Link | New: This issue links to "Internal ticket (Web Link)" [ 956792 ] |
Remote Link | Original: This issue links to "Page (Confluence)" [ 667698 ] |
UIS | Original: 10 | New: 7 |
Support reference count | Original: 1 | New: 2 |
UIS | Original: 28 | New: 10 |
Status | Original: Long Term Backlog [ 12073 ] | New: Gathering Impact [ 12072 ] |
UIS | Original: 27 | New: 28 |
UIS | Original: 28 | New: 27 |
UIS | Original: 27 | New: 28 |