Grouper Users - Open Discussion List

["Zhang, Xiaoling" <>]

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