Grouper Users - Open Discussion List

[Jim Fox <>]

Thanks,

Jim


On Wed, 14 Feb 2018, Shilen Patel wrote:

> Date: Wed, 14 Feb 2018 07:42:23
> From: Shilen Patel 
> <>
> To: Jim Fox 
> <>
> Cc: 
> ""
>  
> <>
> Subject: Re: [grouper-users] bug in 2.3.0? cannot delete group
>
> This is fixed in grouper_v2_3_0_api_patch_93.
>
> - Shilen
>
> On 2/9/18, 4:55 PM, 
> "
>  on behalf of Jim Fox" 
> <
>  on behalf of 
> >
>  wrote:
>
>
>    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