DB Deadlock on Artifact deletion

When trying to delete a artifact the following error occured: 

- k8s-tools
- two artifacts with https://gitlab.opencode.de/open-code/oci/k8s-tools/-/blob/main/sbom.amd64.json & https://gitlab.opencode.de/open-code/oci/k8s-tools/-/blob/main/sbom.minimal.amd64.json

```
2:14PM INF middlewares/logging_middleware.go:19 handled request method=DELETE url=/api/v1/organizations/@opencode/projects/opencode-shared-container-images/assets/k8s-tools/refs/main/artifacts/pkg%3Aoci%2Fk8s-tools%3Frepository_url%3Dregistry.opencode.de%2Fopen-code%2Foci%2Fk8s-tools%26arch%3Damd64%26tag%3Dmain-amd64/ status=200 duration=3m56.747642605s
2:14PM ERR monitoring/alert.go:33 critical error encountered msg="Database error" error="ERROR: insert or update on table \"artifact_risk_history\" violates foreign key constraint \"fk_artifact\" (SQLSTATE 23503)" id=204eae89aaa64a7087f5e791a60d93f4
2:14PM ERR monitoring/alert.go:33 critical error encountered msg="Database error" error="ERROR: insert or update on table \"artifact_risk_history\" violates foreign key constraint \"fk_artifact\" (SQLSTATE 23503)" id=9017866528d2493283e0257c9eba415d
2:14PM ERR controllers/scan_controller.go:328 could not recalculate risk history err="ERROR: insert or update on table \"artifact_risk_history\" violates foreign key constraint \"fk_artifact\" (SQLSTATE 23503)"
2:14PM ERR controllers/scan_controller.go:328 could not recalculate risk history err="ERROR: insert or update on table \"artifact_risk_history\" violates foreign key constraint \"fk_artifact\" (SQLSTATE 23503)"
2:14PM ERR monitoring/alert.go:33 critical error encountered msg="Database error" error="ERROR: deadlock detected (SQLSTATE 40P01)" id=4566b41cf6cd47cb92cd3759acda0026
2:14PM ERR repositories/asset_version_repository.go:69 error when deleting asset version in database err="ERROR: deadlock detected (SQLSTATE 40P01)" assetVersion=main
2:14PM INF ERROR error when trying to call delete function in assetVersionRepository err="ERROR: deadlock detected (SQLSTATE 40P01)"
2:14PM ERR middlewares/server.go:41 ERROR: deadlock detected (SQLSTATE 40P01) method=DELETE path=/api/v1/organizations/@opencode/projects/opencode-shared-container-images/assets/k8s-tools/refs/main/
2:14PM ERR monitoring/alert.go:33 critical error encountered msg="Database error" error="ERROR: deadlock detected (SQLSTATE 40P01)" id=ef1ba244dbc448c8a93ecc7b33449b3e
2:14PM ERR repositories/asset_version_repository.go:69 error when deleting asset version in database err="ERROR: deadlock detected (SQLSTATE 40P01)" assetVersion=main
2:14PM INF ERROR error when trying to call delete function in assetVersionRepository err="ERROR: deadlock detected (SQLSTATE 40P01)"
2:14PM ERR middlewares/server.go:41 ERROR: deadlock detected (SQLSTATE 40P01) method=DELETE path=/api/v1/organizations/@opencode/projects/opencode-shared-container-images/assets/k8s-tools/refs/main/
2:14PM ERR monitoring/alert.go:33 critical error encountered msg="Database error" error="ERROR: deadlock detected (SQLSTATE 40P01)" id=6e32c9be0a504985917e16605684bf58
2:14PM ERR monitoring/alert.go:33 critical error encountered msg="Database error" error="ERROR: current transaction is aborted, commands ignored until end of transaction block (SQLSTATE 25P02)" id=34fe26b99e714e3cbdef365d60d36937
2:14PM ERR monitoring/alert.go:33 critical error encountered msg="Database error" error="ERROR: current transaction is aborted, commands ignored until end of transaction block (SQLSTATE 25P02)" id=4623fdc1e9ab4408a47d69683322b853
2:14PM ERR monitoring/alert.go:33 critical error encountered msg="Database error" error="ERROR: current transaction is aborted, commands ignored until end of transaction block (SQLSTATE 25P02)" id=7038843881834e3fb476f68358c21b67
2:14PM ERR monitoring/alert.go:33 critical error encountered msg="Database error" error="ERROR: current transaction is aborted, commands ignored until end of transaction block (SQLSTATE 25P02)" id=badf6467e3124744b0ef2140c31e0434
2:14PM ERR monitoring/alert.go:33 critical error encountered msg="Database error" error="ERROR: current transaction is aborted, commands ignored until end of transaction block (SQLSTATE 25P02)" id=517f5a6d1ca8478980d0607c2289cb08
2:14PM ERR services/scan_service.go:466 error when trying to add events for removing scanner from vulnerability
2:14PM ERR services/scan_service.go:120 could not handle scan result err="ERROR: current transaction is aborted, commands ignored until end of transaction block (SQLSTATE 25P02)"
2:14PM ERR controllers/artifact_controller.go:352 could not scan sbom after updating it err="ERROR: current transaction is aborted, commands ignored until end of transaction block (SQLSTATE 25P02)"
2:14PM ERR middlewares/server.go:41 code=500, message=could not scan sbom after updating it, internal=ERROR: current transaction is aborted, commands ignored until end of transaction block (SQLSTATE 25P02) method=PUT path=/api/v1/organizations/@opencode/projects/opencode-shared-container-images/assets/k8s-tools/refs/main/artifacts/pkg%3Aoci%2Fk8s-tools%3Frepository_url%3Dregistry.opencode.de%2Fopen-code%2Foci%2Fk8s-tools%26arch%3Damd64%26tag%3Dmain-minimal-amd64/
2:14PM ERR monitoring/alert.go:33 critical error encountered msg="Database error" error="ERROR: deadlock detected (SQLSTATE 40P01)" id=8d9e556a86e3471b83b03a4ba9c71eaf
2:14PM ERR repositories/asset_version_repository.go:69 error when deleting asset version in database err="ERROR: deadlock detected (SQLSTATE 40P01)" assetVersion=main
2:14PM INF ERROR error when trying to call delete function in assetVersionRepository err="ERROR: deadlock detected (SQLSTATE 40P01)"
```

