github-actions[bot] commented on issue #13399: URL: https://github.com/apache/cloudstack/issues/13399#issuecomment-5356775126
## ๐ฏ Triage report Usage Server repeatedly reprocesses historical usage intervals and inserts duplicate `cloud_usage` rows due to a unique-key/constraint-violation loop, affecting `usage_type=1` (VM usage) on 4.22.1.0. This is a well-documented variant of #13112. Root cause has since been identified in the comment thread (a defect introduced by #11531 around `createVolumeHelperEvent` handling), and a fix PR (#13909, with supporting DB migration issues #13905/#13906) is already up. ### ๐ Assessment | Dimension | Value | Reasoning | |---|---|---| | **Type** | type:bug | Reproducible defect causing data corruption in usage accounting | | **Component** | component:usage-server | Issue is entirely within Usage Server processing/DB schema | | **Severity** | Severity:Major | Corrupts billing data and requires disabling the Usage Server as a workaround, but is not a full outage | | **Labels** | type:bug, component:usage-server, Severity:Major | See above | | **Coding agent** | Not suitable | Root cause analysis and fix are already in progress by a human contributor with PR #13909 open | ### ๐ Similar issues - https://github.com/apache/cloudstack/issues/13112 โ related, same duplicate-usage-record symptom for a different `usage_type`, referenced directly in this issue <details><summary>๐ก Notes and suggestions</summary> The issue thread already contains a thorough root-cause analysis (constraint violation on `cloud_usage`/`usage_event` due to a non-idempotent volume-create usage event) and a fix is in review via PR #13909. Maintainers should track this issue against that PR and close both #13905/#13906 as resolved once #13909 merges. No further action needed from triage beyond linking. </details> > Generated by [Daily Issue Triage](https://github.com/apache/cloudstack/actions/runs/32375697891) ยท sonnet50 224.8K ยท [โท](https://github.com/search?q=repo%3Aapache%2Fcloudstack+%22gh-aw-workflow-call-id%3A+apache%2Fcloudstack%2Fdaily-issue-triage%22&type=issues) > <details> <summary>Add this agentic workflows to your repo</summary> To install this agentic workflow, run ``` gh aw add githubnext/agentics/workflows/daily-issue-triage.md@d7c1dc4b72b00607a67caaffdcc216cb64379cf9 ``` </details> <!-- gh-aw-agentic-workflow: Daily Issue Triage, engine: copilot, version: 1.0.52, model: claude-sonnet-5, id: 32375697891, workflow_id: daily-issue-triage, run: https://github.com/apache/cloudstack/actions/runs/32375697891 --> <!-- gh-aw-workflow-call-id: apache/cloudstack/daily-issue-triage --> -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
