mfrancisc commented on issue #9057: URL: https://github.com/apache/devlake/issues/9057#issuecomment-5342913276
Thanks for the clear write-up. Indeed Jira’s changelog items array has no item id, and fields like Fix Version / Component / labels often appear twice in one history entry (add + remove). Since the Jira plugin upserts on `connection_id`, `changelog_id`, `field`, the second item overwrites the first one. Proposed fix: [#9062](https://github.com/apache/devlake/pull/9062) - add `item_index` to the tool-layer PK and to the domain changelog id. Index is a per-field ordinal derived from the item values, not array order. To test this fix, run a Jira pipeline once. The migration resets extract/convert state so existing `_raw_*` changelogs are re-extracted; A re-collect from Jira is not required, unless that raw data is gone. Collided rows that were already dropped cannot be repaired in place without that re-extract. -- 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]
