Uploaded image for project: 'Grouper'
  1. Grouper
  2. GRP-1686

Error deleting group with custom list

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • None
    • 2.3.1, 2.3.0.patch
    • API
    • None

    Description

      This looks like a grouper bug, relating to custom lists.
       
      I am doing some final testing for our soon-to-happen upgrade to grouper
      2.3.0.  So this is on a test database.
       
      1) have grouper 2.3.0 with patch level 92
      2) copied database (postgres) to test database
      3) converted the database from 26 to 30
       
      We have some custom lists, 'authorized-senders' being one.
       
      For a particular group I can add a member to that list in the admin ui.  That works.
      However, now I cannot delete the group.  Trying to results in these log entries:
       
      (several)
      2018-02-09 13:22:16,516: [ajp-nio-127.0.0.1-8009-exec-4] INFO  EventLog.info(156) - < fox 193FE75E02962F84795D608DD9527B54.iam21-0071 0aa1b0d7f4ff440b9da54cf43cc85f26 d9459cae21d011d4abd00004ac494ffe uwpds > - [af75960cd6104f6492b5d08773d00f8c,'GrouperSystem','application'] revoke access priv: group='u:fox:browser6:sub7' priv='view' (92ms)
       
      and etc for the other privs. Then:
       
      2018-02-09 13:22:17,163: [ajp-nio-127.0.0.1-8009-exec-4] ERROR SqlExceptionHelper.logExceptions(129) - < fox 193FE75E02962F84795D608DD9527B54.iam21-0071 0aa1b0d7f4ff440b9da54cf43cc85f26 d9459cae21d011d4abd00004ac494ffe uwpds > - Batch entry 0 delete from grouper_groups where id='09e7861885d546b4bde6e00df413f690' and hibernate_version_number=4 was aborted: ERROR: update or delete on table "grouper_groups" violates foreign key constraint "fk_memberships_group_owner_id" on table "grouper_memberships"
       
      This is because the membership of the custom list was not deleted.  If I delete that membership then I can delete the group.
      I've encountered this with both the API and the UI.
       
      Jim
       
       
       
       

      Attachments

        Activity

          People

            shilen.patel@at.internet2.edu Shilen Patel (duke.edu)
            shilen.patel@at.internet2.edu Shilen Patel (duke.edu)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Smart Checklist