Grouper Users - Open Discussion List

[Carl Waldbieser <>]

I was able to track it down with:

  SELECT * FROM grouper_pit_groups WHERE source_id = 
'20c15c474ffa4c6d9886c2cf3e698bf9';

This gave me the name of the group.  I'm not 100% certain, but I think this 
group was a member of a broken composite in the "test" stem of our 
deployment.  I cleaned out the remaining groups in the "test" stem and then 
the loader job was able to complete.

Thanks,
Carl Waldbieser
ITS Identity Management
Lafayette College

----- Original Message -----
From: "Carl Waldbieser" 
<>
To: "grouper-users" 
<>
Sent: Monday, 10 September, 2018 13:18:51
Subject: [grouper-users] Can't remove member from group

I'm experiencing an issue with a group that has an associated loader job.
The job normally loads 5-10 students who have transferred out of our 
institution within the last 32 days.
Today, the grouper status URL told me the loader job did not complete 
successfully.

I tried manually loading the job and got a large-ish stack trace that 
identified an issue with 2 members in the group.
I tried removing the members of the group one by one, and I could remove all 
the members, except the 2 identifier in the loader error.  For these 2, I got 
the following error:

    Exception in delete: edu.internet2.middleware.grouper.Membership, 
edu.internet2.middleware.grouper.hibernate.ByObject@6152ea74,
    Problem in HibernateSession: HibernateSession (1879c062): notNew, 
notReadonly, READ_WRITE_NEW, activeTransaction, session (31f23ff3),
    Exception in delete: edu.internet2.middleware.grouper.Membership, 
ByObjectStatic, query: ', cacheable: null, cacheRegion: null, entityName: 
ImmediateMembershipEntry, tx type: null,
    Problem in HibernateSession: HibernateSession (32564257): notNew, 
notReadonly, READ_WRITE_NEW, activeTransaction, session (31f23ff3),
    Problem in HibernateSession: HibernateSession (f21c009): new, 
notReadonly, READ_WRITE_NEW, notActiveTransaction, session (31f23ff3)
            at 
edu.internet2.middleware.grouper.internal.dao.hib3.Hib3GroupDAO.findByUuid(Hib3GroupDAO.java:1285)
            at 
edu.internet2.middleware.grouper.internal.dao.hib3.Hib3GroupDAO.findByUuid(Hib3GroupDAO.java:1253)
            at 
edu.internet2.middleware.grouper.internal.dao.hib3.Hib3GroupDAO.findByUuid(Hib3GroupDAO.java:1244)
            at 
edu.internet2.middleware.grouper.Membership.fixComposites(Membership.java:2248)
            at 
edu.internet2.middleware.grouper.Membership.fixComposites(Membership.java:2286)
            at 
edu.internet2.middleware.grouper.Membership.fixComposites(Membership.java:2286)
            at 
edu.internet2.middleware.grouper.Membership.processPostMembershipDelete(Membership.java:2093)
            at 
edu.internet2.middleware.grouper.Membership.onPostDelete(Membership.java:1961)
            at 
edu.internet2.middleware.grouper.hibernate.ByObject.delete(ByObject.java:122)
            at 
edu.internet2.middleware.grouper.hibernate.ByObjectStatic$10.callback(ByObjectStatic.java:656)
            at 
edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:687)
            at 
edu.internet2.middleware.grouper.hibernate.ByObjectStatic.delete(ByObjectStatic.java:643)
            at 
edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MembershipDAO.delete(Hib3MembershipDAO.java:2074)
            at 
edu.internet2.middleware.grouper.Membership$2.callback(Membership.java:540)
            at 
edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:687)
            at 
edu.internet2.middleware.grouper.Membership.delete(Membership.java:528)
            at 
edu.internet2.middleware.grouper.Membership.internal_delImmediateMembership(Membership.java:1330)
            at 
edu.internet2.middleware.grouper.Group$9.callback(Group.java:2387)
            at 
edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:687)
            at 
edu.internet2.middleware.grouper.Group.deleteMember(Group.java:2362)
            at 
edu.internet2.middleware.grouper.Group.deleteMember(Group.java:2279)
            at 
edu.internet2.middleware.grouper.Group.deleteMember(Group.java:2243)
            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
            at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
            at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
            at java.lang.reflect.Method.invoke(Method.java:606)

    edu.internet2.middleware.grouper.exception.GroupNotFoundException: 
edu.internet2.middleware.grouper.exception.GroupNotFoundException: Cant find 
group by uuid: 20c15c474ffa4c6d9886c2cf3e698bf9,
    Exception in delete: edu.internet2.middleware.grouper.Membership, 
edu.internet2.middleware.grouper.hibernate.ByObject@6152ea74,
    Problem in HibernateSession: HibernateSession (1879c062): notNew, 
notReadonly, READ_WRITE_NEW, activeTransaction, session (31f23ff3),
    Exception in delete: edu.internet2.middleware.grouper.Membership, 
ByObjectStatic, query: ', cacheable: null, cacheRegion: null, entityName: 
ImmediateMembershipEntry, tx type: null,
    Problem in HibernateSession: HibernateSession (32564257): notNew, 
notReadonly, READ_WRITE_NEW, activeTransaction, session (31f23ff3),
    Problem in HibernateSession: HibernateSession (f21c009): new, 
notReadonly, READ_WRITE_NEW, notActiveTransaction, session (31f23ff3)


I saw the "GroupNotFoundException" and thought, "Ah-ha!  Must be a bad 
membership error!"  But I ran the GSH `findBadMemberships -all` tool, and it 
didn't find any bad memberships.

Does anyone have any idea what step I should take next?  Is there some query 
I can perform on the Grouper database for the missing group UUID that would 
help me track down the issue?

Thanks,
Carl Waldbieser
ITS Identity Management
Lafayette College