```
2026-03-06 14:10:01.553 UTC [400821] LOG:  checkpoint starting: time
2026-03-06 14:11:06.728 UTC [400821] LOG:  checkpoint complete: wrote 192 buffers (1.2%); 0 WAL file(s) added, 0 removed, 18 recycled; write=64.676 s, sync=0.103 s, total=65.175 s; sync files=76, longest=0.024 s, average=0.002 s; distance=307662 kB, estimate=503992 kB; lsn=238/96A6600, redo lsn=238/8E97D98
2026-03-06 14:14:30.934 UTC [552503] ERROR:  insert or update on table "artifact_risk_history" violates foreign key constraint "fk_artifact"
2026-03-06 14:14:30.934 UTC [552503] DETAIL:  Key (artifact_name, asset_version_name, asset_id)=(pkg:oci/k8s-tools?repository_url=registry.opencode.de/open-code/oci/k8s-tools&arch=amd64&tag=main-amd64, main, 89572d05-e005-4dc5-a308-1c076440f59e) is not present in table "artifacts".
2026-03-06 14:14:30.934 UTC [552503] STATEMENT:  INSERT INTO "artifact_risk_history" ("low","high","medium","critical","low_cvss","medium_cvss","high_cvss","critical_cvss","cve_purl_low","cve_purl_medium","cve_purl_high","cve_purl_critical","cve_purl_low_cvss","cve_purl_medium_cvss","cve_purl_high_cvss","cve_purl_critical_cvss","day","sum_open_risk","avg_open_risk","max_open_risk","min_open_risk","sum_closed_risk","avg_closed_risk","max_closed_risk","min_closed_risk","open_dependency_vulns","fixed_dependency_vulns","artifact_name","asset_version_name","asset_id") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30) ON CONFLICT ("day","artifact_name","asset_version_name","asset_id") DO UPDATE SET "low"="excluded"."low","high"="excluded"."high","medium"="excluded"."medium","critical"="excluded"."critical","low_cvss"="excluded"."low_cvss","medium_cvss"="excluded"."medium_cvss","high_cvss"="excluded"."high_cvss","critical_cvss"="excluded"."critical_cvss","cve_purl_low"="excluded"."cve_purl_low","cve_purl_medium"="excluded"."cve_purl_medium","cve_purl_high"="excluded"."cve_purl_high","cve_purl_critical"="excluded"."cve_purl_critical","cve_purl_low_cvss"="excluded"."cve_purl_low_cvss","cve_purl_medium_cvss"="excluded"."cve_purl_medium_cvss","cve_purl_high_cvss"="excluded"."cve_purl_high_cvss","cve_purl_critical_cvss"="excluded"."cve_purl_critical_cvss","sum_open_risk"="excluded"."sum_open_risk","avg_open_risk"="excluded"."avg_open_risk","max_open_risk"="excluded"."max_open_risk","min_open_risk"="excluded"."min_open_risk","sum_closed_risk"="excluded"."sum_closed_risk","avg_closed_risk"="excluded"."avg_closed_risk","max_closed_risk"="excluded"."max_closed_risk","min_closed_risk"="excluded"."min_closed_risk","open_dependency_vulns"="excluded"."open_dependency_vulns","fixed_dependency_vulns"="excluded"."fixed_dependency_vulns"
2026-03-06 14:14:30.934 UTC [552501] ERROR:  insert or update on table "artifact_risk_history" violates foreign key constraint "fk_artifact"
2026-03-06 14:14:30.934 UTC [552501] DETAIL:  Key (artifact_name, asset_version_name, asset_id)=(pkg:oci/k8s-tools?repository_url=registry.opencode.de/open-code/oci/k8s-tools&arch=amd64&tag=main-amd64, main, 89572d05-e005-4dc5-a308-1c076440f59e) is not present in table "artifacts".
2026-03-06 14:14:30.934 UTC [552501] STATEMENT:  INSERT INTO "artifact_risk_history" ("low","high","medium","critical","low_cvss","medium_cvss","high_cvss","critical_cvss","cve_purl_low","cve_purl_medium","cve_purl_high","cve_purl_critical","cve_purl_low_cvss","cve_purl_medium_cvss","cve_purl_high_cvss","cve_purl_critical_cvss","day","sum_open_risk","avg_open_risk","max_open_risk","min_open_risk","sum_closed_risk","avg_closed_risk","max_closed_risk","min_closed_risk","open_dependency_vulns","fixed_dependency_vulns","artifact_name","asset_version_name","asset_id") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30) ON CONFLICT ("day","artifact_name","asset_version_name","asset_id") DO UPDATE SET "low"="excluded"."low","high"="excluded"."high","medium"="excluded"."medium","critical"="excluded"."critical","low_cvss"="excluded"."low_cvss","medium_cvss"="excluded"."medium_cvss","high_cvss"="excluded"."high_cvss","critical_cvss"="excluded"."critical_cvss","cve_purl_low"="excluded"."cve_purl_low","cve_purl_medium"="excluded"."cve_purl_medium","cve_purl_high"="excluded"."cve_purl_high","cve_purl_critical"="excluded"."cve_purl_critical","cve_purl_low_cvss"="excluded"."cve_purl_low_cvss","cve_purl_medium_cvss"="excluded"."cve_purl_medium_cvss","cve_purl_high_cvss"="excluded"."cve_purl_high_cvss","cve_purl_critical_cvss"="excluded"."cve_purl_critical_cvss","sum_open_risk"="excluded"."sum_open_risk","avg_open_risk"="excluded"."avg_open_risk","max_open_risk"="excluded"."max_open_risk","min_open_risk"="excluded"."min_open_risk","sum_closed_risk"="excluded"."sum_closed_risk","avg_closed_risk"="excluded"."avg_closed_risk","max_closed_risk"="excluded"."max_closed_risk","min_closed_risk"="excluded"."min_closed_risk","open_dependency_vulns"="excluded"."open_dependency_vulns","fixed_dependency_vulns"="excluded"."fixed_dependency_vulns"
2026-03-06 14:14:31.907 UTC [552552] ERROR:  deadlock detected
2026-03-06 14:14:31.907 UTC [552552] DETAIL:  Process 552552 waits for ShareLock on transaction 71446281; blocked by process 554478.
	Process 554478 waits for ShareLock on transaction 71446268; blocked by process 556376.
	Process 556376 waits for AccessShareLock on tuple (14,20) of relation 16473 of database 16384; blocked by process 552552.
	Process 552552: DELETE FROM "asset_versions" WHERE ("asset_versions"."name","asset_versions"."asset_id") IN (($1,$2))
	Process 554478: DELETE FROM "asset_versions" WHERE ("asset_versions"."name","asset_versions"."asset_id") IN (($1,$2))
	Process 556376: INSERT INTO "dependency_vulns" ("id","asset_version_name","asset_id","message","state","manual_ticket_creation","created_at","updated_at","cve_id","component_purl","risk_recalculated_at","ticket_id","ticket_url","component_fixed_version","vulnerability_path","raw_risk_assessment","last_detected") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,DEFAULT,DEFAULT,$12,$13,$14,$15),($16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,DEFAULT,$29,$30,$31),($32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,DEFAULT,DEFAULT,$43,$44,$45,$46),($47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,DEFAULT,DEFAULT,$58,$59,$60,$61),($62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,DEFAULT,DEFAULT,$73,$74,$75,$76),($77,$78,$79,$80,$81,$82,$83,$84,$85,$86,$87,DEFAULT,DEFAULT,$88,$89,$90,$91),($92,$93,$94,$95,$96,$97,$98,$99,$100,$101,$102,DEFAULT,DEFAULT,DEFAULT,$103,$104,$105),($106,$107,$108,$109,$110,$111,$112,$113,$114,$115,$116,$117,$118,DEFAULT,$119,$120,$121),($122,$123,$124,$125,$126,$127,$128,$129,$130,$131,$132,DEFAULT,DEFAULT,DEFAULT,$133,
2026-03-06 14:14:31.907 UTC [552552] HINT:  See server log for query details.
2026-03-06 14:14:31.907 UTC [552552] CONTEXT:  while deleting tuple (14,20) in relation "asset_versions"
2026-03-06 14:14:31.907 UTC [552552] STATEMENT:  DELETE FROM "asset_versions" WHERE ("asset_versions"."name","asset_versions"."asset_id") IN (($1,$2))
2026-03-06 14:14:32.054 UTC [554478] ERROR:  deadlock detected
2026-03-06 14:14:32.054 UTC [554478] DETAIL:  Process 554478 waits for ShareLock on transaction 71446268; blocked by process 556376.
	Process 556376 waits for AccessShareLock on tuple (14,20) of relation 16473 of database 16384; blocked by process 552507.
	Process 552507 waits for ShareLock on transaction 71446281; blocked by process 554478.
	Process 554478: DELETE FROM "asset_versions" WHERE ("asset_versions"."name","asset_versions"."asset_id") IN (($1,$2))
	Process 556376: INSERT INTO "dependency_vulns" ("id","asset_version_name","asset_id","message","state","manual_ticket_creation","created_at","updated_at","cve_id","component_purl","risk_recalculated_at","ticket_id","ticket_url","component_fixed_version","vulnerability_path","raw_risk_assessment","last_detected") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,DEFAULT,DEFAULT,$12,$13,$14,$15),($16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,DEFAULT,$29,$30,$31),($32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,DEFAULT,DEFAULT,$43,$44,$45,$46),($47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,DEFAULT,DEFAULT,$58,$59,$60,$61),($62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,DEFAULT,DEFAULT,$73,$74,$75,$76),($77,$78,$79,$80,$81,$82,$83,$84,$85,$86,$87,DEFAULT,DEFAULT,$88,$89,$90,$91),($92,$93,$94,$95,$96,$97,$98,$99,$100,$101,$102,DEFAULT,DEFAULT,DEFAULT,$103,$104,$105),($106,$107,$108,$109,$110,$111,$112,$113,$114,$115,$116,$117,$118,DEFAULT,$119,$120,$121),($122,$123,$124,$125,$126,$127,$128,$129,$130,$131,$132,DEFAULT,DEFAULT,DEFAULT,$133,
	Process 552507: DELETE FROM "asset_versions" WHERE ("asset_versions"."name","asset_versions"."asset_id") IN (($1,$2))
2026-03-06 14:14:32.054 UTC [554478] HINT:  See server log for query details.
2026-03-06 14:14:32.054 UTC [554478] CONTEXT:  while deleting tuple (1251,21) in relation "dependency_vulns"
	SQL statement "DELETE FROM ONLY "public"."dependency_vulns" WHERE $1 OPERATOR(pg_catalog.=) "asset_version_name" AND $2 OPERATOR(pg_catalog.=) "asset_id""
2026-03-06 14:14:32.054 UTC [554478] STATEMENT:  DELETE FROM "asset_versions" WHERE ("asset_versions"."name","asset_versions"."asset_id") IN (($1,$2))
2026-03-06 14:14:33.055 UTC [556376] ERROR:  deadlock detected
2026-03-06 14:14:33.055 UTC [556376] DETAIL:  Process 556376 waits for ShareLock on transaction 71446265; blocked by process 552507.
	Process 552507 waits for ShareLock on transaction 71446268; blocked by process 556376.
	Process 556376: INSERT INTO "dependency_vulns" ("id","asset_version_name","asset_id","message","state","manual_ticket_creation","created_at","updated_at","cve_id","component_purl","risk_recalculated_at","ticket_id","ticket_url","component_fixed_version","vulnerability_path","raw_risk_assessment","last_detected") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,DEFAULT,DEFAULT,$12,$13,$14,$15),($16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,DEFAULT,$29,$30,$31),($32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,DEFAULT,DEFAULT,$43,$44,$45,$46),($47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,DEFAULT,DEFAULT,$58,$59,$60,$61),($62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,DEFAULT,DEFAULT,$73,$74,$75,$76),($77,$78,$79,$80,$81,$82,$83,$84,$85,$86,$87,DEFAULT,DEFAULT,$88,$89,$90,$91),($92,$93,$94,$95,$96,$97,$98,$99,$100,$101,$102,DEFAULT,DEFAULT,DEFAULT,$103,$104,$105),($106,$107,$108,$109,$110,$111,$112,$113,$114,$115,$116,$117,$118,DEFAULT,$119,$120,$121),($122,$123,$124,$125,$126,$127,$128,$129,$130,$131,$132,DEFAULT,DEFAULT,DEFAULT,$133,
	Process 552507: DELETE FROM "asset_versions" WHERE ("asset_versions"."name","asset_versions"."asset_id") IN (($1,$2))
2026-03-06 14:14:33.055 UTC [556376] HINT:  See server log for query details.
2026-03-06 14:14:33.055 UTC [556376] CONTEXT:  while locking tuple (14,20) in relation "asset_versions"
	SQL statement "SELECT 1 FROM ONLY "public"."asset_versions" x WHERE "name" OPERATOR(pg_catalog.=) $1 AND "asset_id" OPERATOR(pg_catalog.=) $2 FOR KEY SHARE OF x"
2026-03-06 14:14:33.055 UTC [556376] STATEMENT:  INSERT INTO "dependency_vulns" ("id","asset_version_name","asset_id","message","state","manual_ticket_creation","created_at","updated_at","cve_id","component_purl","risk_recalculated_at","ticket_id","ticket_url","component_fixed_version","vulnerability_path","raw_risk_assessment","last_detected") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,DEFAULT,DEFAULT,$12,$13,$14,$15),($16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,DEFAULT,$29,$30,$31),($32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,DEFAULT,DEFAULT,$43,$44,$45,$46),($47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,DEFAULT,DEFAULT,$58,$59,$60,$61),($62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,DEFAULT,DEFAULT,$73,$74,$75,$76),($77,$78,$79,$80,$81,$82,$83,$84,$85,$86,$87,DEFAULT,DEFAULT,$88,$89,$90,$91),($92,$93,$94,$95,$96,$97,$98,$99,$100,$101,$102,DEFAULT,DEFAULT,DEFAULT,$103,$104,$105),($106,$107,$108,$109,$110,$111,$112,$113,$114,$115,$116,$117,$118,DEFAULT,$119,$120,$121),($122,$123,$124,$125,$126,$127,$128,$129,$130,$131,$132,DEFAULT,DEFAULT,DEFAULT,$133,$134,$135),($136,$137,$138,$139,$140,$141,$142,$143,$144,$145,$146,DEFAULT,DEFAULT,DEFAULT,$147,$148,$149),($150,$151,$152,$153,$154,$155,$156,$157,$158,$159,$160,DEFAULT,DEFAULT,DEFAULT,$161,$162,$163),($164,$165,$166,$167,$168,$169,$170,$171,$172,$173,$174,$175,$176,DEFAULT,$177,$178,$179),($180,$181,$182,$183,$184,$185,$186,$187,$188,$189,$190,$191,$192,DEFAULT,$193,$194,$195),($196,$197,$198,$199,$200,$201,$202,$203,$204,$205,$206,DEFAULT,DEFAULT,$207,$208,$209,$210),($211,$212,$213,$214,$215,$216,$217,$218,$219,$220,$221,DEFAULT,DEFAULT,$222,$223,$224,$225),($226,$227,$228,$229,$230,$231,$232,$233,$234,$235,$236,$237,$238,DEFAULT,$239,$240,$241),($242,$243,$244,$245,$246,$247,$248,$249,$250,$251,$252,DEFAULT,DEFAULT,DEFAULT,$253,$254,$255),($256,$257,$258,$259,$260,$261,$262,$263,$264,$265,$266,$267,$268,DEFAULT,$269,$270,$271),($272,$273,$274,$275,$276,$277,$278,$279,$280,$281,$282,DEFAULT,DEFAULT,DEFAULT,$283,$284,$285),($286,$287,$288,$289,$290,$291,$292,$293,$294,$295,$296,DEFAULT,DEFAULT,DEFAULT,$297,$298,$299),($300,$301,$302,$303,$304,$305,$306,$307,$308,$309,$310,DEFAULT,DEFAULT,DEFAULT,$311,$312,$313),($314,$315,$316,$317,$318,$319,$320,$321,$322,$323,$324,DEFAULT,DEFAULT,DEFAULT,$325,$326,$327),($328,$329,$330,$331,$332,$333,$334,$335,$336,$337,$338,DEFAULT,DEFAULT,$339,$340,$341,$342),($343,$344,$345,$346,$347,$348,$349,$350,$351,$352,$353,DEFAULT,DEFAULT,$354,$355,$356,$357),($358,$359,$360,$361,$362,$363,$364,$365,$366,$367,$368,DEFAULT,DEFAULT,$369,$370,$371,$372),($373,$374,$375,$376,$377,$378,$379,$380,$381,$382,$383,DEFAULT,DEFAULT,$384,$385,$386,$387),($388,$389,$390,$391,$392,$393,$394,$395,$396,$397,$398,DEFAULT,DEFAULT,$399,$400,$401,$402),($403,$404,$405,$406,$407,$408,$409,$410,$411,$412,$413,DEFAULT,DEFAULT,$414,$415,$416,$417),($418,$419,$420,$421,$422,$423,$424,$425,$426,$427,$428,DEFAULT,DEFAULT,$429,$430,$431,$432),($433,$434,$435,$436,$437,$438,$439,$440,$441,$442,$443,DEFAULT,DEFAULT,$444,$445,$446,$447),($448,$449,$450,$451,$452,$453,$454,$455,$456,$457,$458,DEFAULT,DEFAULT,$459,$460,$461,$462),($463,$464,$465,$466,$467,$468,$469,$470,$471,$472,$473,DEFAULT,DEFAULT,$474,$475,$476,$477),($478,$479,$480,$481,$482,$483,$484,$485,$486,$487,$488,DEFAULT,DEFAULT,$489,$490,$491,$492),($493,$494,$495,$496,$497,$498,$499,$500,$501,$502,$503,DEFAULT,DEFAULT,$504,$505,$506,$507),($508,$509,$510,$511,$512,$513,$514,$515,$516,$517,$518,DEFAULT,DEFAULT,$519,$520,$521,$522),($523,$524,$525,$526,$527,$528,$529,$530,$531,$532,$533,DEFAULT,DEFAULT,$534,$535,$536,$537),($538,$539,$540,$541,$542,$543,$544,$545,$546,$547,$548,DEFAULT,DEFAULT,$549,$550,$551,$552),($553,$554,$555,$556,$557,$558,$559,$560,$561,$562,$563,DEFAULT,DEFAULT,DEFAULT,$564,$565,$566),($567,$568,$569,$570,$571,$572,$573,$574,$575,$576,$577,DEFAULT,DEFAULT,$578,$579,$580,$581),($582,$583,$584,$585,$586,$587,$588,$589,$590,$591,$592,DEFAULT,DEFAULT,$593,$594,$595,$596),($597,$598,$599,$600,$601,$602,$603,$604,$605,$606,$607,DEFAULT,DEFAULT,$608,$609,$610,$611),($612,$613,$614,$615,$616,$617,$618,$619,$620,$621,$622,DEFAULT,DEFAULT,$623,$624,$625,$626),($627,$628,$629,$630,$631,$632,$633,$634,$635,$636,$637,DEFAULT,DEFAULT,DEFAULT,$638,$639,$640),($641,$642,$643,$644,$645,$646,$647,$648,$649,$650,$651,DEFAULT,DEFAULT,DEFAULT,$652,$653,$654),($655,$656,$657,$658,$659,$660,$661,$662,$663,$664,$665,DEFAULT,DEFAULT,DEFAULT,$666,$667,$668),($669,$670,$671,$672,$673,$674,$675,$676,$677,$678,$679,DEFAULT,DEFAULT,DEFAULT,$680,$681,$682),($683,$684,$685,$686,$687,$688,$689,$690,$691,$692,$693,DEFAULT,DEFAULT,DEFAULT,$694,$695,$696),($697,$698,$699,$700,$701,$702,$703,$704,$705,$706,$707,DEFAULT,DEFAULT,DEFAULT,$708,$709,$710) ON CONFLICT ("id") DO UPDATE SET "updated_at"=$711,"asset_version_name"="excluded"."asset_version_name","asset_id"="excluded"."asset_id","message"="excluded"."message","state"="excluded"."state","manual_ticket_creation"="excluded"."manual_ticket_creation","cve_id"="excluded"."cve_id","component_purl"="excluded"."component_purl","risk_recalculated_at"="excluded"."risk_recalculated_at","ticket_id"="excluded"."ticket_id","ticket_url"="excluded"."ticket_url","component_fixed_version"="excluded"."component_fixed_version","raw_risk_assessment"="excluded"."raw_risk_assessment" RETURNING "last_detected","ticket_id","ticket_url","component_fixed_version","vulnerability_path","effort","risk_assessment","raw_risk_assessment","priority","last_detected"
2026-03-06 14:14:33.059 UTC [556376] ERROR:  current transaction is aborted, commands ignored until end of transaction block
2026-03-06 14:14:33.059 UTC [556376] STATEMENT:  INSERT INTO "cves" ("cve","created_at","updated_at","date_published","date_last_modified","description","cvss","references","cisa_exploit_add","cisa_action_due","cisa_required_action","cisa_vulnerability_name","epss","percentile","vector") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15),($16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30),($31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45),($46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60),($61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75),($76,$77,$78,$79,$80,$81,$82,$83,$84,$85,$86,$87,$88,$89,$90),($91,$92,$93,$94,$95,$96,$97,$98,$99,$100,$101,$102,$103,$104,$105),($106,$107,$108,$109,$110,$111,$112,$113,$114,$115,$116,$117,$118,$119,$120),($121,$122,$123,$124,$125,$126,$127,$128,$129,$130,$131,$132,$133,$134,$135),($136,$137,$138,$139,$140,$141,$142,$143,$144,$145,$146,$147,$148,$149,$150),($151,$152,$153,$154,$155,$156,$157,$158,$159,$160,$161,$162,$163,$164,$165),($166,$167,$168,$169,$170,$171,$172,$173,$174,$175,$176,$177,$178,$179,$180),($181,$182,$183,$184,$185,$186,$187,$188,$189,$190,$191,$192,$193,$194,$195),($196,$197,$198,$199,$200,$201,$202,$203,$204,$205,$206,$207,$208,$209,$210),($211,$212,$213,$214,$215,$216,$217,$218,$219,$220,$221,$222,$223,$224,$225),($226,$227,$228,$229,$230,$231,$232,$233,$234,$235,$236,$237,$238,$239,$240),($241,$242,$243,$244,$245,$246,$247,$248,$249,$250,$251,$252,$253,$254,$255),($256,$257,$258,$259,$260,$261,$262,$263,$264,$265,$266,$267,$268,$269,$270) ON CONFLICT DO NOTHING
2026-03-06 14:14:33.060 UTC [556376] ERROR:  current transaction is aborted, commands ignored until end of transaction block
2026-03-06 14:14:33.060 UTC [556376] STATEMENT:  INSERT INTO "cves" ("cve","created_at","updated_at","date_published","date_last_modified","description","cvss","references","cisa_exploit_add","cisa_action_due","cisa_required_action","cisa_vulnerability_name","epss","percentile","vector") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15),($16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30),($31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45),($46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60),($61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75),($76,$77,$78,$79,$80,$81,$82,$83,$84,$85,$86,$87,$88,$89,$90),($91,$92,$93,$94,$95,$96,$97,$98,$99,$100,$101,$102,$103,$104,$105),($106,$107,$108,$109,$110,$111,$112,$113,$114,$115,$116,$117,$118,$119,$120),($121,$122,$123,$124,$125,$126,$127,$128,$129,$130,$131,$132,$133,$134,$135) ON CONFLICT DO NOTHING
2026-03-06 14:14:33.065 UTC [556376] ERROR:  current transaction is aborted, commands ignored until end of transaction block
2026-03-06 14:14:33.065 UTC [556376] STATEMENT:  INSERT INTO "cves" ("cve","created_at","updated_at","date_published","date_last_modified","description","cvss","references","cisa_exploit_add","cisa_action_due","cisa_required_action","cisa_vulnerability_name","epss","percentile","vector") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15),($16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30),($31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45),($46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60),($61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75),($76,$77,$78,$79,$80,$81,$82,$83,$84,$85,$86,$87,$88,$89,$90) ON CONFLICT DO NOTHING
2026-03-06 14:14:33.067 UTC [556376] ERROR:  current transaction is aborted, commands ignored until end of transaction block
2026-03-06 14:14:33.067 UTC [556376] STATEMENT:  INSERT INTO "cves" ("cve","created_at","updated_at","date_published","date_last_modified","description","cvss","references","cisa_exploit_add","cisa_action_due","cisa_required_action","cisa_vulnerability_name","epss","percentile","vector") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15),($16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30),($31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45) ON CONFLICT DO NOTHING
2026-03-06 14:14:33.070 UTC [556376] ERROR:  current transaction is aborted, commands ignored until end of transaction block
2026-03-06 14:14:33.070 UTC [556376] STATEMENT:  INSERT INTO "cves" ("cve","created_at","updated_at","date_published","date_last_modified","description","cvss","references","cisa_exploit_add","cisa_action_due","cisa_required_action","cisa_vulnerability_name","epss","percentile","vector") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15) ON CONFLICT DO NOTHING
2026-03-06 14:14:34.056 UTC [552507] ERROR:  deadlock detected
2026-03-06 14:14:34.056 UTC [552507] DETAIL:  Process 552507 waits for ShareLock on transaction 71446284; blocked by process 554473.
```

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

DB Deadlock on Artifact deletion #1777

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

DB Deadlock on Artifact deletion #1777

Description

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions