Uploaded image for project: 'mod-permissions'
  1. mod-permissions
  2. MODPERMS-110

Upgrade issues between Q2 hotfix 4 and Q3: "deadlock detected" and "duplicate key value violates unique constraint"

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: P1
    • Resolution: Done
    • Affects Version/s: 5.12.1
    • Fix Version/s: None
    • Environment:

      Multi-node K8s cluster backed by vSphere
      Dedicated and separate Postgres v10.11 database hosts for Okapi and Folio modules
      Dockerized Okapi v4.2.2

    • Template:
      Standard Bug Write-Up Format
    • Development Team:
      Core: Platform
    • Affected Institution:
      TAMU

      Description

      Upgraded release of mod-permissions from v5.11.4 to v5.12.1 for an existing diku tenant with data.

      The request sent to Okapi was this, with reference and sample data set to false:

      curl -w '\n' -D - -X POST -H "Content-type: application/json" \
      -d @upgrade.json \
      $OKAPI_URL/_/proxy/tenants/$TENANT_ID/install?deploy=false\&preRelease=false\&tenantParameters=loadSample%3Dfalse%2CloadReference%3Dfalse
      

      The Job returned the following errors during the Okapi tenant API call:

      {
      
      "id" : "mod-login-7.1.0",
      
      "from" : "mod-login-7.0.1",
      
      "action" : "enable",
      
      "message" : "POST request for mod-permissions-5.12.1 /_/tenantpermissions failed with 400: deadlock detected"
      
      },
      {
      
      "id" : "mod-orders-11.1.0",
      
      "from" : "mod-orders-11.0.6",
      
      "action" : "enable",
      
      "message" : "POST request for mod-permissions-5.12.1 /_/tenantpermissions failed with 400: deadlock detected"
      
      },
      {
      
      "id" : "mod-data-export-3.0.0",
      
      "from" : "mod-data-export-2.1.4",
      
      "action" : "enable",
      
      "message" : "POST request for mod-permissions-5.12.1 /_/tenantpermissions failed with 400: deadlock detected"
      
      },
      {
      
      "id" : "folio_data-export-3.0.0",
      
      "from" : "folio_data-export-2.0.1",
      
      "action" : "enable",
      
      "message" : "POST request for mod-permissions-5.12.1 /_/tenantpermissions failed with 400: duplicate key value violates unique constraint \"permissions_permissionname_idx_unique\""
      
      },
      {
      
      "id" : "mod-source-record-manager-2.4.0",
      
      "from" : "mod-source-record-manager-2.3.4",
      
      "action" : "enable",
      
      "message" : "POST request for mod-permissions-5.12.1 /_/tenantpermissions failed with 400: deadlock detected"
      
      },
      {
      
      "id" : "mod-oai-pmh-3.2.1",
      
      "from" : "mod-oai-pmh-3.1.3",
      
      "action" : "enable",
      
      "message" : "POST request for mod-permissions-5.12.1 /_/tenantpermissions failed with 400: duplicate key value violates unique constraint \"permissions_permissionname_idx_unique\""
      
      },
      

      More logs with this error have been posted to RMB-744.

        TestRail: Results

          Attachments

            Issue Links

              Activity

                People

                Assignee:
                Unassigned Unassigned
                Reporter:
                jroot Jason Root
                Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    TestRail: Runs

                      TestRail: Cases