Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-41172

Group locking persistence improvements

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: RESOLVED
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 19.0, 20.0 [Tentative]
    • Fix Version/s: 20.0 [Tentative]
    • Component/s: Kernel
    • Labels:
      None
    • 19 status:
      Please Merge
    • Test Plan:
      Hide

      Please add a Test Plan here.

      Show
      Please add a Test Plan here.

      Description

      Groups are currently storing their locks in an EAV table which makes them difficult to perform searches.

      Proposal is to move the group locking from EAV table and implement in another table which can be efficiently searched.

      The table should contain the group id / reference, the LockMode, and the reference that holds the lock.

      Relationship:

      • There may be many locking references to a group
      • The locking reference and group should unique
      • The LockMode defines the type of lock that is in place for that reference and group

      The AuthzGroupService api should be updated to efficiently search for:

      • references that are locked by a group
      • groups that are locked by a reference

       

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  bergarvi Bernardo Garcia Vila
                  Reporter:
                  ern Earle R Nietzel
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  8 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Git Source Code