Uploaded image for project: 'Artifactory Binary Repository'
  1. Artifactory Binary Repository
  2. RTFACT-17393

Artifactory is running into VFS exceptions and DB locking issue due to a rogue transaction

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 6.2.0
    • Fix Version/s: 6.3.2
    • Component/s: Database, High Availability
    • Labels:
      None

      Description

      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.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                shaibz Shai Ben-Zvi
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: