Grouper Users - Open Discussion List

[Shilen Patel <>]

Hi,

OK let's try to figure out what went wrong here.  First off all, what
database are you running and does it support transactions?  Have you used
the XML import/export or have you done any other partial database recovery
(particularly with the grouper_change_log_entry_temp table)?  Do you use
membership enable/disable?  What do the following queries give you back?


select source_id, count(*) from grouper_pit_memberships where active='T'
group by source_id having count(*) > 1;


select * from grouper_audit_entry_v where string06 in (
select pg.source_id from grouper_pit_memberships pm, grouper_pit_groups pg
where pm.owner_id=pg.id and
pm.source_id='fb686e35f40547948dbc3a860885bde2');



select * from grouper_pit_memberships where
source_id='fb686e35f40547948dbc3a860885bde2'


You can send the results off list and sanitize the data (subject ids) if
you want.

Thanks!

-- Shilen

On 10/31/12 6:39 AM, "Gasperowicz Jérémy"
<>
 wrote:

>Hi,
>
>I'm getting an error when I run the loader job and I don't know where
>may be the source of problem, why i'm having multiple result
>Here is the error :
>
>2012-10-30 16:03:50,058: [DefaultQuartzScheduler_Worker-6] ERROR
>GrouperLoaderJob.runJob(406) -  - Error on job:
>CHANGE_LOG_changeLogTempToChangeLog
>edu.internet2.middleware.grouper.internal.dao.GrouperDAOException:
>Problem in HibernateSession: HibernateSession: isNew: false, isReadonly:
>false, grouperTransactionType: READ_WRITE_NEW,
>Exception in uniqueResult: (class
>edu.internet2.middleware.grouper.pit.PITMembership), ByHqlStatic, query:
>'select pitMembership from PITMembership as pitMembership where
>pitMembership.sourceId = :id and activeDb = 'T'', cacheable: true,
>cacheRegion: 
>edu.internet2.middleware.grouper.internal.dao.hib3.Hib3PITMembershipDAO.Fi
>ndBySourceIdActive,
>tx type: null, tx type: nullBind var[0]: 'Param (class
>java.lang.String): 'id'->'fb686e35f40547948dbc3a860885bde2', ,
>Problem in HibernateSession: HibernateSession: isNew: true, isReadonly:
>false, grouperTransactionType: READ_WRITE_NEW
>     at 
>edu.internet2.middleware.grouper.hibernate.HibernateSession._internal_hibe
>rnateSessionCatch(HibernateSession.java:495)
>     at 
>edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibern
>ateSession(HibernateSession.java:581)
>     at 
>edu.internet2.middleware.grouper.hibernate.ByHqlStatic.uniqueResult(ByHqlS
>tatic.java:323)
>     at 
>edu.internet2.middleware.grouper.internal.dao.hib3.Hib3PITMembershipDAO.fi
>ndBySourceIdActive(Hib3PITMembershipDAO.java:70)
>     at 
>edu.internet2.middleware.grouper.changeLog.ChangeLogTempToEntity.processMe
>mbershipDelete(ChangeLogTempToEntity.java:744)
>     at 
>edu.internet2.middleware.grouper.changeLog.ChangeLogTempToEntity.access$18
>00(ChangeLogTempToEntity.java:59)
>     at 
>edu.internet2.middleware.grouper.changeLog.ChangeLogTempToEntity$1.callbac
>k(ChangeLogTempToEntity.java:137)
>     at 
>edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibern
>ateSession(HibernateSession.java:571)
>     at 
>edu.internet2.middleware.grouper.changeLog.ChangeLogTempToEntity.convertRe
>cords(ChangeLogTempToEntity.java:91)
>     at 
>edu.internet2.middleware.grouper.app.loader.GrouperLoaderType$4.runJob(Gro
>uperLoaderType.java:550)
>     at 
>edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob.runJob(Groupe
>rLoaderJob.java:398)
>     at 
>edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob.execute(Group
>erLoaderJob.java:300)
>     at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
>     at 
>org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:5
>29)
>Caused by: org.hibernate.NonUniqueResultException: query did not return
>a unique result: 2
>     at 
>org.hibernate.impl.AbstractQueryImpl.uniqueElement(AbstractQueryImpl.java:
>899)
>     at 
>org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:8
>90)
>     at 
>edu.internet2.middleware.grouper.hibernate.ByHql.uniqueResult(ByHql.java:2
>57)
>     at 
>edu.internet2.middleware.grouper.hibernate.ByHqlStatic$1.callback(ByHqlSta
>tic.java:332)
>     at 
>edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibern
>ateSession(HibernateSession.java:571)
>     ... 12 more
>2012-10-30 16:03:50,062: [DefaultQuartzScheduler_Worker-6] ERROR
>GrouperLoaderJob.execute(303) -  - 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 uniqueResult: (class
>edu.internet2.middleware.grouper.pit.PITMembership), ByHqlStatic, query:
>'select pitMembership from PITMembership as pitMembership where
>pitMembership.sourceId = :id and activeDb = 'T'', cacheable: true,
>cacheRegion: 
>edu.internet2.middleware.grouper.internal.dao.hib3.Hib3PITMembershipDAO.Fi
>ndBySourceIdActive,
>tx type: null, tx type: nullBind var[0]: 'Param (class
>java.lang.String): 'id'->'fb686e35f40547948dbc3a860885bde2', ,
>Problem in HibernateSession: HibernateSession: isNew: true, isReadonly:
>false, grouperTransactionType: READ_WRITE_NEW
>     at 
>edu.internet2.middleware.grouper.hibernate.HibernateSession._internal_hibe
>rnateSessionCatch(HibernateSession.java:495)
>     at 
>edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibern
>ateSession(HibernateSession.java:581)
>     at 
>edu.internet2.middleware.grouper.hibernate.ByHqlStatic.uniqueResult(ByHqlS
>tatic.java:323)
>     at 
>edu.internet2.middleware.grouper.internal.dao.hib3.Hib3PITMembershipDAO.fi
>ndBySourceIdActive(Hib3PITMembershipDAO.java:70)
>     at 
>edu.internet2.middleware.grouper.changeLog.ChangeLogTempToEntity.processMe
>mbershipDelete(ChangeLogTempToEntity.java:744)
>     at 
>edu.internet2.middleware.grouper.changeLog.ChangeLogTempToEntity.access$18
>00(ChangeLogTempToEntity.java:59)
>     at 
>edu.internet2.middleware.grouper.changeLog.ChangeLogTempToEntity$1.callbac
>k(ChangeLogTempToEntity.java:137)
>     at 
>edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibern
>ateSession(HibernateSession.java:571)
>     at 
>edu.internet2.middleware.grouper.changeLog.ChangeLogTempToEntity.convertRe
>cords(ChangeLogTempToEntity.java:91)
>     at 
>edu.internet2.middleware.grouper.app.loader.GrouperLoaderType$4.runJob(Gro
>uperLoaderType.java:550)
>     at 
>edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob.runJob(Groupe
>rLoaderJob.java:398)
>     at 
>edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob.execute(Group
>erLoaderJob.java:300)
>     at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
>     at 
>org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:5
>29)
>Caused by: org.hibernate.NonUniqueResultException: query did not return
>a unique result: 2
>     at 
>org.hibernate.impl.AbstractQueryImpl.uniqueElement(AbstractQueryImpl.java:
>899)
>     at 
>org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:8
>90)
>     at 
>edu.internet2.middleware.grouper.hibernate.ByHql.uniqueResult(ByHql.java:2
>57)
>     at 
>edu.internet2.middleware.grouper.hibernate.ByHqlStatic$1.callback(ByHqlSta
>tic.java:332)
>     at 
>edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibern
>ateSession(HibernateSession.java:571)
>     ... 12 more
>
>Any ideas ? misconfiguration ?
>
>Jérémy