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

Sylvaire kevin TIPA sylvaire-kevin.tipa at mythalesgroup.io
Fri Sep 7 09:19:29 CEST 2018


Hello, do you have other log information in the midpoint.log file ?

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.

(but it what in V3.6)

Cordialement,


[cid:8e2f30c3-f5eb-4f4e-aefb-9d083f8a3b45]

Sylvaire-Kevin TIPA
Thales Services / OIC / DevOps Automatisation Infrastructures
…………………………………………………………………………………………
THALES SERVICES SAS
44 Quai Charles de Gaulle
CS 20100
69463 Lyon Cedex 06
…………………………………………………………………………………………
www.thalesgroup.com<http://www.thalesgroup.com/>




De : midPoint [mailto:midpoint-bounces at lists.evolveum.com] De la part de Alcides Carlos de Moraes Neto
Envoyé : jeudi 6 septembre 2018 21:08
À : midpoint <midpoint at lists.evolveum.com>
Objet : [midPoint] Problem after migration from 3.7 to 3.8 - Org Tree Page won't open

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)


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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20180907/340fbf15/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 6112 bytes
Desc: image001.png
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20180907/340fbf15/attachment.png>


More information about the midPoint mailing list