Skip to Content.
Sympa Menu

grouper-users - Re: [grouper-users] Error on job: CHANGE_LOG_changeLogTempToChangeLog

Subject: Grouper Users - Open Discussion List

List archive

Re: [grouper-users] Error on job: CHANGE_LOG_changeLogTempToChangeLog


Chronological Thread 
  • From: Gasperowicz Jérémy <>
  • To:
  • Subject: Re: [grouper-users] Error on job: CHANGE_LOG_changeLogTempToChangeLog
  • Date: Mon, 05 Nov 2012 10:57:18 +0100

Ok,

So the problem seems to be an encoding problem between datas in LDAP and in Grouper, as this is a test folder, it isn't important.
But as I've done bin/gsh.sh -psp -sync edu:group to sync a group, How can I sync some groups, not all, with the loader, so i will exclude the group that is a problem, is it possible ?

Thanks,
Jérémy

Le 05/11/2012 09:46, Gasperowicz Jérémy a écrit :
Hi,

I've deleted the row that was a problem an the error disappeared and now I can see errors went unnoticed :

2012-11-05 09:23:06,638: [DefaultQuartzScheduler_Worker-2] ERROR BaseSpmlProvider.execute(452) -  - Target 'artois:ldap' - Search SearchResponse[psos=0,status=failure,error=noSuchIdentifier,errorMessages={[LDAP: error code 32 - No Such Object]},requestID=2012/11/05-09:23:06.620]
2012-11-05 09:23:06,639: [DefaultQuartzScheduler_Worker-2] ERROR BaseSpmlProvider.execute(454) -  - Target 'artois:ldap' - Search XML:
<spmlsearch:searchResponse xmlns='urn:oasis:names:tc:SPML:2:0' xmlns:spmlsearch='urn:oasis:names:tc:SPML:2:0:search' status='failure' requestID='2012/11/05-09:23:06.620' error='noSuchIdentifier'>
  <errorMessage>[LDAP: error code 32 - No Such Object]</errorMessage>
</spmlsearch:searchResponse>

2012-11-05 09:23:06,640: [DefaultQuartzScheduler_Worker-2] ERROR BaseSpmlProvider.execute(452) -  - Target 'psp' - Search SearchResponse[psos=0,status=failure,error=noSuchIdentifier,errorMessages={[LDAP: error code 32 - No Such Object]},requestID=2012/11/05-09:23:06.620]
2012-11-05 09:23:06,640: [DefaultQuartzScheduler_Worker-2] ERROR BaseSpmlProvider.execute(454) -  - Target 'psp' - Search XML:
<spmlsearch:searchResponse xmlns='urn:oasis:names:tc:SPML:2:0' xmlns:spmlsearch='urn:oasis:names:tc:SPML:2:0:search' status='failure' requestID='2012/11/05-09:23:06.620' error='noSuchIdentifier'>
  <errorMessage>[LDAP: error code 32 - No Such Object]</errorMessage>
</spmlsearch:searchResponse>

2012-11-05 09:23:06,641: [DefaultQuartzScheduler_Worker-2] ERROR Psp.hasAttribute(2027) -  - SearchResponse[psos=0,status=failure,error=noSuchIdentifier,errorMessages={[LDAP: error code 32 - No Such Object]},requestID=2012/11/05-09:23:06.620]


Thanks,
Jérémy

Le 31/10/2012 17:05, Shilen Patel a écrit :
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





Archive powered by MHonArc 2.6.16.

Top of Page