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: Rob Urquhart <>
  • To: Shilen Patel <>
  • Cc: "" <>
  • Subject: Re: [grouper-users] grouper 2.0.0 exception
  • Date: Thu, 18 Oct 2012 15:44:37 -0700

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().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
>>
>>
>>
>>
>>
>>
>

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