Development panel shows incorrect Bamboo build or deployment summary

お困りですか?

アトラシアン コミュニティをご利用ください。

コミュニティに質問

プラットフォームについて: サーバーと Data Center のみ。この記事は、サーバーおよび Data Center プラットフォームのアトラシアン製品にのみ適用されます。

問題

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.

診断

診断ステップ

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.key = 'Jira' -- replace with the jira project key
  and i.issuenum = 123; -- replace with the jira issue number

The 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 コマンドの変更、挿入、更新、または削除を行うようにします。

  1. 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 number
  2. Delete the row returned by the query above

    DELETE from "AO_575BF5_DEV_SUMMARY" where "ID" = [the id from step 1];
  3. 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.

説明

Jira Development panel Build or Deployment summary shows outdated information

製品Jira、Bamboo
最終更新日 2020 年 11 月 23 日

この内容はお役に立ちましたか?

はい
いいえ
この記事についてのフィードバックを送信する
Powered by Confluence and Scroll Viewport.