Skip to Content.
Sympa Menu

grouper-users - RE: [grouper-users] grouper 2.0.0 exception

Subject: Grouper Users - Open Discussion List

List archive

RE: [grouper-users] grouper 2.0.0 exception


Chronological Thread 
  • From: Gagné Sébastien <>
  • To: "Rob Urquhart" <>, "Shilen Patel" <>
  • Cc: <>
  • Subject: RE: [grouper-users] grouper 2.0.0 exception
  • Date: Fri, 19 Oct 2012 08:29:49 -0400

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









Archive powered by MHonArc 2.6.16.

Top of Page