Grouper Users - Open Discussion List

[Rob Urquhart <>]

On 2012-10-18, at 9:41 AM, Shilen Patel wrote:

> It looks like a group didn't get added to point in time.  Is it possible
> that some entries from the temp change log were deleted at some point?

I guess it's possible. Unfortunately I didn't notice right away so I'll have 
to dig through some log files to try and figure out what happened.

> You should be able to resync by running the following using GSH:
> 
> new 
> edu.internet2.middleware.grouper.misc.SyncPITTables().syncAllPITTables()
> 
> 

Ok. That's two separate commands?
Also, I'm running the loader using javawrapper. Should I turn that off when I 
run this?

Thanks for your help!

Rob

> 
> Thanks!
> 
> -- Shilen
> 
> On 10/18/12 12:09 PM, "Rob Urquhart" 
> <>
>  wrote:
> 
>> I've been running grouper 2.0.0 for about 8 months, and suddenly started
>> getting the error below. All the CHANGE_LOG_changeLogTempToChangeLog jobs
>> are failing with this error. Any idea how to fix this?
>> 
>> 2012-10-18 08:56:50,134: [DefaultQuartzScheduler_Worker-3] ERROR
>> GrouperLoaderJob.execute(250) -  - Error running up job
>> edu.internet2.middleware.grouper.internal.dao.GrouperDAOException:
>> Problem in HibernateSession: HibernateSession: isNew: false, isReadonly:
>> false, grouperTransactionType: READ_WRITE_NEW,
>> Exception in saveOrUpdate:
>> edu.internet2.middleware.grouper.pit.PITMembership, ByObjectStatic,
>> query: ', cacheable: null, cacheRegion: null, entityName: null, tx type:
>> null,
>> Problem in HibernateSession: HibernateSession: isNew: true, isReadonly:
>> false, grouperTransactionType: READ_WRITE_NEW
>>      at 
>> edu.internet2.middleware.grouper.hibernate.HibernateSession._internal_hibe
>> rnateSessionCatch(HibernateSession.java:424)
>>      at 
>> edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibern
>> ateSession(HibernateSession.java:510)
>>      at 
>> edu.internet2.middleware.grouper.hibernate.ByObjectStatic.saveOrUpdate(ByO
>> bjectStatic.java:339)
>>      at 
>> edu.internet2.middleware.grouper.internal.dao.hib3.Hib3PITMembershipDAO.sa
>> veOrUpdate(Hib3PITMembershipDAO.java:26)
>>      at 
>> edu.internet2.middleware.grouper.pit.PITMembership.save(PITMembership.java
>> :332)
>>      at 
>> edu.internet2.middleware.grouper.changeLog.ChangeLogTempToEntity.processMe
>> mbershipAdd(ChangeLogTempToEntity.java:599)
>>      at 
>> edu.internet2.middleware.grouper.changeLog.ChangeLogTempToEntity.access$17
>> 00(ChangeLogTempToEntity.java:43)
>>      at 
>> edu.internet2.middleware.grouper.changeLog.ChangeLogTempToEntity$1.callbac
>> k(ChangeLogTempToEntity.java:116)
>>      at 
>> edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibern
>> ateSession(HibernateSession.java:500)
>>      at 
>> edu.internet2.middleware.grouper.changeLog.ChangeLogTempToEntity.convertRe
>> cords(ChangeLogTempToEntity.java:75)
>>      at 
>> edu.internet2.middleware.grouper.app.loader.GrouperLoaderType$4.runJob(Gro
>> uperLoaderType.java:826)
>>      at 
>> edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob.runJob(Groupe
>> rLoaderJob.java:344)
>>      at 
>> edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob.execute(Group
>> erLoaderJob.java:247)
>>      at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
>>      at 
>> org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:5
>> 29)
>> Caused by: org.hibernate.exception.ConstraintViolationException: Could
>> not execute JDBC batch update,
>> Exception in save: edu.internet2.middleware.grouper.pit.PITMembership,
>> edu.internet2.middleware.grouper.hibernate.ByObject@53843546
>>      at 
>> org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:7
>> 1)
>>      at 
>> org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.ja
>> va:43)
>>      at 
>> org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
>>      at 
>> org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)
>>      at 
>> org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
>>      at 
>> org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(Ab
>> stractFlushingEventListener.java:298)
>>      at 
>> org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEven
>> tListener.java:27)
>>      at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
>>      at 
>> edu.internet2.middleware.grouper.hibernate.ByObject.saveOrUpdate(ByObject.
>> java:362)
>>      at 
>> edu.internet2.middleware.grouper.hibernate.ByObjectStatic$5.callback(ByObj
>> ectStatic.java:352)
>>      at 
>> edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibern
>> ateSession(HibernateSession.java:500)
>>      ... 13 more
>> Caused by: java.sql.BatchUpdateException: Cannot add or update a child
>> row: a foreign key constraint fails
>> (`groups_registry`.`grouper_pit_memberships`, CONSTRAINT
>> `fk_pit_ms_owner_group_id` FOREIGN KEY (`owner_group_id`) REFERENCES
>> `grouper_pit_groups` (`id`))
>>      at 
>> com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.ja
>> va:1669)
>>      at 
>> com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1085)
>>      at 
>> com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPr
>> eparedStatement.java:1723)
>>      at 
>> org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
>>      at 
>> org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
>>      ... 21 more
>> 
>> 
>> 
>> --
>> Rob Urquhart 
>> Institutional, Collaborative, and Academic Technologies (ICAT)
>> IT Services
>> Simon Fraser University
>> 778-782-3650
>> 
>> 
>> 
>> 
>> 
>> 
> 

--
Rob Urquhart 
Institutional, Collaborative, and Academic Technologies (ICAT)
IT Services
Simon Fraser University
778-782-3650