Grouper Users - Open Discussion List

[Shilen Patel <>]

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