Grouper Users - Open Discussion List

[Chris Hyzer <>]

What type of DB are you using?  Is it under real load or a load test?  If load test is it a web based test or a command line test?  What type of operations (if load test) are running and what is the load?  I hope I can reproduce it locally to have a chance at reproducing it.  When this was raised before we decided to upgrade hibernate in 2.1, when that is stable (in a few weeks) do you think you could try it in your env to see if it fixes the problem?

 

Thanks,

Chris

 

From: [mailto:] On Behalf Of Stephen Langella
Sent: Tuesday, February 07, 2012 2:51 PM
To:
Subject: [grouper-users] Grouper Issues Under Load

 

All,

 

            We are getting the following exception very consistently when grouper is under load.   We are using Grouper 2.0.3, we also get the exception when using Grouper 1.6.3.  Any help or guidance would be appreciated.    

 

Caused by: com.inventrio.common.exceptions.SystemException: possible non-threadsafe access to the session,

Problem in HibernateSession: HibernateSession: isNew: true, isReadonly: true, grouperTransactionType: READONLY_NEW,

Exception in list: (class [Ljava.lang.Object;), ByHqlStatic, query: 'select distinct ms, m from MembershipEntry as ms, Member as m, Field as field where       ms.ownerGroupId   = :owner            and  ms.memberUuid  = :member           and  ms.fieldId = :fuuid and  ms.memberUuid  = m.uuid     and ms.enabledDb = 'T'', cacheable: true, cacheRegion: edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MembershipDAO, tx type: null, tx type: nullBind var[0]: 'Param (class java.lang.String): 'owner'->'d3f8f7585fd44276abb84a736bde227a', Bind var[1]: 'Param (class java.lang.String): 'member'->'6e74b5119d6f471dbd104758f05ab0c3'Bind var[2]: 'Param (class java.lang.String): 'fuuid'->'46c42d89206b4718b1938e72c278e5df', 

            at com.inventrio.group.service.core.GroupService.isMemberOf(GroupService.java:863)

            at sun.reflect.GeneratedMethodAccessor662.invoke(Unknown Source)

            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

            at java.lang.reflect.Method.invoke(Method.java:597)

            at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)

            at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)

            at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)

            at org.springframework.osgi.service.util.internal.aop.ServiceTCCLInterceptor.invokeUnprivileged(ServiceTCCLInterceptor.java:56)

            at org.springframework.osgi.service.util.internal.aop.ServiceTCCLInterceptor.invoke(ServiceTCCLInterceptor.java:39)

            at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

            at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)

            at $Proxy277.isMemberOf(Unknown Source)

            at com.inventrio.group.client.GroupClient$20.run(GroupClient.java:538)

            at com.inventrio.group.client.GroupClient$20.run(GroupClient.java:535)

            at java.security.AccessController.doPrivileged(Native Method)

            at javax.security.auth.Subject.doAs(Subject.java:396)

            at com.inventrio.group.client.GroupClient.isMemberOf(GroupClient.java:535)

            at com.inventrio.group.client.Group.isMemberOf(Group.java:147)

            at com.inventrio.itest.vcms.scenarios.AddAccountManagerScenario.addAccountManager(AddAccountManagerScenario.java:77)

            ... 9 more

Caused by: org.hibernate.AssertionFailure: possible non-threadsafe access to the session,

Problem in HibernateSession: HibernateSession: isNew: true, isReadonly: true, grouperTransactionType: READONLY_NEW,

Exception in list: (class [Ljava.lang.Object;), ByHqlStatic, query: 'select distinct ms, m from MembershipEntry as ms, Member as m, Field as field where       ms.ownerGroupId   = :owner            and  ms.memberUuid  = :member           and  ms.fieldId = :fuuid and  ms.memberUuid  = m.uuid     and ms.enabledDb = 'T'', cacheable: true, cacheRegion: edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MembershipDAO, tx type: null, tx type: nullBind var[0]: 'Param (class java.lang.String): 'owner'->'d3f8f7585fd44276abb84a736bde227a', Bind var[1]: 'Param (class java.lang.String): 'member'->'6e74b5119d6f471dbd104758f05ab0c3'Bind var[2]: 'Param (class java.lang.String): 'fuuid'->'46c42d89206b4718b1938e72c278e5df', 

            at org.hibernate.engine.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:123)

            at org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:877)

            at org.hibernate.loader.Loader.doQuery(Loader.java:752)

            at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)

            at org.hibernate.loader.Loader.doList(Loader.java:2228)

            at org.hibernate.loader.Loader.listUsingQueryCache(Loader.java:2157)

            at org.hibernate.loader.Loader.list(Loader.java:2117)

            at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401)

            at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:361)

            at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)

            at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1148)

            at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)

            at edu.internet2.middleware.grouper.hibernate.ByHql.list(ByHql.java:303)

            at edu.internet2.middleware.grouper.hibernate.ByHqlStatic$2.callback(ByHqlStatic.java:356)

            at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:500)

            at edu.internet2.middleware.grouper.hibernate.ByHqlStatic.list(ByHqlStatic.java:346)

            at edu.internet2.middleware.grouper.hibernate.ByHqlStatic.listSet(ByHqlStatic.java:395)

            at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MembershipDAO.findAllByGroupOwnerAndMemberAndField(Hib3MembershipDAO.java:417)

            at edu.internet2.middleware.grouper.Member.isMember(Member.java:2482)

            at edu.internet2.middleware.grouper.Member.isMember(Member.java:2328)

            at edu.internet2.middleware.grouper.Group.hasMember(Group.java:3863)

            at edu.internet2.middleware.grouper.Group.hasMember(Group.java:3829)

            at com.inventrio.group.service.core.GroupService.isMemberOf(GroupService.java:852)

            ... 27 more

 

 

--Steve

 

 

Stephen Langella

Inventrio

545 Metro Place South, Suite 475

Dublin OH 43017

(614) 389-2795 ext. 102