[RTFACT-17393] Artifactory is running into VFS exceptions and DB locking issue due to a rogue transaction Created: 24/Aug/18  Updated: 25/Sep/18  Resolved: 29/Aug/18

Status: Resolved
Project: Artifactory Binary Repository
Component/s: Database, High Availability
Affects Version/s: 6.2.0
Fix Version/s: 6.3.2

Type: Bug Priority: Blocker
Reporter: Shai Ben-Zvi Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: None

Attachments: File stacktrace.rtf    
Issue Links:
is contained in RTFACT-17418 With DB sessions, Artifactory leaves ... Resolved


During the upgrade from 6.1.0 to 6.2.0 with PostgreSQL in HA environment, the database might run into locking contention and consequently errors for "duplicate key" of node ids, as this error is on every node_id:

Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "node_meta_infos_pk"
  Detail: Key (node_id)=(26023197) already exists.

Rolling restart might resolve the issue, but that is not always helping.

See stacktrace attached.

Note the above duplicate node_id error appears on every id and not only on a single node id only.

Generated at Tue Apr 07 08:16:00 UTC 2020 using Jira 8.5.3#805003-sha1:b4933e02eaff29a49114274fe59e1f99d9d963d7.