<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<p>Hello Gustavo,</p>
<p>conflict situations like "ERROR: could not serialize access due
to read/write dependencies among transactions" are normal in
midPoint. They are automatically resolved by retrying the failed
transaction (up to a limit of 40 attempts, which indicates either
extremely high level of db contention, or some other unexpected
problem).</p>
<p>What is different, in your case, is that these exceptions are
logged to your log. By default, the following loggers are turned
off - exactly not to issue a lot of false warnings:</p>
<p>org.hibernate.engine.jdbc.batch.internal.BatchingBatch<br>
org.hibernate.engine.jdbc.spi.SqlExceptionHelper<br>
<br>
Best regards,<br>
Pavol<br>
</p>
<br>
<div class="moz-cite-prefix">On 20.07.2016 20:44, Gustavo J Gallardo
wrote:<br>
</div>
<blockquote
cite="mid:CAA68kP9o+00Q8h_4dHTttLAF84moETTmk8OC0CbcExjtHiXLaQ@mail.gmail.com"
type="cite">
<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 moz-do-not-send="true"
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
moz-do-not-send="true"
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 moz-do-not-send="true" href="mailto:midPoint@lists.evolveum.com" target="_blank">midPoint@lists.evolveum.com</a>
<a moz-do-not-send="true" 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 moz-do-not-send="true" href="mailto:vilo.repan@evolveum.com" target="_blank">vilo.repan@evolveum.com</a>
</pre>
</font></span></div>
<br>
_______________________________________________<br>
midPoint mailing list<br>
<a moz-do-not-send="true"
href="mailto:midPoint@lists.evolveum.com">midPoint@lists.evolveum.com</a><br>
<a moz-do-not-send="true"
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>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
midPoint mailing list
<a class="moz-txt-link-abbreviated" href="mailto:midPoint@lists.evolveum.com">midPoint@lists.evolveum.com</a>
<a class="moz-txt-link-freetext" href="http://lists.evolveum.com/mailman/listinfo/midpoint">http://lists.evolveum.com/mailman/listinfo/midpoint</a>
</pre>
</blockquote>
<br>
</body>
</html>