Skip to content

Remove duplicate records to fix PG::CardinalityViolation on ingestion

Mehmet Emin INAC requested to merge 361181_fix_cardinality_error_on_conflict into master

What does this MR do and why?

It is possible to receive duplicate records from the security analyzers which is not possible to catch by JSON schema validation therefore we need to be a bit more conservative while UPSERTing the records into the database and remove the duplicate ones to prevent having errors.

Related to #361181 (closed).

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

Merge request reports