<div dir="ltr"><div dir="ltr">Thank you Sylvaire for your help, but we didn't have any problematic objects.</div><div dir="ltr"><br></div><div>It must have been something with our DB. After a while, the query stopped hanging, and now it's working.<br></div></div><br><div class="gmail_quote"><div dir="ltr">Em sex, 7 de set de 2018 às 04:21, Sylvaire kevin TIPA <<a href="mailto:sylvaire-kevin.tipa@mythalesgroup.io">sylvaire-kevin.tipa@mythalesgroup.io</a>> escreveu:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">





<div lang="FR" link="#0563C1" vlink="#954F72">
<div class="m_5127926986091504744WordSection1">
<p class="MsoNormal"><span lang="EN-GB" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Hello, do you have other log information in the midpoint.log file ?
<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">In my case it happened when I have more than one org with the same name, or shadow link to this org. Check with repository
 objects if something is wrong.  <u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">(but it what in V3.6)
<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-family:"Calibri",sans-serif;color:black">Cordialement,<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-family:"Calibri",sans-serif;color:black"><u></u> <u></u></span></p>
<table class="m_5127926986091504744MsoNormalTable" border="1" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border:none;border-top:solid #00bbdf 3.0pt">
<tbody>
<tr>
<td width="708" valign="top" style="width:225.75pt;border:none;padding:0cm 0cm 0cm 0cm">
<p class="MsoNormal" style="line-height:105%"><span lang="EN-GB" style="font-size:11.0pt;line-height:105%;font-family:"Calibri",sans-serif;color:black"><u></u> <u></u></span></p>
<p class="MsoNormal" style="line-height:105%"><span style="font-size:11.0pt;line-height:105%;font-family:"Calibri",sans-serif;color:#1f497d"><img width="174" height="22" id="m_5127926986091504744Image_x0020_1" src="cid:image001.png@01D4468B.E0B2A6F0" alt="cid:8e2f30c3-f5eb-4f4e-aefb-9d083f8a3b45"></span><span lang="EN-GB" style="font-size:11.0pt;line-height:105%;font-family:"Calibri",sans-serif;color:black"><u></u><u></u></span></p>
<p class="MsoNormal" style="line-height:105%"><span lang="EN-GB" style="font-size:11.0pt;line-height:105%;font-family:"Calibri",sans-serif;color:black"><u></u> <u></u></span></p>
<p class="MsoNormal" style="line-height:105%"><b><span lang="EN-GB" style="font-size:10.0pt;line-height:105%;font-family:"Arial",sans-serif;color:#1f497d">Sylvaire-Kevin TIPA</span></b><i><span lang="EN-GB" style="font-size:10.0pt;line-height:105%;font-family:"Calibri",sans-serif;color:#757b80">
<u></u><u></u></span></i></p>
<p class="MsoNormal" style="line-height:105%"><i><span lang="EN-GB" style="font-size:10.0pt;line-height:105%;font-family:"Calibri",sans-serif;color:#767171">Thales Services / OIC / DevOps Automatisation Infrastructures<u></u><u></u></span></i></p>
<p class="MsoNormal" style="line-height:105%"><span lang="EN-GB" style="font-size:11.0pt;line-height:105%;font-family:"Calibri",sans-serif;color:#bfbfbf">…………………………………………</span><span style="font-size:11.0pt;line-height:105%;font-family:"Calibri",sans-serif;color:#bfbfbf">………………………………………………<u></u><u></u></span></p>
<p class="MsoNormal" style="line-height:105%"><span style="font-size:9.0pt;line-height:105%;font-family:"Calibri",sans-serif;color:gray">THALES SERVICES SAS<br>
44 Quai Charles de Gaulle<br>
CS 20100<br>
69463 Lyon Cedex 06<u></u><u></u></span></p>
<p class="MsoNormal" style="line-height:105%"><span style="font-size:11.0pt;line-height:105%;font-family:"Calibri",sans-serif;color:#bfbfbf">…………………………………………………………………………………………<u></u><u></u></span></p>
<p class="MsoNormal" style="line-height:105%"><span style="font-size:11.0pt;line-height:105%;font-family:"Calibri",sans-serif;color:#1f497d"><a href="http://www.thalesgroup.com/" target="_blank"><span style="font-size:8.5pt;line-height:105%;font-family:"Arial",sans-serif;color:gray">www.thalesgroup.com</span></a></span><span style="font-size:11.0pt;line-height:105%;font-family:"Calibri",sans-serif;color:#bfbfbf"><u></u><u></u></span></p>
<p class="MsoNormal" style="line-height:105%"><span style="font-size:11.0pt;line-height:105%;font-family:"Calibri",sans-serif;color:black"><u></u> <u></u></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black;display:none"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">De :</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> midPoint [mailto:<a href="mailto:midpoint-bounces@lists.evolveum.com" target="_blank">midpoint-bounces@lists.evolveum.com</a>]
<b>De la part de</b> Alcides Carlos de Moraes Neto<br>
<b>Envoyé :</b> jeudi 6 septembre 2018 21:08<br>
<b>À :</b> midpoint <<a href="mailto:midpoint@lists.evolveum.com" target="_blank">midpoint@lists.evolveum.com</a>><br>
<b>Objet :</b> [midPoint] Problem after migration from 3.7 to 3.8 - Org Tree Page won't open<u></u><u></u></span></p>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<div>
<p class="MsoNormal">Hello list,<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Today we migrated our production server from 3.7 to 3.8<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Previously we migrated our development server without issues.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">But on our production servers, after migration, we cannot open the Org Tree Page. Everything else seems to be working fine.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">We get a CouldNotLockPageException. It seems midPoint hangs while loading the Organizational Tree.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Turning on hibernate.SQL debug, the last query that is called  by the thread is this one:<u></u><u></u></p>
</div>
<div>
<p><span class="m_5127926986091504744gmail-message">DEBUG [org.hibernate.SQL] (</span><span class="m_5127926986091504744gmail-highlight">http-nio-8080-exec-26</span><span class="m_5127926986091504744gmail-message">) select robject0_.oid as col_0_0_, robject0_.fullObject as col_1_0_, robject0_.stringsCount as col_2_0_,
 robject0_.longsCount as col_3_0_, robject0_.datesCount as col_4_0_, robject0_.referencesCount as col_5_0_, robject0_.polysCount as col_6_0_, robject0_.booleansCount as col_7_0_ from m_object robject0_ where robject0_.objectTypeClass=? and (robject0_.oid in
 (select robjectref1_.owner_oid from m_reference robjectref1_ where robjectref1_.reference_type=0 and (robjectref1_.targetOid in (select rorgclosur2_.descendant_oid from m_org_closure rorgclosur2_ where rorgclosur2_.ancestor_oid=?)))) order by robject0_.name_orig
 asc fetch first ? rows only</span><u></u><u></u></p>
