Grouper Developers Forum

[Petra Schmitz <>]

Hi,

today we finalized the upgrade from Grouper 1.3.0 to Grouper 1.4.1. 
Everything seems to work fine, but we have a problem with at least one 
user. If he logs in, the load and postgres-jobs on our machine increases 
and no usage is possible anymore.

We use Postgres, Java 5 or 6 (changing Java version hasn't any effect to 
our problem) and Shibboleth.

In error_log we see the following:
Exception in uniqueResult: (class 
edu.internet2.middleware.grouper.Member), ByHqlStatic, query: 'from 
Member as m where      m.subjectIdDb       = :sid    and 
m.subjectSourceIdDb = :source and  m.subj
ectTypeId   = :type', cacheable: true, cacheRegion: 
edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.FindBySubject, 
tx type: nullBind var[0]: 'Param (class java.lang.String): 'sid'->'Gr
ouperAll', Bind var[1]: 'Param (class java.lang.String): 
'type'->'application'Bind var[2]: 'Param (class java.lang.String): 
'source'->'g:isa',
2009-04-28 16:36:28,422: [TP-Processor14] ERROR 
PrivilegeHelper.canViewMemberships(237) - canViewMemberships: Problem in 
HibernateSession: HibernateSession: isNew: true, isReadonly: true, 
grouperTransa
ctionType: READONLY_NEW,
Exception in uniqueResult: (class 
edu.internet2.middleware.grouper.Group), ByHqlStatic, query: 'from Group 
as g where g.uuid = :uuid', cacheable: true, cacheRegion: 
edu.internet2.middleware.grouper.int
ernal.dao.hib3.Hib3GroupDAO.FindByUuid, tx type: nullBind var[0]: 'Param 
(class java.lang.String): 'uuid'->'9a229a6c-6f22-44be-8588-214e10ebbc09',
2009-04-28 16:36:28,424: [TP-Processor11] ERROR 
JDBCExceptionReporter.logExceptions(78) - An I/O error occured while 
sending to the backend.
2009-04-28 16:36:28,440: [TP-Processor11] ERROR ByHqlStatic.list(267) - 
Exception in list: (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.memberUuid = m.uuid', cacheable: false, cacheRegion: 
edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MembershipD
AO.FindAllByOwnerAndMemberAndField, tx type: nullBind var[0]: 'Param 
(class java.lang.String): 
'owner'->'9a229a6c-6f22-44be-8588-214e10ebbc09'Bind var[1]: 'Param 
(class java.lang.String): 'member'->'d1
2d50f9-3c0b-4ee3-b5c1-6b7d9170ea21',
edu.internet2.middleware.grouper.internal.dao.GrouperDAOException: 
Problem in HibernateSession: HibernateSession: isNew: true, isReadonly: 
true, grouperTransactionType: READONLY_NEW
        at 
edu.internet2.middleware.grouper.hibernate.HibernateSession._internal_hibernateSessionCatch(HibernateSession.java:325)
        at 
edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:390)
        at 
edu.internet2.middleware.grouper.hibernate.ByHqlStatic.list(ByHqlStatic.java:253)
        at 
edu.internet2.middleware.grouper.hibernate.ByHqlStatic.listSet(ByHqlStatic.java:293)
        at 
edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MembershipDAO.findAllByOwnerAndMember(Hib3MembershipDAO.java:415)
        at 
edu.internet2.middleware.grouper.GrouperAccessAdapter.getPrivs(GrouperAccessAdapter.java:181)
        at 
edu.internet2.middleware.grouper.privs.AccessWrapper.getPrivileges(AccessWrapper.java:101)
        at 
edu.internet2.middleware.grouper.privs.GrouperAllAccessResolver.getPrivileges(GrouperAllAccessResolver.java:89)
        at 
edu.internet2.middleware.grouper.privs.GrouperSystemAccessResolver.getPrivileges(GrouperSystemAccessResolver.java:98)
        at 
edu.internet2.middleware.grouper.privs.CachingAccessResolver.getPrivileges(CachingAccessResolver.java:107)
        at 
edu.internet2.middleware.grouper.privs.CachingAccessResolver.hasPrivilege(CachingAccessResolver.java:176)
        at 
edu.internet2.middleware.grouper.privs.WheelAccessResolver.hasPrivilege(WheelAccessResolver.java:203)
        at 
edu.internet2.middleware.grouper.privs.ValidatingAccessResolver.hasPrivilege(ValidatingAccessResolver.java:117)
        at 
edu.internet2.middleware.grouper.privs.PrivilegeHelper.canView(PrivilegeHelper.java:170)
        at 
edu.internet2.middleware.grouper.privs.PrivilegeHelper.dispatch(PrivilegeHelper.java:287)
        at 
edu.internet2.middleware.grouper.Group._canReadField(Group.java:3188)
        at 
edu.internet2.middleware.grouper.Group.getAttributes(Group.java:1522)
        at 
edu.internet2.middleware.grouper.subj.GrouperSubject.<init>(GrouperSubject.java:68)
        at 
edu.internet2.middleware.grouper.GrouperSourceAdapter.getSubject(GrouperSourceAdapter.java:121)
        at 
edu.internet2.middleware.grouper.subj.SourcesXmlResolver.find(SourcesXmlResolver.java:131)
        at 
edu.internet2.middleware.grouper.subj.CachingResolver.find(CachingResolver.java:111)
        at 
edu.internet2.middleware.grouper.subj.ValidatingResolver.find(ValidatingResolver.java:94)
        at 
edu.internet2.middleware.grouper.SubjectFinder.findById(SubjectFinder.java:162)
        at 
