Grouper Users - Open Discussion List

[Shilen Patel <>]

It’s mentioned over here:

https://spaces.internet2.edu/display/Grouper/Bad+Membership+Finder+Utility

This can also be run via a daemon (as part of the Grouper Daemon) where it 
will automatically fix any issues it finds.  The daemon isn’t on by default, 
but maybe we should consider that?

>> Is this step in the instructions?  

It sounds like you’re in the process of upgrading so when you say 
instructions, are you referring to the upgrade instructions?   If so, I don’t 
think this is an expected issue, so that may be why it’s not mentioned there. 
 Though it’s probably good to check things like this before an upgrade.

- Shilen

On 7/17/18, 11:53 AM, "Jim Fox" 
<>
 wrote:

    
    That found a very lot of them.  And produced a findbadmemberships.gsh 
with 
    400K bad memberships.  I'm running that through gsh now.  Looks like it 
    should solve the problem.
    
    Thanks for working on this.  BTW. Is this step in the instructions?  I 
    must have missed it.
    
    Jim
    
    On Mon, 16 Jul 2018, Shilen Patel wrote:
    
    > Date: Mon, 16 Jul 2018 16:56:14
    > From: Shilen Patel 
<>
    > To: Jim Fox 
<>
    > Cc: 
""
 
<>
    > Subject: Re: [grouper-users] exception in group deleteMember
    > 
    > How about if you run it like this?
    >
    > groovy:000> findBadMemberships()
    >
    > Checking Composite Memberships
    > Checking Group Sets
    > Checking memberships where member is a deleted group
    > Checking GrouperAll
    > ===> findBadMemberships completed successfully
    >
    > Thanks!
    >
    > - Shilen
    >
    > On 7/16/18, 6:47 PM, "Jim Fox" 
<>
 wrote:
    >
    >
    >    Using “ms” as grouper_memberships_all_v I get two rows.  They differ 
in parts of the 'ms' uuid strings.
    >
    >    running the bad membership finder didn't seem to find anything
    >
    >      groovy:000> FindBadMemberships.checkAndFixGrouperAll()
    >        Finished running successfully.  0 changes made.
    >        ===> null
    >
    >    Jim
    >
    >
    >
    >    On Mon, 16 Jul 2018, Shilen Patel wrote:
    >
    >    > Date: Mon, 16 Jul 2018 15:08:19
    >    > From: Shilen Patel 
<>
    >    > To: Jim Fox 
<>,
    >    >     
""
 
<>
    >    > Subject: Re: [grouper-users] exception in group deleteMember
    >    >
    >    >>> Did I miss some conversion settings?
    >    >
    >    > One conversion issue – MembershipEntry is a view - 
grouper_memberships_all_v.  The view combines grouper_memberships and 
grouper_group_set.  So it’s possible that you have a bad group set.  Can you 
try running the query manually where “ms” is grouper_memberships_all_v?  Did 
you try running bad membership finder?
    >    >
    >    > Thanks!
    >    >
    >    > - Shilen
    >    >
    >    > On 7/16/18, 1:24 PM, 
"
 on behalf of Jim Fox" 
<
 on behalf of 
>
 wrote:
    >    >
    >    >
    >    >
    >    >    I can run the query manually, with som e name substitutions
    >    >
    >    >      # select ms, m from grouper_memberships as ms, 
grouper_members as m where  ms.owner_group_id  = 
'881fef48f9e32bedf88b8fe5d96ed250' and  ms.member_id = 
'737b30aff49747f480806371ca041e7d' and  ms.field_id = 
'0094f3965ca2419286d3c4c3c9a1fb4e' and  ms.member_id = m.id  and  
ms.mship_type  = 'immediate';
    >    >
    >    >    and I get:
    >    >
    >    >    
