[midPoint] 3.7 Running slooooow, HHH000010 messages in the log

[Wojciech Staszewski]

Hello all!

>From certain time I'm facing strange slowdowns in midPoint.
Example: Edit user, set "Valid to" date, save.

The operation took..., well I gave up after 1500 seconds.

Top:

top - 22:51:40 up 69 days,  6:40,  3 users,  load average: 1,65, 1,48, 1,33
Tasks: 165 total,   1 running, 164 sleeping,   0 stopped,   0 zombie
%Cpu(s):  3,1 us,  0,2 sy,  0,0 ni, 84,9 id, 11,8 wa,  0,0 hi,  0,0 si,  0,0 st
KiB Mem : 32941960 total, 17412992 free,  6852052 used,  8676916 buff/cache
KiB Swap: 33554428 total, 33482736 free,    71692 used. 25445768 avail Mem

Log:

2018-02-27 22:26:17,380 [] [pool-4-thread-6] INFO (org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl): HHH000010: On release of batch it still contained JDBC statements
2018-02-27 22:27:59,461 [] [pool-4-thread-6] INFO (org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl): HHH000010: On release of batch it still contained JDBC statements
2018-02-27 22:29:41,498 [] [pool-4-thread-6] INFO (org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl): HHH000010: On release of batch it still contained JDBC statements
2018-02-27 22:31:23,690 [] [pool-4-thread-6] INFO (org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl): HHH000010: On release of batch it still contained JDBC statements
2018-02-27 22:33:06,113 [] [pool-4-thread-6] INFO (org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl): HHH000010: On release of batch it still contained JDBC statements
2018-02-27 22:34:48,436 [] [pool-4-thread-6] INFO (org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl): HHH000010: On release of batch it still contained JDBC statements
2018-02-27 22:36:30,992 [] [pool-4-thread-6] INFO (org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl): HHH000010: On release of batch it still contained JDBC statements
2018-02-27 22:38:15,776 [] [pool-4-thread-6] INFO (org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl): HHH000010: On release of batch it still contained JDBC statements
2018-02-27 22:40:00,766 [] [pool-4-thread-6] INFO (org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl): HHH000010: On release of batch it still contained JDBC statements
2018-02-27 22:41:20,932 [] [ClusterManagerThread] ERROR (com.evolveum.midpoint.task.quartzimpl.execution.StalledTasksWatcher): Task Task(id:1494846681800-0-1, name:Cleanup, oid:00000000-0000-0000-0000-000000000005) seems to be stalled (started Tue Feb 27 22:21:14 CET 2018; progress is still 0, observed since Tue Feb 27 22:31:17 CET 2018)
2018-02-27 22:41:45,652 [] [pool-4-thread-6] INFO (org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl): HHH000010: On release of batch it still contained JDBC statements
2018-02-27 22:43:32,964 [] [pool-4-thread-6] INFO (org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl): HHH000010: On release of batch it still contained JDBC statements
2018-02-27 22:45:16,142 [] [pool-4-thread-6] INFO (org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl): HHH000010: On release of batch it still contained JDBC statements
2018-02-27 22:47:00,434 [] [pool-4-thread-6] INFO (org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl): HHH000010: On release of batch it still contained JDBC statements
2018-02-27 22:48:45,094 [] [pool-4-thread-6] INFO (org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl): HHH000010: On release of batch it still contained JDBC statements


Anyone know how to fix it?

Thanks!
WS