Grouper Users - Open Discussion List

[Chris Hyzer <>]

Can you send me more logs?

When I google this "An I/O error occured while sending to the backend."  It 
suggests either:

1. Connections in the pool are getting closed (I hope not)
2. Firewall might be getting restarted or dropping open connections that are 
idle too long
3. Database was restarted

Might want to upgrade the postgres driver jar if it is not the latest.

Do these queries return one row?

select * from grouper_members as m 
where m.subject_id = 'GrouperAll'
and m.subject_source = 'g:isa'
and  m.subject_type   = 'application'

select * from grouper_groups as g where g.id = 
'9a229a6c-6f22-44be-8588-214e10ebbc09'

Thanks,
Chris

> -----Original Message-----
> From: Petra Schmitz 
> [mailto:]
> Sent: Tuesday, April 28, 2009 5:08 PM
> To: 
> ;
>  
> 
> Subject: [grouper-dev] Problem since upgrade to 1.4.1
> 
> 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.FindBy
> Subject,
> 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_h
> ibernateSessionCatch(HibernateSession.java:325)
>          at
> edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHib
> ernateSession(HibernateSession.java:390)
>          at
> edu.internet2.middleware.grouper.hibernate.ByHqlStatic.list(ByHqlStatic
> .java:253)
>          at
> edu.internet2.middleware.grouper.hibernate.ByHqlStatic.listSet(ByHqlSta
> tic.java:293)
>          at
> edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MembershipDAO.fi
> ndAllByOwnerAndMember(Hib3MembershipDAO.java:415)
>          at
> edu.internet2.middleware.grouper.GrouperAccessAdapter.getPrivs(GrouperA
> ccessAdapter.java:181)
>          at
> edu.internet2.middleware.grouper.privs.AccessWrapper.getPrivileges(Acce
> ssWrapper.java:101)
>          at
> edu.internet2.middleware.grouper.privs.GrouperAllAccessResolver.getPriv
> ileges(GrouperAllAccessResolver.java:89)
>          at
> edu.internet2.middleware.grouper.privs.GrouperSystemAccessResolver.getP
> rivileges(GrouperSystemAccessResolver.java:98)
>          at
> edu.internet2.middleware.grouper.privs.CachingAccessResolver.getPrivile
> ges(CachingAccessResolver.java:107)
>          at
> edu.internet2.middleware.grouper.privs.CachingAccessResolver.hasPrivile
> ge(CachingAccessResolver.java:176)
>          at
> edu.internet2.middleware.grouper.privs.WheelAccessResolver.hasPrivilege
> (WheelAccessResolver.java:203)
>          at
> edu.internet2.middleware.grouper.privs.ValidatingAccessResolver.hasPriv
> ilege(ValidatingAccessResolver.java:117)
>          at
> edu.internet2.middleware.grouper.privs.PrivilegeHelper.canView(Privileg
> eHelper.java:170)
>          at
> edu.internet2.middleware.grouper.privs.PrivilegeHelper.dispatch(Privile
> geHelper.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>(GrouperSubj
> ect.java:68)
>          at
> edu.internet2.middleware.grouper.GrouperSourceAdapter.getSubject(Groupe
> rSourceAdapter.java:121)
>          at
> edu.internet2.middleware.grouper.subj.SourcesXmlResolver.find(SourcesXm
> lResolver.java:131)
>          at
> edu.internet2.middleware.grouper.subj.CachingResolver.find(CachingResol
> ver.java:111)
>          at
> edu.internet2.middleware.grouper.subj.ValidatingResolver.find(Validatin
> gResolver.java:94)
>          at
> edu.internet2.middleware.grouper.SubjectFinder.findById(SubjectFinder.j
> ava:162)
>          at
> edu.internet2.middleware.grouper.Group.toSubject(Group.java:3095)
>           at
> edu.internet2.middleware.grouper.privs.GrouperPrivilegeAdapter$1.callba
> ck(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(GrouperA
> ccessAdapter.java:182)
>          at
> edu.internet2.middleware.grouper.privs.AccessWrapper.getPrivileges(Acce
> ssWrapper.java:101)
>          at
> edu.internet2.middleware.grouper.privs.GrouperAllAccessResolver.getPriv
> ileges(GrouperAllAccessResolver.java:89)
>          at
> edu.internet2.middleware.grouper.privs.GrouperSystemAccessResolver.getP
> rivileges(GrouperSystemAccessResolver.java:98)
>          at
> edu.internet2.middleware.grouper.privs.CachingAccessResolver.getPrivile
> ges(CachingAccessResolver.java:107)
>          at
> edu.internet2.middleware.grouper.privs.CachingAccessResolver.hasPrivile
> ge(CachingAccessResolver.java:176)
>          at
> edu.internet2.middleware.grouper.privs.WheelAccessResolver.hasPrivilege
> (WheelAccessResolver.java:203)
>          at
> edu.internet2.middleware.grouper.privs.ValidatingAccessResolver.hasPriv
> ilege(ValidatingAccessResolver.java:117)
>          at
> edu.internet2.middleware.grouper.privs.PrivilegeHelper.canView(Privileg
> eHelper.java:170)
>          at
> edu.internet2.middleware.grouper.privs.PrivilegeHelper.dispatch(Privile
> geHelper.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>(GrouperSubj
> ect.java:68)
>          at
> edu.internet2.middleware.grouper.GrouperSourceAdapter.getSubject(Groupe
> rSourceAdapter.java:121)
>          at
> edu.internet2.middleware.grouper.subj.SourcesXmlResolver.find(SourcesXm
> lResolver.java:131)
>          at
> edu.internet2.middleware.grouper.subj.CachingResolver.find(CachingResol
> ver.java:111)
>          at
> edu.internet2.middleware.grouper.subj.ValidatingResolver.find(Validatin
> gResolver.java:94)
>          at
> edu.internet2.middleware.grouper.SubjectFinder.findById(SubjectFinder.j
> ava:162)
>          at
> edu.internet2.middleware.grouper.Group.toSubject(Group.java:3095)
>          at
> edu.internet2.middleware.grouper.privs.GrouperPrivilegeAdapter$1.callba
> ck(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(GrouperA
> ccessAdapter.java:182)
>          at
> edu.internet2.middleware.grouper.privs.AccessWrapper.getPrivileges(Acce
> ssWrapper.java:101)
>          at
> edu.internet2.middleware.grouper.privs.GrouperAllAccessResolver.getPriv
> ileges(GrouperAllAccessResolver.java:89)
>          at
> edu.internet2.middleware.grouper.privs.GrouperSystemAccessResolver.getP
> rivileges(GrouperSystemAccessResolver.java:98)
>          at
> edu.internet2.middleware.grouper.privs.CachingAccessResolver.getPrivile
> ges(CachingAccessResolver.java:107)
>          at
> edu.internet2.middleware.grouper.privs.CachingAccessResolver.hasPrivile
> ge(CachingAccessResolver.java:176)
>          at
> edu.internet2.middleware.grouper.privs.WheelAccessResolver.hasPrivilege
> (WheelAccessResolver.java:203)
>          at
> edu.internet2.middleware.grouper.privs.ValidatingAccessResolver.hasPriv
> ilege(ValidatingAccessResolver.java:117)
>          at
> edu.internet2.middleware.grouper.privs.PrivilegeHelper.canView(Privileg
> eHelper.java:170)
>          at
> edu.internet2.middleware.grouper.privs.PrivilegeHelper.dispatch(Privile
> geHelper.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>(GrouperSubj
> ect.java:68)
>          at
> edu.internet2.middleware.grouper.GrouperSourceAdapter.getSubject(Groupe
> rSourceAdapter.java:121)
>          at
> edu.internet2.middleware.grouper.subj.SourcesXmlResolver.find(SourcesXm
> lResolver.java:131)
>          at
> edu.internet2.middleware.grouper.subj.CachingResolver.find(CachingResol
> ver.java:111)
> ......
> 
> Best regards and many thanks in advance for quick answers
> Petra Schmitz