Grouper Users - Open Discussion List

[Shilen Patel <>]

The sync showed that members weren’t missing because they were presumably in your temp change log.  In other words, it doesn’t try to fix something that should be in the process of being handled correctly.  The issue was that your temp change log wasn’t ordered correctly (possibly due to server time issues?).  Patch #74 handles that problem.

 

Thanks!

 

- Shilen

 

From: <> on behalf of "Zhang, Xiaoling" <>
Date: Thursday, April 19, 2018 at 6:56 PM
To: "" <>
Subject: Re: [grouper-users] Active PITMember with sourceId= not found

 

Hi,

 

Quick update: the issue has been fixed by creating view GROUPER_CHANGE_LOG_TEMP_V and following the steps documented at https://spaces.internet2.edu/display/Grouper/Change+log+and+point+in+time+ordering+issue.

 

We still have a question though. The output of commands loaderRunOneJob("CHANGE_LOG_changeLogTempToChangeLog") and new edu.internet2.middleware.grouper.misc.SyncPITTables().syncAllPITTables() shows no missing members. When we queried the tables, we found some members missing in PIT_MEMBERS. Why didn’t command syncAllPITTables() find the missing members?

 

Thanks,

Xiaoling Zhang

UCLA

 

 

From: <> on behalf of "Zhang, Xiaoling" <>
Date: Thursday, April 19, 2018 at 1:27 PM
To: "" <>
Subject: [grouper-users] Active PITMember with sourceId= not found

 

Hi,

 

In our production Grouper instance, provisioning suddenly stopped this morning. The error is:

 

2018-04-19 11:58:50,471: [DefaultQuartzScheduler_Worker-3] ERROR GrouperLoaderJob.execute(318) -  - Error running up job

java.lang.RuntimeException: Active PITMember with sourceId=849415baf08f4813b65e5f86e28f53de not found,

Problem in HibernateSession: HibernateSession: isNew: true, isReadonly: false, grouperTransactionType: READ_WRITE_NEW

 

Per thread https://lists.internet2.edu/sympa/arc/grouper-users/2017-02/msg00008.html, we ran loaderRunOneJob("CHANGE_LOG_changeLogTempToChangeLog") and new edu.internet2.middleware.grouper.misc.SyncPITTables().syncAllPITTables(). After grouperLoader was restarted, the error didn’t go away.

 

Below is the output of loaderRunOneJob and syncAllPITTables:

 

 

gsh 0% loaderRunOneJob("CHANGE_LOG_changeLogTempToChangeLog")

// Error: unable to evaluate command: Sourced file: inline evaluation of: ``loaderRunOneJob("CHANGE_LOG_changeLogTempToChangeLog");'' : Error invoking compiled command: : Error in compiled command: java.lang.RuntimeException: java.lang.RuntimeException: Active PITMember with sourceId=849415baf08f4813b65e5f86e28f53de not found,

Problem in HibernateSession: HibernateSession: isNew: true, isReadonly: false, grouperTransactionType: READ_WRITE_NEW

gsh 1% try { new edu.internet2.middleware.grouper.misc.SyncPITTables().syncAllPITTables(); } catch (Exception e) { e.printStackTrace(); }

Number of entries in grouper_change_log_entry_temp: 2684

For best results, run loaderRunOneJob("CHANGE_LOG_changeLogTempToChangeLog") first.

 

Searching for missing active point in time fields

Found 0 missing active point in time fields

 

Searching for missing active point in time members

Found 0 missing active point in time members

 

Searching for missing active point in time stems

Found 0 missing active point in time stems

 

Searching for missing active point in time groups

Found 0 missing active point in time groups

 

Searching for missing active point in time role sets

Found 0 missing active point in time role sets

 

Searching for missing active point in time attribute defs

Found 0 missing active point in time attribute defs

 

Searching for missing active point in time attribute def names

Found 0 missing active point in time attribute def names

 

Searching for missing active point in time attribute def name sets

Found 0 missing active point in time attribute def name sets

 

Searching for missing active point in time actions

Found 0 missing active point in time actions

 

Searching for missing active point in time action sets

Found 0 missing active point in time action sets

 

Searching for missing active point in time group sets

Found 0 missing active point in time group sets

 

Searching for missing active point in time memberships

Found 0 missing active point in time memberships

 

Searching for missing active point in time group sets (second pass)

Found 0 missing active point in time group sets

 

Searching for missing active point in time attribute assigns

Found 0 missing active point in time attribute assigns

 

Searching for missing active point in time attribute assign values

Found 0 missing active point in time attribute assign values

 

Searching for point in time attribute assign values that should be inactive

Found 0 active point in time attribute assign values that should be inactive

 

Searching for point in time attribute assigns that should be inactive

Found 0 active point in time attribute assigns that should be inactive

 

Searching for point in time memberships that should be inactive

Found 0 active point in time memberships that should be inactive

 

Searching for point in time group sets that should be inactive

Found 0 active point in time group sets that should be inactive

 

Searching for point in time action sets that should be inactive

Found 0 active point in time action sets that should be inactive

 

Searching for point in time actions that should be inactive

Found 0 active point in time actions that should be inactive

 

Searching for point in time attribute def name sets that should be inactive

Found 0 active point in time attribute def name sets that should be inactive

 

Searching for point in time attribute def names that should be inactive

Found 0 active point in time attribute def names that should be inactive

 

Searching for point in time attribute defs that should be inactive

Found 0 active point in time attribute defs that should be inactive

 

Searching for point in time role sets that should be inactive

Found 0 active point in time role sets that should be inactive

 

Searching for point in time groups that should be inactive

Found 0 active point in time groups that should be inactive

 

Searching for point in time stems that should be inactive

Found 0 active point in time stems that should be inactive

 

Searching for point in time members that should be inactive

Found 0 active point in time members that should be inactive

 

Searching for point in time fields that should be inactive

Found 0 active point in time fields that should be inactive

 

Any thoughts are appreciated.

 

Thanks,

Xiaoling Zhang

UCLA