You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@devlake.apache.org by "Feggah (via GitHub)" <gi...@apache.org> on 2023/05/18 14:04:52 UTC

[GitHub] [incubator-devlake] Feggah opened a new issue, #5233: [Bug][PagerDuty] table board_issues is not being populated

Feggah opened a new issue, #5233:
URL: https://github.com/apache/incubator-devlake/issues/5233

   ### Search before asking
   
   - [X] I had searched in the [issues](https://github.com/apache/incubator-devlake/issues?q=is%3Aissue) and found no similar issues.
   
   
   ### What happened
   
   I configured GitHub DataSource to collect Deployments data and PagerDuty to collect Incidents. My use case is trying to collect DORA metrics.
   
   I selected all GitHub Repositories and PagerDuty Services that I wanted. After the Pipeline was successful, I opened the DORA dashboard to see if it worked.
   
   ![image](https://github.com/apache/incubator-devlake/assets/11353912/7455215e-4df8-4c50-b325-b3a8f3b77090)
   As you can see above, only Deployment data was successfully collected, and we can see data for DF and LTFC, but the CFR and MTTR are empty.
   
   I thought the collection of PagerDuty Incidents had failed, but by looking at the data in the MySQL database I can see that the table `issues` is populated:
   ![image](https://github.com/apache/incubator-devlake/assets/11353912/8ee0d0ca-4428-447c-af7d-1f41b4a3ef12)
   
   So I checked how the MTTR query was made, and the tables `issues`, `board_issues`, `boards` and `project_mapping`:
   ![image](https://github.com/apache/incubator-devlake/assets/11353912/720ea43e-9dab-4425-889a-795187169c28)
   
   All tables except `board_issues` have data:
   ![image](https://github.com/apache/incubator-devlake/assets/11353912/e5656ebc-8b98-4578-98f6-109a38225bc2)
   
   So my hypothesis is that the PagerDuty plugin is not populating correctly the `board_issues` table, thus causing the failure to JOIN tables and extract the values for Incidents data.
   
   
   ### What do you expect to happen
   
   See Incidents data in the DORA dashboard
   
   ### How to reproduce
   
   Use GitHub plugin to collect Deployments and PagerDuty to collect Incidents.
   
   The MTTR and CFR isn't going to be populated
   
   ### Anything else
   
   _No response_
   
   ### Version
   
   f3f6e9be22cc9eee450ab07d0314c2e3edb95d47
   
   ### Are you willing to submit PR?
   
   - [ ] Yes I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@devlake.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [incubator-devlake] Startrekzky commented on issue #5233: [Bug][PagerDuty] table board_issues is not being populated

Posted by "Startrekzky (via GitHub)" <gi...@apache.org>.
Startrekzky commented on issue #5233:
URL: https://github.com/apache/incubator-devlake/issues/5233#issuecomment-1553197328

   Hi @Feggah , thanks for reporting. We also found this bug and @keon94 was working on it.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@devlake.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [incubator-devlake] hezyin closed issue #5233: [Bug][PagerDuty] table board_issues is not being populated

Posted by "hezyin (via GitHub)" <gi...@apache.org>.
hezyin closed issue #5233: [Bug][PagerDuty] table board_issues is not being populated
URL: https://github.com/apache/incubator-devlake/issues/5233


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@devlake.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org