Grouper Users - Open Discussion List

[Jim Fox <>]

I do seem to have duplicates.  In this case there are two entries that differ 
only in parent_id.

What is grouper_group_sets for? 
How did I get duplicates?  Something from the 2.1->2.3 upgrade?
How do I get rid of them?

Thanks,

Jim


On Thu, 3 Aug 2017, Shilen Patel wrote:

> Date: Thu, 3 Aug 2017 15:32:01
> From: Shilen Patel 
> <>
> To: Jim Fox 
> <>
> Cc: 
> ""
>  
> <>
> Subject: Re: [grouper-users] unable to add group to group field (2.3)
>
> Looks like you may have duplicates in your group set table.  I don't think 
> bad membership finder catches that right now.  I can add it there, but
> you can verify by running this I think:
>
> select owner_group_id, member_group_id, field_id from grouper_group_set where 
> depth='0' and owner_group_id is not null and member_group_id is not
> null and field_id is not null group by owner_group_id, member_group_id, field_id 
> having count(*) > 1
>
> Thanks!
>
> - Shilen
>
> On 8/3/17, 6:13 PM, "Jim Fox" 
> <>
>  wrote:
>
>
> This is experimenting with grouper api 2.3
>
> I am trying to add a group as a field member (not membership).  I get an
> exception: (sorry for the messay post)
>
> I am able to add non-group subjects.
>
> Something to do with group sets?
>
> Jim
>
> ------------------------------------------------------
> Aug 03, 2017 2:59:11 PM org.apache.catalina.core.StandardWrapperValve invoke
> SEVERE: Servlet.service() for servlet [gws] in context with path 
> [/gws_grouper] threw exception [Request processing failed; nested exception
> is java.lang.RuntimeException: 
> edu.internet2.middleware.grouper.internal.dao.GrouperDAOException: Problem in 
> HibernateSession:
> HibernateSession (6c4c2a54): notNew, notReadonly, READ_WRITE_NEW, 
> activeTransaction, session (5bd96f94),
> Exception in uniqueResult: (class 
> edu.internet2.middleware.grouper.group.GroupSet), ByHqlStatic, query: 'select 
> gs from GroupSet as gs where
> gs.ownerGroupId = :id and memberGroupId = :id and fieldId = :field and 
> depth='0'', cacheable: true, cacheRegion:
> edu.internet2.middleware.grouper.internal.dao.hib3.Hib3GroupSetDAO.FindSelfGroup,
>  tx type: null, tx type: nullBind var[0]: 'Param (class
> java.lang.String): 'id'->'881fef48f9e32bedf88b8fe5d96ed250'Bind var[1]: 
> 'Param (class java.lang.String):
> 'field'->'0094f3965ca2419286d3c4c3c9a1fb4e', ,
> Exception in save: edu.internet2.middleware.grouper.Membership, 
> edu.internet2.middleware.grouper.hibernate.ByObject@44744e2e,
> Problem in HibernateSession: HibernateSession (6e7b95d1): notNew, 
> notReadonly, READ_WRITE_NEW, activeTransaction, session (5bd96f94),
> Exception in save: edu.internet2.middleware.grouper.Membership, 
> ByObjectStatic, query: ', cacheable: null, cacheRegion: null, entityName:
> ImmediateMembershipEntry, tx type: null,
> , group name: u:fox:spud97, subject: Subject groupName: u:fox:spud97, 
> sourceId: g:gsa, field: authorized-senders,
> Problem in HibernateSession: HibernateSession (29610a0e): new, notReadonly, 
> READ_WRITE_NEW, notActiveTransaction, session (5bd96f94)] with
> root cause
> org.hibernate.NonUniqueResultException: query did not return a unique result: 
> 2
>          at 
> org.hibernate.internal.AbstractQueryImpl.uniqueElement(AbstractQueryImpl.java:971)
>          at 
> org.hibernate.internal.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:960)
>          at 
> edu.internet2.middleware.grouper.hibernate.ByHql.uniqueResult(ByHql.java:282)
>          at 
> edu.internet2.middleware.grouper.hibernate.ByHqlStatic$1.callback(ByHqlStatic.java:348)
>          at 
> edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:700)
>          at 
> edu.internet2.middleware.grouper.hibernate.ByHqlStatic.uniqueResult(ByHqlStatic.java:339)
>          at 
> edu.internet2.middleware.grouper.internal.dao.hib3.Hib3GroupSetDAO.findSelfGroup(Hib3GroupSetDAO.java:356)
>          at 
> edu.internet2.middleware.grouper.Membership.processPostMembershipSaveOrUpdate(Membership.java:2135)
>          at 
> edu.internet2.middleware.grouper.Membership.onPostSave(Membership.java:1997)
>          at 
> edu.internet2.middleware.grouper.hibernate.ByObject.save(ByObject.java:224)
>          at 
> edu.internet2.middleware.grouper.hibernate.ByObjectStatic$7.callback(ByObjectStatic.java:494)
>          at 
> edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:700)
>          at 
> edu.internet2.middleware.grouper.hibernate.ByObjectStatic.save(ByObjectStatic.java:481)
>          at 
> edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MembershipDAO.save(Hib3MembershipDAO.java:2053)
>          at 
> edu.internet2.middleware.grouper.Membership.internal_addImmediateMembership(Membership.java:1246)
>          at edu.internet2.middleware.grouper.Group$4.callback(Group.java:1392)
>          at 
> edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:700)
>          at 
> edu.internet2.middleware.grouper.Group.internal_addMember(Group.java:1364)
>          at edu.internet2.middleware.grouper.Group.addMember(Group.java:938)
>          at edu.internet2.middleware.grouper.Group.addMember(Group.java:899)
>          at 
> edu.washington.gws.group.grouper.GrouperGroupFactory.updateFieldMembers(GrouperGroupFactory.java:848)
>    ...