Grouper Users - Open Discussion List

[Shilen Patel <>]

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?
You should be able to resync by running the following using GSH:

new 
edu.internet2.middleware.grouper.misc.SyncPITTables().syncAllPITTables()



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
>
>
>
>
>
>