<p><u></u> <u></u></p>
<p><span class="m_5127926986091504744gmail-message">Any help would be appreciated, thanks.</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Exception and Thread dump:<u></u><u></u></p>
</div>
<div>
<p><span class="m_5127926986091504744gmail-message">2018-09-06T15:45:56.281 WARN [org.apache.wicket.page.PageAccessSynchronizer] (http-nio-8080-exec-26) Thread 'http-nio-8080-exec-26' failed to acquire lock to page with id '33', attempted for 1 minute out of allowed 1 minute. The
 thread that holds the lock has name 'http-nio-8080-exec-24'.</span><u></u><u></u></p>
<p><span class="m_5127926986091504744gmail-message">2018-09-06T15:45:56.285 WARN [org.apache.wicket.page.PageAccessSynchronizer] (http-nio-8080-exec-26) "http-nio-8080-exec-24" daemon prio=5 tid=810 state=RUNNABLE</span><br>
<span class="m_5127926986091504744gmail-message"> org.apache.wicket.util.lang.Threads$ThreadDump: null</span><br>
<span class="m_5127926986091504744gmail-message"> at java.net.SocketInputStream.socketRead0(Native Method)</span><br>
<span class="m_5127926986091504744gmail-message"> at java.net.SocketInputStream.socketRead(SocketInputStream.java:116)</span><br>
<span class="m_5127926986091504744gmail-message"> at java.net.SocketInputStream.read(SocketInputStream.java:171)</span><br>
<span class="m_5127926986091504744gmail-message"> at java.net.SocketInputStream.read(SocketInputStream.java:141)</span><br>
<span class="m_5127926986091504744gmail-message"> at oracle.net.ns.Packet.receive(Packet.java:311)</span><br>
<span class="m_5127926986091504744gmail-message"> at oracle.net.ns.DataPacket.receive(DataPacket.java:105)</span><br>
<span class="m_5127926986091504744gmail-message"> at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:305)</span><br>
<span class="m_5127926986091504744gmail-message"> at oracle.net.ns.NetInputStream.read(NetInputStream.java:249)</span><br>
<span class="m_5127926986091504744gmail-message"> at oracle.net.ns.NetInputStream.read(NetInputStream.java:171)</span><br>
<span class="m_5127926986091504744gmail-message"> at oracle.net.ns.NetInputStream.read(NetInputStream.java:89)</span><br>
<span class="m_5127926986091504744gmail-message"> at oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:123)</span><br>
<span class="m_5127926986091504744gmail-message"> at oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:79)</span><br>
<span class="m_5127926986091504744gmail-message"> at oracle.jdbc.driver.T4CMAREngineStream.unmarshalUB1(T4CMAREngineStream.java:429)</span><br>
<span class="m_5127926986091504744gmail-message"> at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:397)</span><br>
<span class="m_5127926986091504744gmail-message"> at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)</span><br>
<span class="m_5127926986091504744gmail-message"> at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)</span><br>
<span class="m_5127926986091504744gmail-message"> at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:225)</span><br>
<span class="m_5127926986091504744gmail-message"> at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:53)</span><br>
<span class="m_5127926986091504744gmail-message"> at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:943)</span><br>
<span class="m_5127926986091504744gmail-message"> at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:957)</span><br>
<span class="m_5127926986091504744gmail-message"> at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1111)</span><br>
<span class="m_5127926986091504744gmail-message"> at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798)</span><br>
<span class="m_5127926986091504744gmail-message"> at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:4845)</span><br>
<span class="m_5127926986091504744gmail-message"> at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1501)</span><br>
<span class="m_5127926986091504744gmail-message"> at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)</span><br>
<span class="m_5127926986091504744gmail-message"> at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)</span><br>
<span class="m_5127926986091504744gmail-message"> at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:60)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
</div>
</div>
<p style="font-size:8pt;line-height:10pt;font-family:'Cambria','times roman',serif">
This message contains confidential information and is intended only for the individual(s) addressed in the message. If you are not the named addressee, you should not disseminate, distribute, or copy this e-mail. If you are not the intended recipient, you are
 notified that disclosing, distributing, or copying this e-mail is strictly prohibited.
</p>
</div>

_______________________________________________<br>
midPoint mailing list<br>
<a href="mailto:midPoint@lists.evolveum.com" target="_blank">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>
</blockquote></div>