Grouper Users - Open Discussion List

[Shilen Patel <>]

Yeah it would be good to turn off the loader.  And that command is one
line.

Thanks!

-- Shilen

On 10/18/12 12:49 PM, "Rob Urquhart" 
<>
 wrote:

>
>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_hi
>>>be
>>> rnateSessionCatch(HibernateSession.java:424)
>>>     at 
>>> 
>>>edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibe
>>>rn
>>> ateSession(HibernateSession.java:510)
>>>     at 
>>> 
>>>edu.internet2.middleware.grouper.hibernate.ByObjectStatic.saveOrUpdate(B
>>>yO
>>> 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.ja
>>>va
>>> :332)
>>>     at 
>>> 
>>>edu.internet2.middleware.grouper.changeLog.ChangeLogTempToEntity.process
>>>Me
>>> 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.callb
>>>ac
>>> k(ChangeLogTempToEntity.java:116)
>>>     at 
>>> 
>>>edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibe
>>>rn
>>> ateSession(HibernateSession.java:500)
>>>     at 
>>> 
>>>edu.internet2.middleware.grouper.changeLog.ChangeLogTempToEntity.convert
>>>Re
>>> cords(ChangeLogTempToEntity.java:75)
>>>     at 
>>> 
>>>edu.internet2.middleware.grouper.app.loader.GrouperLoaderType$4.runJob(G
>>>ro
>>> uperLoaderType.java:826)
>>>     at 
>>> 
>>>edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob.runJob(Grou
>>>pe
>>> rLoaderJob.java:344)
>>>     at 
>>> 
>>>edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob.execute(Gro
>>>up
>>> 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(DefaultFlushEv
>>>en
>>> tListener.java:27)
>>>     at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
>>>     at 
>>> 
>>>edu.internet2.middleware.grouper.hibernate.ByObject.saveOrUpdate(ByObjec
>>>t.
>>> java:362)
>>>     at 
>>> 
>>>edu.internet2.middleware.grouper.hibernate.ByObjectStatic$5.callback(ByO
>>>bj
>>> ectStatic.java:352)
>>>     at 
>>> 
>>>edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibe
>>>rn
>>> 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:108
>>>5)
>>>     at 
>>> 
>>>com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxy
>>>Pr
>>> eparedStatement.java:1723)
>>>     at 
>>> 
>>>org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:4
>>>8)
>>>     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
>
>
>
>
>
>