Grouper Users - Open Discussion List

[Shilen Patel <>]

API patch 55 includes a change such that the exception will be logged at
an INFO level instead of ERROR level if it's going to be retried.  If it
fails during the retry, it'll be logged as ERROR.

Thanks!

- Shilen

On 1/18/17, 5:59 AM, "Shilen Patel" 
<>
 wrote:

>Hi,
>
>Since the loader runs multiple threads and adds multiple memberships at
>the same time, this can happen if there are two membership adds happening
>in two different threads at about the same time where each direct
>membership individually would produce the same composite membership.  I'm
>guessing that's what happened here.  Also note that the loader will retry
>membership updates that fail so if you didn't get another error in the log
>and the job itself didn't fail in the end, then you should be okay.
>
>Thanks!
>
>- Shilen
>
>On 1/17/17, 3:56 PM, "Kumi Hagimoto" 
><>
>wrote:
>
>>Hi,
>>
>>We got the following error message in the log over the weekend trying to
>>add
>>membership via a sql loader job.  It's only happened this one time in the
>>past
>>week, so I don't know if there's a pattern yet.  I did look at the loader
>>source table to make sure we had unique set of data.  Has anyone
>>encountered
>>this error?  Any pointers are appreciated.
>>
>>Thanks,
>>Kumi
>>
>>java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique
>>constraint (GROUPER.MEMBERSHIP_UNIQ_IDX) violated
>>
>>        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:459)
>>        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:400)
>>        at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:999)
>>        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:539)
>>        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:235)
>>        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:543)
>>        at
>>oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java
>>:
>>239)
>>        at
>>oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStateme
>>n
>>t.ja
>>va:1448)
>>        at
>>oracle.jdbc.driver.OraclePreparedStatement.executeForRowsWithTimeout(Orac
>>l
>>ePre
>>paredStatement.java:17722)
>>        at
>>oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedSta
>>t
>>emen
>>t.java:17849)
>>        at
>>oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWra
>>p
>>per.
>>java:785)
>>        at
>>com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyP
>>r
>>epar
>>edStatement.java:2544)
>>        at
>>org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(B
>>a
>>tchi
>>ngBatch.java:110)
>>        at
>>org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(Bat
>>c
>>hing
>>Batch.java:97)
>>        at
>>org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(Abstra
>>c
>>tBat
>>chImpl.java:147)
>>        at
>>org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.executeBatch(JdbcC
>>o
>>ordi
>>natorImpl.java:214)
>>        at
>>org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:589)
>>        at
>>org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:434)
>>        at
>>org.hibernate.event.internal.AbstractFlushingEventListener.performExecuti
>>o
>>ns(A
>>bstractFlushingEventListener.java:337)
>>        at
>>org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlu
>>s
>>hEve
>>ntListener.java:39)
>>        at 
>>org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1224)
>>        at
>>edu.internet2.middleware.grouper.hibernate.ByObject.save(ByObject.java:22
>>1
>>)
>>        at
>>edu.internet2.middleware.grouper.hibernate.ByObjectStatic$7.callback(ByOb
>>j
>>ectS
>>tatic.java:494)
>>        at
>>edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHiber
>>n
>>ateS
>>ession(HibernateSession.java:700)
>>        at
>>edu.internet2.middleware.grouper.hibernate.ByObjectStatic.save(ByObjectSt
>>a
>>tic.
>>java:481)
>>        at
>>edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MembershipDAO.save
>>(
>>Hib3
>>MembershipDAO.java:2077)
>>        at
>>edu.internet2.middleware.grouper.Membership.fixComposites(Membership.java
>>:
>>2272
>>)
>>        at
>>edu.internet2.middleware.grouper.Membership.processPostMembershipSaveOrUp
>>d
>>ate(
>>Membership.java:2173)
>>        at
>>edu.internet2.middleware.grouper.Membership.onPostSave(Membership.java:19
>>9
>>7)
>>        at
>>edu.internet2.middleware.grouper.hibernate.ByObject.save(ByObject.java:22
>>4
>>)
>>        at
>>edu.internet2.middleware.grouper.hibernate.ByObjectStatic$7.callback(ByOb
>>j
>>ectS
>>tatic.java:494)
>>        at
>>edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHiber
>>n
>>ateS
>>ession(HibernateSession.java:700)
>>        at
>>edu.internet2.middleware.grouper.hibernate.ByObjectStatic.save(ByObjectSt
>>a
>>tic.
>>java:481)
>>        at
>>edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MembershipDAO.save
>>(
>>Hib3
>>MembershipDAO.java:2077)
>>        at
>>edu.internet2.middleware.grouper.Membership.internal_addImmediateMembersh
>>i
>>p(Me
>>mbership.java:1246)
>>        at 
>>edu.internet2.middleware.grouper.Group$4.callback(Group.java:1392)
>>        at
>>edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHiber
>>n
>>ateS
>>ession(HibernateSession.java:700)
>>        at
>>edu.internet2.middleware.grouper.Group.internal_addMember(Group.java:1364
>>)
>>        at 
>>edu.internet2.middleware.grouper.Group.addMember(Group.java:938)
>>        at 
>>edu.internet2.middleware.grouper.Group.addMember(Group.java:857)
>>        at
>>edu.internet2.middleware.grouper.app.loader.GrouperLoaderType.syncOneMemb
>>e
>>rAdd
>>MemberLogic(GrouperLoaderType.java:4159)
>>        at
>>edu.internet2.middleware.grouper.app.loader.GrouperLoaderType.access$400(
>>G
>>roup
>>erLoaderType.java:118)
>>        at
>>edu.internet2.middleware.grouper.app.loader.GrouperLoaderType$12$2.callLo
>>g
>>ic(G
>>rouperLoaderType.java:2647)
>>        at
>>edu.internet2.middleware.grouper.app.loader.GrouperLoaderType$12$2.callLo
>>g
>>ic(G
>>rouperLoaderType.java:2643)
>>        at
>>edu.internet2.middleware.grouper.util.GrouperCallable$1.callback(GrouperC
>>a
>>llab
>>le.java:164)
>>        at
>>edu.internet2.middleware.grouper.GrouperSession.callbackGrouperSession(Gr
>>o
>>uper
>>Session.java:974)
>>        at
>>edu.internet2.middleware.grouper.util.GrouperCallable.callLogicWithSessio
>>n
>>IfEx
>>ists(GrouperCallable.java:161)
>>        at
>>edu.internet2.middleware.grouper.util.GrouperCallable.call(GrouperCallabl
>>e
>>.jav
>>a:132)
>>        at java.util.concurrent.FutureTask.run(FutureTask.java:262)
>>        at
>>java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java
>>:
>>1145
>>)
>>        at
>>java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.jav
>>a
>>:615
>>)
>>        at java.lang.Thread.run(Thread.java:745)
>