Grouper Users - Open Discussion List

[Shilen Patel <>]

OK I'm going to look through the output in more detail to see if I can
figure out what caused the problem.  But in the meantime, I think you can
resolve the issue by deleting one row.

delete from grouper_pit_memberships where
id='9df80189aed7424e91a1163406d62bbe';
commit;

You may have to restart the Grouper daemon to clear caches.

Let me know if that works or not.

Thanks!

-- Shilen

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

>Hi,
>
>I'm using a MySQL database which supports transactions (innoDB engine),
>no XML import/export, no database recovery
>What do you mean by membership enable/disable ?
>
>select source_id, count(*) from grouper_pit_memberships where active='T'
>group by source_id having count(*)>  1; :
>
>source_id         
>count(*)
>fb686e35f40547948dbc3a860885bde2',     '2'
>
>And for the two last queries, they are in attachment (too many datas for
>the second query in "grouper_audit_entry_v.txt", which fields do you need
>?)
>
>Thanks !
>Jérémy
>
>Le 31/10/2012 15:33, Shilen Patel a écrit :
>> 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_hi
>>>be
>>> rnateSessionCatch(HibernateSession.java:495)
>>>      at
>>> 
>>>edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibe
>>>rn
>>> ateSession(HibernateSession.java:581)
>>>      at
>>> 
>>>edu.internet2.middleware.grouper.hibernate.ByHqlStatic.uniqueResult(ByHq
>>>lS
>>> tatic.java:323)
>>>      at
>>> 
>>>edu.internet2.middleware.grouper.internal.dao.hib3.Hib3PITMembershipDAO.
>>>fi
>>> ndBySourceIdActive(Hib3PITMembershipDAO.java:70)
>>>      at
>>> 
>>>edu.internet2.middleware.grouper.changeLog.ChangeLogTempToEntity.process
>>>Me
>>> 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.callb
>>>ac
>>> k(ChangeLogTempToEntity.java:137)
>>>      at
>>> 
>>>edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibe
>>>rn
>>> ateSession(HibernateSession.java:571)
>>>      at
>>> 
>>>edu.internet2.middleware.grouper.changeLog.ChangeLogTempToEntity.convert
>>>Re
>>> cords(ChangeLogTempToEntity.java:91)
>>>      at
>>> 
>>>edu.internet2.middleware.grouper.app.loader.GrouperLoaderType$4.runJob(G
>>>ro
>>> uperLoaderType.java:550)
>>>      at
>>> 
>>>edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob.runJob(Grou
>>>pe
>>> rLoaderJob.java:398)
>>>      at
>>> 
>>>edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob.execute(Gro
>>>up
>>> 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.jav
>>>a:
>>> 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(ByHqlS
>>>ta
>>> tic.java:332)
>>>      at
>>> 
>>>edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibe
>>>rn
>>> 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_hi
>>>be
>>> rnateSessionCatch(HibernateSession.java:495)
>>>      at
>>> 
>>>edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibe
>>>rn
>>> ateSession(HibernateSession.java:581)
>>>      at
>>> 
>>>edu.internet2.middleware.grouper.hibernate.ByHqlStatic.uniqueResult(ByHq
>>>lS
>>> tatic.java:323)
>>>      at
>>> 
>>>edu.internet2.middleware.grouper.internal.dao.hib3.Hib3PITMembershipDAO.
>>>fi
>>> ndBySourceIdActive(Hib3PITMembershipDAO.java:70)
>>>      at
>>> 
>>>edu.internet2.middleware.grouper.changeLog.ChangeLogTempToEntity.process
>>>Me
>>> 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.callb
>>>ac
>>> k(ChangeLogTempToEntity.java:137)
>>>      at
>>> 
>>>edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibe
>>>rn
>>> ateSession(HibernateSession.java:571)
>>>      at
>>> 
>>>edu.internet2.middleware.grouper.changeLog.ChangeLogTempToEntity.convert
>>>Re
>>> cords(ChangeLogTempToEntity.java:91)
>>>      at
>>> 
>>>edu.internet2.middleware.grouper.app.loader.GrouperLoaderType$4.runJob(G
>>>ro
>>> uperLoaderType.java:550)
>>>      at
>>> 
>>>edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob.runJob(Grou
>>>pe
>>> rLoaderJob.java:398)
>>>      at
>>> 
>>>edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob.execute(Gro
>>>up
>>> 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.jav
>>>a:
>>> 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(ByHqlS
>>>ta
>>> tic.java:332)
>>>      at
>>> 
>>>edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibe
>>>rn
>>> ateSession(HibernateSession.java:571)
>>>      ... 12 more
>>>
>>> Any ideas ? misconfiguration ?
>>>
>>> Jérémy