(449f9478f14d4bca9fa9ffbef01bf74c,737b30aff49747f480806371ca041e7d,881fef48f9e32bedf88b8fe5d96ed250,0094f3965ca2419286d3c4c3c9a1fb4e,881fef48f9e32bed
    >    >    
f88b8fe5d96ed250,,,,T,,,immediate,c9f6837335d64af8a82f37f929e80e56,1531760225755,0,ccdcc16513b642609f1907f9e3667d92)
 | (737b30aff49747f480806371ca041e
    >    >    
7d,da74fce621d011d4abd00004ac494ffe,uwpds,person,0,ec28d43704c04a449820c3bd4922f37d,imf,Stenvik,"T.
 Erling",,,imf,stenvik,"t. erling",,,imf,"T. Erling
    >    >      Stenvik",imf)
    >    >
    >    >    (1 row)
    >    >
    >    >    The expected result.  Did I miss some conversion settings?  The 
grouper query seems to prefer '*Uuid' where the database has just '*_id'
    >    >
    >    >    Jim
    >    >
    >    >
    >    >    > I am trying to delete a member from a field and getting an 
"Exception in
    >    >    > uniqueResult:"
    >    >    >
    >    >    > -------------------------------------------------------------
    >    >    > The call is (Group).deleteMember( (Member), (Field) )
    >    >    >
    >    >    > [ Adds always work, it's just deletes that fail ]
    >    >    >
    >    >    > SEVERE: Servlet.service() for servlet [gws] in context with 
path
    >    >    > [/gws_grouper] threw exception [Request processing failed; 
nested exception
    >    >    > is 
edu.internet2.middleware.grouper.exception.MemberDeleteException: Problem
    >    >    > in HibernateSession: HibernateSession (72961acc): notNew, 
notReadonly,
    >    >    > READ_WRITE_NEW, activeTransaction, session (531fd45e),
    >    >    > Exception in uniqueResult: (class [Ljava.lang.Object;), 
ByHqlStatic, query:
    >    >    > 'select ms, m from MembershipEntry as ms, Member as m where
    >    >    > ms.ownerGroupId  = :owner            and  ms.memberUuid = 
:member
    >    >    > and  ms.fieldId = :fuuid and  ms.memberUuid = m.uuid  and  
ms.type  =
    >    >    > 'immediate' ', cacheable: false, cacheRegion:
    >    >    > 
edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MembershipDAO, tx
    >    >    > type: null, tx type: nullBind var[0]: 'Param (class 
java.lang.String):
    >    >    > 'owner'->'881fef48f9e32bedf88b8fe5d96ed250', Bind var[1]: 
'Param (class
    >    >    > java.lang.String): 
'member'->'737b30aff49747f480806371ca041e7d'Bind var[2]:
    >    >    > 'Param (class java.lang.String): 
'fuuid'->'0094f3965ca2419286d3c4c3c9a1fb4e',
    >    >    > , , group name: u:fox:spud97, subject: Subject id:
    >    >    > da74fce621d011d4abd00004ac494ffe, sourceId: uwpds, field: 
authorized-senders,
    >    >    > Problem in HibernateSession: HibernateSession (8dd69ee): new, 
notReadonly,
    >    >    > READ_WRITE_NEW, notActiveTransaction, session (531fd45e)] 
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:365)
    >    >    >        at
    >    >    > 
edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:701)
    >    >    >        at
    >    >    > 
edu.internet2.middleware.grouper.hibernate.ByHqlStatic.uniqueResult(ByHqlStatic.java:356)
    >    >    >        at
    >    >    > 
edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MembershipDAO.findByGroupOwnerAndMemberAndFieldAndType(Hib3MembershipDAO.java:1537)
    >    >    >        at
    >    >    > 
edu.internet2.middleware.grouper.Membership.internal_delImmediateMembership(Membership.java:1337)
    >    >    >        at 
edu.internet2.middleware.grouper.Group$9.callback(Group.java:2403)
    >    >    >        at
    >    >    > 
edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:701)
    >    >    >        at
    >    >    > 
edu.internet2.middleware.grouper.Group.deleteMember(Group.java:2378)
    >    >    >        at
    >    >    > 
edu.internet2.middleware.grouper.Group.deleteMember(Group.java:2191)
    >    >    >        at
    >    >    > 
edu.internet2.middleware.grouper.Group.deleteMember(Group.java:2225)
    >    >    >        at
    >    >    > 
edu.washington.gws.group.grouper.GrouperGroupFactory.updateFieldMembers(GrouperGroupFactory.java:906)
    >    >    >
    >    >    > 
--------------------------------------------------------------------------------
    >    >    > Everything in the query exists, and I've verified the member 
being deleted is
    >    >    > a row of grouper_memberships for the field.
    >    >    >
    >    >    > What's the not unique query looking for??
    >    >    >
    >    >    > Thanks,
    >    >    >
    >    >    > Jim
    >    >    >
    >    >    >
    >    >
    >    >
    >    >
    >
    >