DependencyTrack / DependencyTrack/dependency-track
ERROR: duplicate key value violates unique constraint "COMPONENTANALYSISCACHE_COMPOSITE_IDX"
- 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
Assessment
This issue has not been assessed yet.