<div dir="ltr"><div dir="ltr"><div>Hello list,</div><div><br></div><div>Today we migrated our production server from 3.7 to 3.8</div><div>Previously we migrated our development server without issues.</div><div><br></div><div>But on our production servers, after migration, we cannot open the Org Tree Page. Everything else seems to be working fine.<br></div><div>We get a CouldNotLockPageException. It seems midPoint hangs while loading the Organizational Tree.</div><div>Turning on hibernate.SQL debug, the last query that is called  by the thread is this one:</div><div><p>
<span class="gmail-message">DEBUG [org.hibernate.SQL] (<span class="gmail-highlight">http-nio-8080-exec-26</span>)
 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></p><p><span class="gmail-message"><br></span></p><p><span class="gmail-message">Any help would be appreciated, thanks.<br></span>
</p></div><div><br></div><div>Exception and Thread dump:<br></div><div><p>
<span class="gmail-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></p><p><span class="gmail-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<br> org.apache.wicket.util.lang.Threads$ThreadDump: null<br> at java.net.SocketInputStream.socketRead0(Native Method)<br> at java.net.SocketInputStream.socketRead(SocketInputStream.java:116)<br> at java.net.SocketInputStream.read(SocketInputStream.java:171)<br> at java.net.SocketInputStream.read(SocketInputStream.java:141)<br> at oracle.net.ns.Packet.receive(Packet.java:311)<br> at oracle.net.ns.DataPacket.receive(DataPacket.java:105)<br> at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:305)<br> at oracle.net.ns.NetInputStream.read(NetInputStream.java:249)<br> at oracle.net.ns.NetInputStream.read(NetInputStream.java:171)<br> at oracle.net.ns.NetInputStream.read(NetInputStream.java:89)<br> at oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:123)<br> at oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:79)<br> at oracle.jdbc.driver.T4CMAREngineStream.unmarshalUB1(T4CMAREngineStream.java:429)<br> at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:397)<br> at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)<br> at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)<br> at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:225)<br> at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:53)<br> at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:943)<br> at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:957)<br> at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1111)<br> at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798)<br> at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:4845)<br> at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1501)<br> at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)<br> at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)<br> at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:60)<br></span>
</p></div><div><br></div></div></div>