<div dir="ltr">Hi Viliam,<div>it happened (twice) in our production environment, but eventually dissapeared after a reboot.</div><div>We could not replicate the issue in our testing environment.</div><div><br></div><div>We are in the process to import the accounts (~450000) and provisioning to 3 resources (eDirectory LDAP, Google Apps and Office 365).</div><div>We are also checking if we need to do some additional tuning on the PostgreSQL database.</div><div><br></div><div>I'll let you know if we can isolate anything.</div><div><br></div><div><br></div><div>Regards,</div><div><br></div><div>GJG</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Jul 18, 2016 at 8:18 AM, Viliam Repan <span dir="ltr"><<a href="mailto:vilo.repan@evolveum.com" target="_blank">vilo.repan@evolveum.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
  
    
  
  <div bgcolor="#FFFFFF" text="#000000">
    Hi Gustavo,<br>
    <br>
    I've tried to run clean installation of midpoint 3.4 against
    postgresql 9.2 on ubuntu 14.04 and I can't replicate this behavior -
    does it happen after restart?.<br>
    Do you have clean installation any other environment specific stuff?<br>
    I've tested it on ubuntu 14.04 (64bit) with postgres 9.2.17, tomcat
    8, oracle java 8<br>
    <br>
    <b>00000000-0000-0000-0000-000000000006</b> is validity task so I'm
    not sure what happened<br>
    <br>
    v<div><div class="h5"><br>
    <br>
    <div>On 17.07.2016 18:19, Gustavo J Gallardo
      wrote:<br>
    </div>
    </div></div><blockquote type="cite"><div><div class="h5">
      <div dir="ltr">Hi,
        <div>we are running midPoint 3.4 with database PostgreSQL 9.2,
          and getting this error:</div>
        <div>
          <div><b>2016-07-17 13:00:49,887 []
              [midPointScheduler_Worker-2] ERROR
              (org.hibernate.engine.jdbc.spi.SqlExceptionHelper): Batch
              entry 0 update m_object set booleansCount=0,
              createChannel='<a href="http://midpoint.evolveum.com/xml/ns/public/gui/channels-3#init" target="_blank">http://midpoint.evolveum.com/xml/ns/public/gui/channels-3#init</a>',
              createTimestamp='2016-06-02 17:23:48.969000 -03:00:00',
              creatorRef_relation=NULL, creatorRef_targetOid=NULL,
              creatorRef_type=NULL, datesCount=1, fullObject=?,
              longsCount=0, modifierRef_relation=NULL,
              modifierRef_targetOid=NULL, modifierRef_type=NULL,
              modifyChannel=NULL, modifyTimestamp=NULL,
              name_norm='validity scanner', name_orig='Validity
              Scanner', objectTypeClass='9', polysCount=0,
              referencesCount=0, stringsCount=0,
              tenantRef_relation=NULL, tenantRef_targetOid=NULL,
              tenantRef_type=NULL, version=13637 where
              oid='00000000-0000-0000-0000-000000000006' was aborted. 
              Call getNextException to see the cause.</b></div>
          <div><b>2016-07-17 13:00:49,887 []
              [midPointScheduler_Worker-2] ERROR
              (org.hibernate.engine.jdbc.spi.SqlExceptionHelper): ERROR:
              could not serialize access due to read/write dependencies
              among transactions</b></div>
          <div><b>  Detail: Reason code: Canceled on identification as a
              pivot, during write.</b></div>
          <div><b>  Hint: The transaction might succeed if retried.</b></div>
          <div><b>2016-07-17 13:00:49,892 []
              [midPointScheduler_Worker-2] ERROR
              (org.hibernate.engine.jdbc.batch.internal.BatchingBatch):
              HHH000315: Exception executing batch [could not execute
              batch]</b></div>
        </div>
        <div><br>
        </div>
        <div><br>
        </div>
        <div>Any ideas?</div>
        <div><br>
        </div>
        <div>Attached is complete idm.log trying to start the server.</div>
        <div><br>
        </div>
        <div>Thanks,</div>
        <div><br>
        </div>
        <div>GJG</div>
      </div>
      <br>
      <fieldset></fieldset>
      <br>
      </div></div><pre>_______________________________________________
midPoint mailing list
<a href="mailto:midPoint@lists.evolveum.com" target="_blank">midPoint@lists.evolveum.com</a>
<a href="http://lists.evolveum.com/mailman/listinfo/midpoint" target="_blank">http://lists.evolveum.com/mailman/listinfo/midpoint</a><span class="HOEnZb"><font color="#888888">
</font></span></pre><span class="HOEnZb"><font color="#888888">
    </font></span></blockquote><span class="HOEnZb"><font color="#888888">
    <br>
    <pre cols="72">-- 
Ing. Viliam Repáň
Evolveum, s.r.o.

tel: +421 910 797978
mail: <a href="mailto:vilo.repan@evolveum.com" target="_blank">vilo.repan@evolveum.com</a>
</pre>
  </font></span></div>

<br>_______________________________________________<br>
midPoint mailing list<br>
<a href="mailto:midPoint@lists.evolveum.com">midPoint@lists.evolveum.com</a><br>
<a href="http://lists.evolveum.com/mailman/listinfo/midpoint" rel="noreferrer" target="_blank">http://lists.evolveum.com/mailman/listinfo/midpoint</a><br>
<br></blockquote></div><br></div>