[midPoint] Problem after migration from 3.7 to 3.8 - Org Tree Page won't open

[Alcides Carlos de Moraes Neto]

Hello list,

Today we migrated our production server from 3.7 to 3.8
Previously we migrated our development server without issues.

But on our production servers, after migration, we cannot open the Org Tree
Page. Everything else seems to be working fine.
We get a CouldNotLockPageException. It seems midPoint hangs while loading
the Organizational Tree.
Turning on hibernate.SQL debug, the last query that is called  by the
thread is this one:

DEBUG [org.hibernate.SQL] (http-nio-8080-exec-26) 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


Any help would be appreciated, thanks.

Exception and Thread dump:

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'.

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
 org.apache.wicket.util.lang.Threads$ThreadDump: null
 at java.net.SocketInputStream.socketRead0(Native Method)
 at java.net.SocketInputStream.socketRead(SocketInputStream.java:116)
 at java.net.SocketInputStream.read(SocketInputStream.java:171)
 at java.net.SocketInputStream.read(SocketInputStream.java:141)
 at oracle.net.ns.Packet.receive(Packet.java:311)
 at oracle.net.ns.DataPacket.receive(DataPacket.java:105)
 at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:305)
 at oracle.net.ns.NetInputStream.read(NetInputStream.java:249)
 at oracle.net.ns.NetInputStream.read(NetInputStream.java:171)
 at oracle.net.ns.NetInputStream.read(NetInputStream.java:89)
 at
oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:123)
 at
oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:79)
 at
oracle.jdbc.driver.T4CMAREngineStream.unmarshalUB1(T4CMAREngineStream.java:429)
 at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:397)
 at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)
 at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)
 at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:225)
 at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:53)
 at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:943)
 at
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:957)
 at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1111)
 at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798)
 at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:4845)
 at
oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1501)
 at
com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
 at
com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
 at
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:60)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20180906/d82f3274/attachment.htm>