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

Mon Sep 10 19:51:40 CEST 2018

Thank you Sylvaire for your help, but we didn't have any problematic
objects.

It must have been something with our DB. After a while, the query stopped
hanging, and now it's working.

Em sex, 7 de set de 2018 às 04:21, Sylvaire kevin TIPA <
sylvaire-kevin.tipa at mythalesgroup.io> escreveu:

> 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,
>
>
>
>
>
> [image: 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
>
>
>
>
>
>
>
> *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.
> _______________________________________________
> midPoint mailing list
> midPoint at lists.evolveum.com
> http://lists.evolveum.com/mailman/listinfo/midpoint
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20180910/42b843bd/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 6112 bytes
Desc: not available
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20180910/42b843bd/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 6112 bytes
Desc: not available
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20180910/42b843bd/attachment-0001.png>