Uploaded image for project: 'MidPoint'
  1. MidPoint
  2. MID-4611

LOCK TABLE m_org_closure IN EXCLUSIVE MODE

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 3.7.2, 3.8
    • Component/s: None
    • Labels:
    • Subscription:
      Active subscription

      Description

      Possibly Oracle DB bug that left this table locked by disconnected session. But mp wont start without telling any reason. Last code line OrgClosureManager:994

      New occurence that M_TRIGGER table get locked during opening new cert stage. Opening stage may take hours, and in the meantime, this table stays locked and is blocking other operations in midPoint (e.g. updating role&starting approval WF).

      And also following update got stuck in DB:
      update m_acc_cert_case set administrativeStatus=:1 , archiveTimestamp=:2 , disableReason=:3 , disableTimestamp=:4 , effectiveStatus=:5 , enableTimestamp=:6 , validFrom=:7 ,validTo=:8 , validityChangeTimestamp=:9 , validityStatus=:10 , currentStageOutcome=:11 , objectRef_relation=:12 , objectRef_targetOid=:13 , objectRef_type=:14 , orgRef_relation=:15, orgRef_targetOid=:16 , orgRef_type=:17 , outcome=:18 , remediedTimestamp=:19 , reviewDeadline=:20 , reviewRequestedTimestamp=:21 , stageNumber=:22 , targetRef_relation=:23 ,targetRef_targetOid=:24 , targetRef_type=:25 , tenantRef_relation=:26 , tenantRef_targetOid=:27 , tenantRef_type=:28 , fullObject=:29 where id=:30 and owner_oid=:31

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              martin.lizner Martin Lizner
              Reporter:
              martin.lizner Martin Lizner
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: