Grouper Users - Open Discussion List

[Chris Hyzer <>]

This part is the important part:

Caused by: org.hibernate.NonUniqueResultException: query did not return a 
unique result: 2

There is a corruption in the memberships table, it is expecting one row, but 
got two.

If you look in the grouper_memberships_v for that group_name, you might see 
the duplicate row, and be able to manually delete it.  And/or if you run the 
bad membership finder, and run the script which is printed out, it should 
address the issue.

https://wiki.internet2.edu/confluence/display/GrouperWG/Bad+Membership+Finder+Utility

Let me know if this doesn't help.  Btw, this is fixed in 1.5 due to re-org of 
memberships table and more unique constraints :)

Thanks,
Chris

> -----Original Message-----
> From: Colin Hudler 
> [mailto:]
> Sent: Monday, June 29, 2009 6:17 PM
> To: Grouper Users Mailing List
> Subject: [grouper-users] Problem adding a group to another
>
> Hello.  I am hoping someone can shed some light on this problem.
> Adding
> one group as a direct member of another results in this log message.
> This is the only group that does it.  The group currently lists no
> direct or indirect members.  The group can be navigated to, but
> searching for it by name results in a different stack trace (below this
> one); I am not sure this is related.
>
> 2009-06-29 17:06:53,606 ERROR actions.DoAssignNewMembersAction: <
> chudler EFED83C142A561F452C3020CC13AC3DB-0046
> f10b1b3bee534c5788b2206e94b82043 21882177X ucmcdb > Could not assign
> all
> privilegesedu.internet2.middleware.grouper.internal.dao.GrouperDAOExcep
> tion:
> Problem in HibernateSession: HibernateSession: isNew: false,
> isReadonly:
> false, grouperTransactionType: READ_WRITE_NEW,
> Exception in uniqueResult: (class [Ljava.lang.Object;), ByHqlStatic,
> query: 'select ms, m from Membership as ms, Member as m where
> ms.ownerUuid  = :owner            and  ms.memberUuid = :member
> and  ms.fieldId = :fuuid and  ms.type       = :type
>      and  ms.memberUuid = m.uuid', cacheable: false, cacheRegion:
> edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MembershipDAO.Fi
> ndByOwnerAndMemberAndFieldAndType,
> tx type: null, tx type: nullBind var[0]: 'Param (class
> java.lang.String): 'owner'->'20bd10d2-2766-4
> 342-9fd6-c0c5f472603e', Bind var[1]: 'Param (class java.lang.String):
> 'member'->'c4c6c013-fe87-48db-a947-6c487e06f74e', Bind var[2]: 'Param
> (class java.lang.String):
> 'fuuid'->'ea756054-31a6-4bba-8d49-8e7219fe40cd'Bind var[3]: 'Param
> (class java.lang.String): 'type'->'co
> mposite',
>          at
> edu.internet2.middleware.grouper.hibernate.HibernateSession._internal_h
> ibernateSessionCatch(HibernateSession.java:325)
>          at
> edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHib
> ernateSession(HibernateSession.java:390)
>          at
> edu.internet2.middleware.grouper.hibernate.ByHqlStatic.uniqueResult(ByH
> qlStatic.java:295)
>          at
> edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MembershipDAO.fi
> ndByOwnerAndMemberAndFieldAndType(Hib3MembershipDAO.java:454)
>          at
> edu.internet2.middleware.grouper.misc.DefaultMemberOf.fixComposites(Def
> aultMemberOf.java:942)
>          at
> edu.internet2.middleware.grouper.misc.DefaultMemberOf.access$600(Defaul
> tMemberOf.java:66)
>          at
> edu.internet2.middleware.grouper.misc.DefaultMemberOf$3.callback(Defaul
> tMemberOf.java:818)
>          at
> edu.internet2.middleware.grouper.GrouperSession.callbackGrouperSession(
> GrouperSession.java:648)
>          at
> edu.internet2.middleware.grouper.misc.DefaultMemberOf._evaluateAddImmed
> iateMembership(DefaultMemberOf.java:763)
>          at
> edu.internet2.middleware.grouper.misc.DefaultMemberOf.addImmediate(Defa
> ultMemberOf.java:183)
>          at
> edu.internet2.middleware.grouper.Membership.internal_addImmediateMember
> ship(Membership.java:627)
>          at
> edu.internet2.middleware.grouper.Group.addMember(Group.java:619)
>          at
> edu.internet2.middleware.grouper.Group.addMember(Group.java:564)
>          at
> edu.internet2.middleware.grouper.GrouperHelper.assignPrivileges(Grouper
> Helper.java:825)
>          at
> edu.internet2.middleware.grouper.ui.actions.DoAssignNewMembersAction.gr
> ouperExecute(DoAssignNewMembersAction.java:249)
>          at
> edu.internet2.middleware.grouper.ui.actions.GrouperCapableAction$1.call
> back(GrouperCapableAction.java:211)
>          at
> edu.internet2.middleware.grouper.internal.dao.hib3.Hib3TransactionDAO$1
> .callback(Hib3TransactionDAO.java:46)
>          at
> edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHib
> ernateSession(HibernateSession.java:385)
>          at
> edu.internet2.middleware.grouper.internal.dao.hib3.Hib3TransactionDAO.t
> ransactionCallback(Hib3TransactionDAO.java:39)
>          at
> edu.internet2.middleware.grouper.hibernate.GrouperTransaction.callbackG
> rouperTransaction(GrouperTransaction.java:54)
>          at
> edu.internet2.middleware.grouper.hibernate.GrouperTransaction.callbackG
> rouperTransaction(GrouperTransaction.java:73)
>          at
> edu.internet2.middleware.grouper.ui.actions.GrouperCapableAction.groupe
> rTransactionExecute(GrouperCapableAction.java:208)
>          at
> edu.internet2.middleware.grouper.ui.actions.GrouperCapableAction.execut
> e(GrouperCapableAction.java:263)
>          at
> org.apache.struts.action.RequestProcessor.processActionPerform(RequestP
> rocessor.java:424)
>          at
> org.apache.struts.action.RequestProcessor.process(RequestProcessor.java
> :226)
>          at
> org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
>          at
> org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
>          at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
>          at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
>          at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applic
> ationFilterChain.java:269)
>          at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFil
> terChain.java:188)
>          at
> edu.internet2.middleware.grouper.ui.LoginCheckFilter$1.callback(LoginCh
> eckFilter.java:166)
>          at
> edu.internet2.middleware.grouper.GrouperSession.callbackGrouperSession(
> GrouperSession.java:648)
>          at
> edu.internet2.middleware.grouper.ui.LoginCheckFilter.doFilter(LoginChec
> kFilter.java:161)
>          at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applic
> ationFilterChain.java:215)
>          at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFil
> terChain.java:188)
>          at
> edu.internet2.middleware.grouper.ui.GrouperUiFilter.doFilter(GrouperUiF
> ilter.java:106)
>          at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applic
> ationFilterChain.java:215)
>          at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFil
> terChain.java:188)
>          at
> edu.internet2.middleware.grouper.ui.ErrorFilter.doFilter(ErrorFilter.ja
> va:134)
>          at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applic
> ationFilterChain.java:215)
>          at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFil
> terChain.java:188)
>          at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperVal
> ve.java:201)
>          at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextVal
> ve.java:172)
>          at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authenticato
> rBase.java:433)
>          at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.jav
> a:127)
>          at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.jav
> a:117)
>          at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve
> .java:108)
>          at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:
> 151)
>          at
> org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)
>          at
> org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283)
>          at
> org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:773)
>          at
> org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java
> :703)
>          at
> org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket
> .java:895)
>          at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPoo
> l.java:685)
>          at java.lang.Thread.run(Thread.java:619)
> Caused by: org.hibernate.NonUniqueResultException: query did not return
> a unique result: 2
>          at
> org.hibernate.impl.AbstractQueryImpl.uniqueElement(AbstractQueryImpl.ja
> va:820)
>          at
> org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.jav
> a:811)
>          at
> edu.internet2.middleware.grouper.hibernate.ByHql.uniqueResult(ByHql.jav
> a:237)
>          at
> edu.internet2.middleware.grouper.hibernate.ByHqlStatic$1.callback(ByHql
> Static.java:301)
>          at
> edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHib
> ernateSession(HibernateSession.java:385)
>          ... 54 more
>
>
> 2009-06-29 17:10:32,936 ERROR actions.GrouperCapableAction: < chudler
> FD169DF5E33C11B03924CE54E2B0D91A-0012 d0cb60f1ca9b42c8b4d11d783146ac08
> 21882177X ucmcdb > java.lang.NullPointerException
>          at
> edu.internet2.middleware.grouper.subj.SubjectHelper.sortSetForSearch(Su
> bjectHelper.java:60)
>          at
> edu.internet2.middleware.grouper.subj.SourcesXmlResolver.findAll(Source
> sXmlResolver.java:154)
>          at
> edu.internet2.middleware.grouper.subj.CachingResolver.findAll(CachingRe
> solver.java:126)
>          at
> edu.internet2.middleware.grouper.subj.ValidatingResolver.findAll(Valida
> tingResolver.java:105)
>          at
> edu.internet2.middleware.grouper.SubjectFinder.findAll(SubjectFinder.ja
> va:265)
>          at
> edu.internet2.middleware.grouper.ui.actions.DoSearchSubjectsAction.grou
> perExecute(DoSearchSubjectsAction.java:168)
>          at
> edu.internet2.middleware.grouper.ui.actions.GrouperCapableAction$1.call
> back(GrouperCapableAction.java:211)
>          at
> edu.internet2.middleware.grouper.internal.dao.hib3.Hib3TransactionDAO$1
> .callback(Hib3TransactionDAO.java:46)
>          at
> edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHib
> ernateSession(HibernateSession.java:385)
>          at
> edu.internet2.middleware.grouper.internal.dao.hib3.Hib3TransactionDAO.t
> ransactionCallback(Hib3TransactionDAO.java:39)
> at
> edu.internet2.middleware.grouper.hibernate.GrouperTransaction.callbackG
> rouperTransaction(GrouperTransaction.java:54)
>          at
> edu.internet2.middleware.grouper.hibernate.GrouperTransaction.callbackG
> rouperTransaction(GrouperTransaction.java:73)
>          at
> edu.internet2.middleware.grouper.ui.actions.GrouperCapableAction.groupe
> rTransactionExecute(GrouperCapableAction.java:208)
>          at
> edu.internet2.middleware.grouper.ui.actions.GrouperCapableAction.execut
> e(GrouperCapableAction.java:263)
>          at
> org.apache.struts.action.RequestProcessor.processActionPerform(RequestP
> rocessor.java:424)
>          at
> org.apache.struts.action.RequestProcessor.process(RequestProcessor.java
> :226)
>          at
> org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
>          at
> org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
>          at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
>          at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
>          at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applic
> ationFilterChain.java:269)
>          at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFil
> terChain.java:188)
>          at
> edu.internet2.middleware.grouper.ui.LoginCheckFilter$1.callback(LoginCh
> eckFilter.java:166)
>          at
> edu.internet2.middleware.grouper.GrouperSession.callbackGrouperSession(
> GrouperSession.java:648)
>          at
> edu.internet2.middleware.grouper.ui.LoginCheckFilter.doFilter(LoginChec
> kFilter.java:161)
>          at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applic
> ationFilterChain.java:215)
>          at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFil
> terChain.java:188)
>          at
> edu.internet2.middleware.grouper.ui.GrouperUiFilter.doFilter(GrouperUiF
> ilter.java:106)
>          at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applic
> ationFilterChain.java:215)
>          at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFil
> terChain.java:188)
>          at
> edu.internet2.middleware.grouper.ui.ErrorFilter.doFilter(ErrorFilter.ja
> va:134)
>          at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applic
> ationFilterChain.java:215)
>          at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFil
> terChain.java:188)
>          at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperVal
> ve.java:201)
>          at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextVal
> ve.java:172)
>          at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authenticato
> rBase.java:433)
>          at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.jav
> a:127)
>          at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.jav
> a:117)
>          at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve
> .java:108)
>          at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:
> 151)
>          at
> org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)
>          at
> org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283)
>          at
> org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:773)
>          at
> org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java
> :703)
>          at
> org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket
> .java:895)
>          at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPoo
> l.java:685)
>          at java.lang.Thread.run(Thread.java:619)
>
>
> (this error happens occationally, but doesn't appear related to the
> first stack trace)
> 2009-06-29 17:11:57,778 ERROR actions.GrouperCapableAction: < chudler
> FD169DF5E33C11B03924CE54E2B0D91A-0026 d0cb60f1ca9b42c8b4d11d783146ac08
> 21882177X ucmcdb >
> edu.internet2.middleware.grouper.ui.MissingGroupOrStemException: Unable
> to instantiate a group or stem with ID
> =null
>          at
> edu.internet2.middleware.grouper.ui.GroupOrStem.findByID(GroupOrStem.ja
> va:90)
>          at
> edu.internet2.middleware.grouper.ui.actions.CancelFindNewMembersAction.
> grouperExecute(CancelFindNewMembersAction.java:134)
>          at
> edu.internet2.middleware.grouper.ui.actions.GrouperCapableAction$1.call
> back(GrouperCapableAction.java:211)
>          at
> edu.internet2.middleware.grouper.internal.dao.hib3.Hib3TransactionDAO$1
> .callback(Hib3TransactionDAO.java:46)
>          at
> edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHib
> ernateSession(HibernateSession.java:385)
>          at
> edu.internet2.middleware.grouper.internal.dao.hib3.Hib3TransactionDAO.t
> ransactionCallback(Hib3TransactionDAO.java:39)
>          at
> edu.internet2.middleware.grouper.hibernate.GrouperTransaction.callbackG
> rouperTransaction(GrouperTransaction.java:54)
>          at
> edu.internet2.middleware.grouper.hibernate.GrouperTransaction.callbackG
> rouperTransaction(GrouperTransaction.java:73)
>          at
> edu.internet2.middleware.grouper.ui.actions.GrouperCapableAction.groupe
> rTransactionExecute(GrouperCapableAction.java:208)
>          at
> edu.internet2.middleware.grouper.ui.actions.GrouperCapableAction.execut
> e(GrouperCapableAction.java:263)
>          at
> org.apache.struts.action.RequestProcessor.processActionPerform(RequestP
> rocessor.java:424)
>          at
> org.apache.struts.action.RequestProcessor.process(RequestProcessor.java
> :226)
>          at
> org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
>          at
> org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397)
>          at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
>          at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
>          at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applic
> ationFilterChain.java:269)
>          at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFil
> terChain.java:188)
> at
> edu.internet2.middleware.grouper.ui.LoginCheckFilter$1.callback(LoginCh
> eckFilter.java:166)
>          at
> edu.internet2.middleware.grouper.GrouperSession.callbackGrouperSession(
> GrouperSession.java:648)
>          at
> edu.internet2.middleware.grouper.ui.LoginCheckFilter.doFilter(LoginChec
> kFilter.java:161)
>          at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applic
> ationFilterChain.java:215)
>          at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFil
> terChain.java:188)
>          at
> edu.internet2.middleware.grouper.ui.GrouperUiFilter.doFilter(GrouperUiF
> ilter.java:106)
>          at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applic
> ationFilterChain.java:215)
>          at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFil
> terChain.java:188)
>          at
> edu.internet2.middleware.grouper.ui.ErrorFilter.doFilter(ErrorFilter.ja
> va:134)
>          at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applic
> ationFilterChain.java:215)
>          at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFil
> terChain.java:188)
>          at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperVal
> ve.java:201)
>          at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextVal
> ve.java:172)
>          at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authenticato
> rBase.java:433)
>          at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.jav
> a:127)
>          at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.jav
> a:117)
>          at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve
> .java:108)
>          at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:
> 151)
>          at
> org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)
>          at
> org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283)
>          at
> org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:773)
>          at
> org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java
> :703)
>          at
> org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket
> .java:895)
>          at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPoo
> l.java:685)
>          at java.lang.Thread.run(Thread.java:619)