Grouper Users - Open Discussion List

[Gagné Sébastien <>]

Could it be possible that you have two Grouper Loader daemon running at the 
same time on different or same machine?


-----Message d'origine-----
De : 

 
[mailto:]
 De la part de Rob Urquhart
Envoyé : 18 octobre 2012 18:45
À : Shilen Patel
Cc : 

Objet : Re: [grouper-users] grouper 2.0.0 exception

I ran the command and it looks like it didn't find any problems. All the 
search results were like "Found 0 missing active point in time x" or "Found 0 
active point in time x that should be inactive". And I'm still getting the 
same error as before.

Rob

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

> 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().syncAllPITTabl
>>> es()
>>> 
>>> 
>> 
>> 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._intern
>>>> al_hi
>>>> be
>>>> rnateSessionCatch(HibernateSession.java:424)
>>>>    at
>>>> 
>>>> edu.internet2.middleware.grouper.hibernate.HibernateSession.callbac
>>>> kHibe
>>>> rn
>>>> ateSession(HibernateSession.java:510)
>>>>    at
>>>> 
>>>> edu.internet2.middleware.grouper.hibernate.ByObjectStatic.saveOrUpd
>>>> ate(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(PITMembersh
>>>> ip.ja
>>>> va
>>>> :332)
>>>>    at
>>>> 
>>>> edu.internet2.middleware.grouper.changeLog.ChangeLogTempToEntity.pr
>>>> ocess
>>>> Me
>>>> mbershipAdd(ChangeLogTempToEntity.java:599)
>>>>    at
>>>> 
>>>> edu.internet2.middleware.grouper.changeLog.ChangeLogTempToEntity.ac
>>>> cess$
>>>> 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.callbac
>>>> kHibe
>>>> rn
>>>> ateSession(HibernateSession.java:500)
>>>>    at
>>>> 
>>>> edu.internet2.middleware.grouper.changeLog.ChangeLogTempToEntity.co
>>>> nvert
>>>> Re
>>>> cords(ChangeLogTempToEntity.java:75)
>>>>    at
>>>> 
>>>> edu.internet2.middleware.grouper.app.loader.GrouperLoaderType$4.run
>>>> Job(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.execut
>>>> e(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.jav
>>>> a: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.performExecut
>>>> ions(
>>>> Ab
>>>> stractFlushingEventListener.java:298)
>>>>    at
>>>> 
>>>> org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFl
>>>> ushEv
>>>> en
>>>> tListener.java:27)
>>>>    at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
>>>>    at
>>>> 
>>>> edu.internet2.middleware.grouper.hibernate.ByObject.saveOrUpdate(By
>>>> Objec
>>>> t.
>>>> java:362)
>>>>    at
>>>> 
>>>> edu.internet2.middleware.grouper.hibernate.ByObjectStatic$5.callbac
>>>> k(ByO
>>>> bj
>>>> ectStatic.java:352)
>>>>    at
>>>> 
>>>> edu.internet2.middleware.grouper.hibernate.HibernateSession.callbac
>>>> kHibe
>>>> 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.jav
>>>> a:108
>>>> 5)
>>>>    at
>>>> 
>>>> com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(New
>>>> Proxy
>>>> Pr
>>>> eparedStatement.java:1723)
>>>>    at
>>>> 
>>>> org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.j
>>>> ava:4
>>>> 8)
>>>>    at
>>>> 
>>>> org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.jav
>>>> a: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
>> 
>> 
>> 
>> 
>> 
>> 
> 

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