Grouper Users - Open Discussion List

[Shilen Patel <>]

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(T4CPreparedStatemen
>t.ja
>va:1448)
>        at
>oracle.jdbc.driver.OraclePreparedStatement.executeForRowsWithTimeout(Oracl
>ePre
>paredStatement.java:17722)
>        at
>oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStat
>emen
>t.java:17849)
>        at
>oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrap
>per.
>java:785)
>        at
>com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPr
>epar
>edStatement.java:2544)
>        at
>org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(Ba
>tchi
>ngBatch.java:110)
>        at
>org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(Batc
>hing
>Batch.java:97)
>        at
>org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(Abstrac
>tBat
>chImpl.java:147)
>        at
>org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.executeBatch(JdbcCo
>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.performExecutio
>ns(A
>bstractFlushingEventListener.java:337)
>        at
>org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlus
>hEve
>ntListener.java:39)
>        at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1224)
>        at
>edu.internet2.middleware.grouper.hibernate.ByObject.save(ByObject.java:221
>)
>        at
>edu.internet2.middleware.grouper.hibernate.ByObjectStatic$7.callback(ByObj
>ectS
>tatic.java:494)
>        at
>edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibern
>ateS
>ession(HibernateSession.java:700)
>        at
>edu.internet2.middleware.grouper.hibernate.ByObjectStatic.save(ByObjectSta
>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.processPostMembershipSaveOrUpd
>ate(
>Membership.java:2173)
>        at
>edu.internet2.middleware.grouper.Membership.onPostSave(Membership.java:199
>7)
>        at
>edu.internet2.middleware.grouper.hibernate.ByObject.save(ByObject.java:224
>)
>        at
>edu.internet2.middleware.grouper.hibernate.ByObjectStatic$7.callback(ByObj
>ectS
>tatic.java:494)
>        at
>edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibern
>ateS
>ession(HibernateSession.java:700)
>        at
>edu.internet2.middleware.grouper.hibernate.ByObjectStatic.save(ByObjectSta
>tic.
>java:481)
>        at
>edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MembershipDAO.save(
>Hib3
>MembershipDAO.java:2077)
>        at
>edu.internet2.middleware.grouper.Membership.internal_addImmediateMembershi
>p(Me
>mbership.java:1246)
>        at 
>edu.internet2.middleware.grouper.Group$4.callback(Group.java:1392)
>        at
>edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibern
>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.syncOneMembe
>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.callLog
>ic(G
>rouperLoaderType.java:2647)
>        at
>edu.internet2.middleware.grouper.app.loader.GrouperLoaderType$12$2.callLog
>ic(G
>rouperLoaderType.java:2643)
>        at
>edu.internet2.middleware.grouper.util.GrouperCallable$1.callback(GrouperCa
>llab
>le.java:164)
>        at
>edu.internet2.middleware.grouper.GrouperSession.callbackGrouperSession(Gro
>uper
>Session.java:974)
>        at
>edu.internet2.middleware.grouper.util.GrouperCallable.callLogicWithSession
>IfEx
>ists(GrouperCallable.java:161)
>        at
>edu.internet2.middleware.grouper.util.GrouperCallable.call(GrouperCallable
>.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.java
>:615
>)
>        at java.lang.Thread.run(Thread.java:745)