edu.internet2.middleware.grouper.Group.toSubject(Group.java:3095)
         at 
edu.internet2.middleware.grouper.privs.GrouperPrivilegeAdapter$1.callback(GrouperPrivilegeAdapter.java:126)
        at 
edu.internet2.middleware.grouper.GrouperSession.callbackGrouperSession(GrouperSession.java:626)
        at 
edu.internet2.middleware.grouper.privs.GrouperPrivilegeAdapter.internal_getPrivs(GrouperPrivilegeAdapter.java:94)
        at 
edu.internet2.middleware.grouper.GrouperAccessAdapter.getPrivs(GrouperAccessAdapter.java:182)
        at 
edu.internet2.middleware.grouper.privs.AccessWrapper.getPrivileges(AccessWrapper.java:101)
        at 
edu.internet2.middleware.grouper.privs.GrouperAllAccessResolver.getPrivileges(GrouperAllAccessResolver.java:89)
        at 
edu.internet2.middleware.grouper.privs.GrouperSystemAccessResolver.getPrivileges(GrouperSystemAccessResolver.java:98)
        at 
edu.internet2.middleware.grouper.privs.CachingAccessResolver.getPrivileges(CachingAccessResolver.java:107)
        at 
edu.internet2.middleware.grouper.privs.CachingAccessResolver.hasPrivilege(CachingAccessResolver.java:176)
        at 
edu.internet2.middleware.grouper.privs.WheelAccessResolver.hasPrivilege(WheelAccessResolver.java:203)
        at 
edu.internet2.middleware.grouper.privs.ValidatingAccessResolver.hasPrivilege(ValidatingAccessResolver.java:117)
        at 
edu.internet2.middleware.grouper.privs.PrivilegeHelper.canView(PrivilegeHelper.java:170)
        at 
edu.internet2.middleware.grouper.privs.PrivilegeHelper.dispatch(PrivilegeHelper.java:287)
        at 
edu.internet2.middleware.grouper.Group._canReadField(Group.java:3188)
        at 
edu.internet2.middleware.grouper.Group.getAttributes(Group.java:1522)
        at 
edu.internet2.middleware.grouper.subj.GrouperSubject.<init>(GrouperSubject.java:68)
        at 
edu.internet2.middleware.grouper.GrouperSourceAdapter.getSubject(GrouperSourceAdapter.java:121)
        at 
edu.internet2.middleware.grouper.subj.SourcesXmlResolver.find(SourcesXmlResolver.java:131)
        at 
edu.internet2.middleware.grouper.subj.CachingResolver.find(CachingResolver.java:111)
        at 
edu.internet2.middleware.grouper.subj.ValidatingResolver.find(ValidatingResolver.java:94)
        at 
edu.internet2.middleware.grouper.SubjectFinder.findById(SubjectFinder.java:162)
        at 
edu.internet2.middleware.grouper.Group.toSubject(Group.java:3095)
        at 
edu.internet2.middleware.grouper.privs.GrouperPrivilegeAdapter$1.callback(GrouperPrivilegeAdapter.java:126)
        at 
edu.internet2.middleware.grouper.GrouperSession.callbackGrouperSession(GrouperSession.java:626)
        at 
edu.internet2.middleware.grouper.privs.GrouperPrivilegeAdapter.internal_getPrivs(GrouperPrivilegeAdapter.java:94)
        at 
edu.internet2.middleware.grouper.GrouperAccessAdapter.getPrivs(GrouperAccessAdapter.java:182)
        at 
edu.internet2.middleware.grouper.privs.AccessWrapper.getPrivileges(AccessWrapper.java:101)
        at 
edu.internet2.middleware.grouper.privs.GrouperAllAccessResolver.getPrivileges(GrouperAllAccessResolver.java:89)
        at 
edu.internet2.middleware.grouper.privs.GrouperSystemAccessResolver.getPrivileges(GrouperSystemAccessResolver.java:98)
        at 
edu.internet2.middleware.grouper.privs.CachingAccessResolver.getPrivileges(CachingAccessResolver.java:107)
        at 
edu.internet2.middleware.grouper.privs.CachingAccessResolver.hasPrivilege(CachingAccessResolver.java:176)
        at 
edu.internet2.middleware.grouper.privs.WheelAccessResolver.hasPrivilege(WheelAccessResolver.java:203)
        at 
edu.internet2.middleware.grouper.privs.ValidatingAccessResolver.hasPrivilege(ValidatingAccessResolver.java:117)
        at 
edu.internet2.middleware.grouper.privs.PrivilegeHelper.canView(PrivilegeHelper.java:170)
        at 
edu.internet2.middleware.grouper.privs.PrivilegeHelper.dispatch(PrivilegeHelper.java:287)
        at 
edu.internet2.middleware.grouper.Group._canReadField(Group.java:3188)
        at 
edu.internet2.middleware.grouper.Group.getAttributes(Group.java:1522)
        at 
edu.internet2.middleware.grouper.subj.GrouperSubject.<init>(GrouperSubject.java:68)
        at 
edu.internet2.middleware.grouper.GrouperSourceAdapter.getSubject(GrouperSourceAdapter.java:121)
        at 
edu.internet2.middleware.grouper.subj.SourcesXmlResolver.find(SourcesXmlResolver.java:131)
        at 
edu.internet2.middleware.grouper.subj.CachingResolver.find(CachingResolver.java:111)
......

Best regards and many thanks in advance for quick answers
Petra Schmitz

Attachment: smime.p7s
Description: S/MIME Cryptographic Signature