Skip to Content.
Sympa Menu

grouper-users - Re: [grouper-users] SQLIntegrityConstraintViolationException from one of the loader jobs

Subject: Grouper Users - Open Discussion List

List archive

Re: [grouper-users] SQLIntegrityConstraintViolationException from one of the loader jobs


Chronological Thread 
  • From: Shilen Patel <>
  • To: Kumi Hagimoto <>, "" <>
  • Subject: Re: [grouper-users] SQLIntegrityConstraintViolationException from one of the loader jobs
  • Date: Wed, 18 Jan 2017 10:59:30 +0000
  • Accept-language: en-US
  • Authentication-results: spf=none (sender IP is ) ;
  • Ironport-phdr: 9a23:VQvJtRZA1gR4ARe1sucnQR3/LSx+4OfEezUN459isYplN5qZps2+ZR7h7PlgxGXEQZ/co6odzbGH7+a7CCdZvN6oizMrSNR0TRgLiMEbzUQLIfWuLgnFFsPsdDEwB89YVVVorDmROElRH9viNRWJ+iXhpTEdFQ/iOgVrO+/7BpDdj9it1+C15pbffxhEiCCzbL52Ixi6twvcu80ZjYd/Kqs61wfErGZPd+lK321jOEidnwz75se+/Z5j9zpftvc8/MNeUqv0Yro1Q6VAADspL2466svrtQLeTQSU/XsTTn8WkhtTDAfb6hzxQ4r8vTH7tup53ymaINH2QLUpUjms86tnVBnlgzocOjUn7G/YlNB/jKNDoBKguRN/xZLUYJqIP/Z6Z6/RYM8WSXZEUstXSidPAJ6zb5EXAuQBI+hWspX9qVUNoxuwBwajCuLvxSNHiHD5xqA6z/0hHBva0AA8Bd8CrnLZp8j1OqcIVuC1ybHFwyjDb/NX3Tfy9o7IeQ07r/6WQbJ/b87RwlQoGgPejlWQqIjlMC2T1ukWrmeb8ulgWvy1h2E5tg5xvyGiy8ExgYfHgYIVz0rL9SR/wIstPtK5SEl7bsWmEJROqy6aK5B2Qt84TGF0uSY11qcKuYWhcygU1psr3xHfa+aAc4iV+hLsSvyRLS1ii3J9YLKznwqy8Ui6yuLiTMa7zUxGrjBYktnKrnwN1x3T5dOJR/t44Eih3C2A2B7J6uFfIUA0lLLbJIM7zb43jJYTql7MHjHol0nug6+WbEIk+vWw6+v5eLXpuoWTN4twig7kKasuntKwDf4kPQcUW2ib/fyw26bj/E3+W7pKjOM5nbXFsJzAPsQUvLC5DBFN3oYt9ha/Eyqm0M4GknkbNl1FYxGHg5LzO1HTJvD1C+q0jVe0kDpz2vzLPqPtDo/DI3TZjbvsfrJw51RCxAc9yd1T/49YB78ALf7pWkL8tcbUAgInPwCu3urqBstx2psAVW6TAKKVKqzfvF6S6u4yIuSBapUZtTbhJ/Uj+vXgl2U2mUUHcqmsxZYXaG63HvBhI0iBZHrjmNYBEWMTsgoxQu3mkUCOXDBJa3a1XqI8+is3B5+7DYfAWI+hmqKO0zqmHpFOZ2BGDE6DEWvweomZW/oAdjieL8F7njAZVrWsT5Ut2Q+guQL+07ZnK/Db+iwctZLtzth14OjTmAkp9Tx0DsSd13+CT2dvk2wVWj82375wrVZjxViezKh0m+ZYGsBL5/NVTgc6MobRz+NgC9D1RwLBZsmGSEy/TtW7GjE+UMgxw8QVbkZ5GtWilQzD3zG0D7MPlryLAoA0/bzG33j3Ocl912jK2LM/gFY7X8scfVGh041i8gmbJ4fGkkCei6HiIacB2S+L9G6MzG+JoEZwVxR9XqLDRmwWekaQoNjksAeKBbC0Dqk/PxEE1NWPMLBia9v1gE9ASeu5ftnSfij5z2iqAguQy6nJcZHnYX413SPBBVICnhxJu3uKKF5tKD2mpjflDD1qGFSnW0rw/O02/Gi7T0s5ySmGck5skbe550hG1rSnV/oP0+dc628aoDJuEQP4hoqOBg==
  • Spamdiagnosticmetadata: NSPM
  • Spamdiagnosticoutput: 1:99

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)




Archive powered by MHonArc 2.6.19.

Top of Page