[RTFACT-20065] Artifactory should have unique constraint by type and path before saving xray events Created: 05/Sep/19  Updated: 03/Nov/19  Resolved: 30/Oct/19

Status: Resolved
Project: Artifactory Binary Repository
Component/s: None
Affects Version/s: None
Fix Version/s: 6.14.0

Type: Improvement Priority: High
Reporter: Shai Ben-Zvi Assignee: Rotem Kfir
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Assigned QA: Andrey Tashlitsky
Sprint: Pam - Quality 5


Currently, Artifactory saves every Xray event inside the tasks table including duplicated events.
For example, a common scenario is that a customer willl do re-index inside Xray on a certain repository in order to attempt re-indexing of unindexed artifacts, however, this will send events on already indexed artifacts or, in case there are already events for the same artifacts in tasks table, it will insert them as well, resulting with duplicated events on the same artifacts that Artifactory will have to process.

This improvement is to have a unique constraint by package type and component path, so in case there is already an event on the same component path and type is also the same, it should not insert duplicated events.

Generated at Wed Apr 08 09:39:08 UTC 2020 using Jira 8.5.3#805003-sha1:b4933e02eaff29a49114274fe59e1f99d9d963d7.