Grouper Users - Open Discussion List

[Killian Stone <>]

I have seen a similar problem happen when sticky sessions on a webserver and additions to a group are being made. It seems to happen when a member is being added to groups on multiple nodes at the same time. One of the transactions gets rolled back when inserting into the PIT table. At least, that is one of the theories but I haven't had time to confirm it. Temporarily using only one node confirmed the problem is at least similar to the theory.

Since this is a dev instance it is likely that syncing the PIT table once will fix the problem. If it happens again it may be something else. 

--

Killian Stone

Application Developer

Office of Mediated Education

Kansas State University

| 785-532-4353

---

From: <> on behalf of Shilen Patel <>
Sent: Tuesday, February 7, 2017 8:27:57 AM
To: Scott Koranda
Cc: grouper-users
Subject: Re: [grouper-users] Active PITMember with sourceId= not found

 

This would happen if previously the grouper_pit_members table got out of sync.  Maybe the temp change log was truncated at some point?

In any case, to fix this via gsh:

gsh 0% new edu.internet2.middleware.grouper.misc.SyncPITTables().processMissingActivePITMembers()

Thanks!

- Shilen

On 2/7/17, 7:05 AM, "Scott Koranda" <> wrote:

Hello,

In a Grouper 2.3 dev instance that is fully patched as of this

morning, the CHANGE_LOG_changeLogTempToChangeLog job is

causing this to be thrown:

2017-02-07 07:00:57,876: [main] ERROR GrouperLoaderJob.runJob(438) -  - Error on

job: CHANGE_LOG_changeLogTempToChangeLog

java.lang.RuntimeException: Active PITMember with sourceId=a0790a8de6264eb796995

a86024bc0fa not found,

Problem in HibernateSession: HibernateSession (6e44a05e): new, notReadonly, READ

_WRITE_NEW, notActiveTransaction, session (75e17490)

        at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3PITMemberDAO.f

indBySourceIdActive(Hib3PITMemberDAO.java:78)

        at edu.internet2.middleware.grouper.changeLog.ChangeLogTempToEntity.proc

essMembershipAdd(ChangeLogTempToEntity.java:836)

        at edu.internet2.middleware.grouper.changeLog.ChangeLogTempToEntity.acce

ss$1700(ChangeLogTempToEntity.java:63)

        at edu.internet2.middleware.grouper.changeLog.ChangeLogTempToEntity$1.ca

llback(ChangeLogTempToEntity.java:144)

at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackH

ibernateSession(HibernateSession.java:700)

        at edu.internet2.middleware.grouper.changeLog.ChangeLogTempToEntity.convertRecords(ChangeLogTempToEntity.java:100)

        at edu.internet2.middleware.grouper.app.loader.GrouperLoaderType$4.runJob(GrouperLoaderType.java:613)

        at edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob.runJob(GrouperLoaderJob.java:418)

        at edu.internet2.middleware.grouper.app.loader.GrouperLoader.runOnceByJobName(GrouperLoader.java:1573)

        at edu.internet2.middleware.grouper.app.gsh.loaderRunOneJob.invoke(loaderRunOneJob.java:79)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

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

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

        at bsh.Reflect.invokeMethod(Unknown Source)

at bsh.Reflect.invokeStaticMethod(Unknown Source)

        at bsh.Reflect.invokeCompiledCommand(Unknown Source)

        at bsh.Name.invokeLocalMethod(Unknown Source)

        at bsh.Name.invokeMethod(Unknown Source)

        at bsh.BSHMethodInvocation.eval(Unknown Source)

        at bsh.BSHPrimaryExpression.eval(Unknown Source)

        at bsh.BSHPrimaryExpression.eval(Unknown Source)

        at bsh.Interpreter.eval(Unknown Source)

        at bsh.Interpreter.eval(Unknown Source)

        at bsh.Interpreter.eval(Unknown Source)

        at edu.internet2.middleware.grouper.app.gsh.ShellHelper.eval(ShellHelper.java:63)

        at edu.internet2.middleware.grouper.app.gsh.GrouperShell.run(GrouperShell.java:440)

        at edu.internet2.middleware.grouper.app.gsh.GrouperShell.grouperShellHelper(GrouperShell.java:232)

        at edu.internet2.middleware.grouper.app.gsh.GrouperShell.main(GrouperShell.java:162)

        at edu.internet2.middleware.grouper.app.gsh.GrouperShellWrapper.main(Gro

at edu.internet2.middleware.grouper.app.gsh.GrouperShellWrapper.main(GrouperShellWrapper.java:31)

Thoughts?

Thanks,

Scott K