Development panel shows incorrect Bamboo build or deployment summary
プラットフォームについて: Server および Data Center のみ。この記事は、Server および Data Center プラットフォームのアトラシアン製品にのみ適用されます。
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Fisheye および Crucible は除く
問題
When viewing the development panel, the status summary of builds or deployments appears outdated. For example, we may see "1 build failed" even if the build details show all successful builds.
診断
Diagnostic Steps
You can confirm whether the Development Panel for a given issue – such as Jira-123 – is affected with a SQL query run in your Jira database. The following example is written for PostgreSQL:
select d."JSON"
from propertyentry a
join propertystring b on a.id=b.id
join "AO_575BF5_DEV_SUMMARY" d
on SUBSTR(a.property_key,16,36) = d."PROVIDER_SOURCE_ID"
join jiraissue i on d."ISSUE_ID" = i.id
join project p on p.id = i.project
where b.propertyvalue like '%bamboo'
and p.pkey = 'Jira' -- replace with the jira project key
and i.issuenum = 123; -- replace with the jira issue numberThe result will show output like the following (formatted for readability) :
{
"value": {
"targets": {
"Jira-123": [
{
"type": {
"id": "build"
},
"objects": [
{
"lastUpdated": 1568392329550,
"buildCount": 2,
"planKey": "TEST-TEST",
"status": "SUCCESS"
}
]
},
{
"type": {
"id": "deployment-environment"
},
"objects": [
{
"projectUrl": "https://my.bamboo.url/deploy/viewDeploymentProjectEnvironments.action?id=1343489",
"project": "TEST",
"id": 1474561,
"position": 0,
"title": "dev",
"projectId": 1343489,
"url": "https://my.bamboo.url/deploy/viewEnvironment.action?id=1474561",
"status": "NOT_DEPLOYED"
},
{
"projectUrl": "https://my.bamboo.url/deploy/viewDeploymentProjectEnvironments.action?id=1343489",
"project": "TEST",
"id": 1474562,
"position": 1,
"title": "qa",
"projectId": 1343489,
"url": "https://my.bamboo.url/deploy/viewEnvironment.action?id=1474562",
"status": "DEPLOYED"
}
]
}
]
}
},
"expiry": 9223371721494776000
}If this detail does not match what is in Bamboo and the open development panel details, please read on.
原因
The root cause of the issue is not known, but the database entries that store the development panel details may not always get successfully repopulated, leading to this outdated data.
回避策
As a workaround, please:
データベースの変更を行う場合は必ず事前にバックアップを取得してください。可能な場合は、まずステージング サーバーで SQL コマンドの変更、挿入、更新、または削除を行うようにします。
Run the following query to retrieve the "ID" to delete
select d."ID" from propertyentry a join propertystring b on a.id=b.id join "AO_575BF5_DEV_SUMMARY" d on SUBSTR(a.property_key,16,36) = d."PROVIDER_SOURCE_ID" join jiraissue i on d."ISSUE_ID" = i.id join project p on p.id = i.project where b.propertyvalue like '%bamboo' and p.key = 'Jira' -- replace with your jira issue key and i.issuenum = 123; -- replace with your jira issue numberDelete the row returned by the query above
DELETE from "AO_575BF5_DEV_SUMMARY" where "ID" = [the id from step 1];Refresh the Jira issue between 10 and 20 minutes after the row was deleted, so Jira will request new information from Bamboo
To verify whether the change took effect, please run the Diagnosis query again, and compare the result to Bamboo.