DependencyTrack / DependencyTrack/dependency-track

ERROR: duplicate key value violates unique constraint "COMPONENTANALYSISCACHE_COMPOSITE_IDX"

Open
#800 0 comments 0 reactions 0 assignees View on GitHub
in triage
Dominant language
Java
Stars
4.2k
Forks
811
Avg merge
8h 39m
Merged PRs (30d)
237

Description

### Current Behavior:

I see the following in PostgreSQL logs:
> 2020-09-07 11:49:50.938 GMT [138677] ERROR: duplicate key value violates unique constraint "COMPONENTANALYSISCACHE_COMPOSITE_IDX"
2020-09-07 11:49:50.938 GMT [138677] DETAIL: Key ("CACHE_TYPE", "TARGET_HOST", "TARGET_TYPE", "TARGET")=(VULNERABILITY, https://ossindex.sonatype.org/api/v3/component-report, OSSINDEX, pkg:maven/acme.foo.bar/acmeinteg-schemagenerator@3.2-4.0-20200907.114228-377?type=jar) already exists.
2020-09-07 11:49:50.938 GMT [138677] STATEMENT: INSERT INTO "COMPONENTANALYSISCACHE" ("CACHE_TYPE","LAST_OCCURRENCE","TARGET","TARGET_HOST","TARGET_TYPE","UUID") VALUES ($1,$2,$3,$4,$5,$6)
RETURNING *

> 2020-10-07 12:09:56.396 GMT [47988] ERROR: duplicate key value violates unique constraint "COMPONENTANALYSISCACHE_COMPOSITE_IDX"
2020-10-07 12:09:56.396 GMT [47988] DETAIL: Key ("CACHE_TYPE", "TARGET_HOST", "TARGET_TYPE", "TARGET")=(VULNERABILITY, https://ossindex.sonatype.org/api/v3/component-report, OSSINDEX, pkg:maven/acme.foo.bar/acme-websocket@3.2-4.2-20201007.120204-69?type=jar) already exists.
2020-10-07 12:09:56.396 GMT [47988] STATEMENT: INSERT INTO "COMPONENTANALYSISCACHE" ("CACHE_TYPE","LAST_OCCURRENCE","TARGET","TARGET_HOST","TARGET_TYPE","UUID") VALUES ($1,$2,$3,$4,$5,$6)
RETURNING *

### Steps to Reproduce:
I don't know, just found those entries in PostgreSQL.

### Expected Behavior:
No key violation.

### Environment:

- Dependency-Track Version: 3.8.0
- Distribution: Docker containerd in Kubernetes
- BOM Format & Version: N/A
- Database Server: PostgreSQL
- Browser: N/A

### Additional Details:
N/A

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.