[Unity-idm-discuss] SqlSession Delay

[Sander A. <sa....@fz...>]

Hi Krzysztof,
today we had some problems with SQL Session. The logfile output is
appended below. Nothing in logfile indicates a reason for this problem.
DB log shows no problem/error. One SQL session was kept for 1129
seconds. Parallel to this warnings the CPU usage increased to 100%.
During the problem was a training course where 40 users created new
accounts and/or singed in.
We use a mariadb on the same host. It was the first time we had this
problems. Do you have a hint when this error is shown in the log files?
Best regards,Sander
2017-07-04 08:57:51,116 [qtp1859956068-45]
WARN  unity.server.db.DBSessionManager  - SqlSession is kept for more
than 3s: 3.151s by pool-1-thread-4. Next report in at least 2000ms.
Stacktrace is:  java.lang.Thread.getStackTrace(Thread.java:1552) 
pl.edu.icm.unity.db.DBSessionManager.getSqlSession(DBSessionManager.jav
a:119) 
pl.edu.icm.unity.db.DBSessionManager.getSqlSession(DBSessionManager.jav
a:108) 
pl.edu.icm.unity.engine.transactions.TransactionalAspect.createNewSqlSe
ssion(TransactionalAspect.java:135) 
pl.edu.icm.unity.engine.transactions.TransactionalAspect.setupTransacti
onSession(TransactionalAspect.java:113) 
pl.edu.icm.unity.engine.transactions.TransactionalAspect.retryIfNeeded(
TransactionalAspect.java:62) 
pl.edu.icm.unity.engine.transactions.TransactionalAspect.retryIfNeeded4
Method(TransactionalAspect.java:54) 
sun.reflect.GeneratedMethodAccessor21.invoke(Unknown Source) 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccesso
rImpl.java:43)  java.lang.reflect.Method.invoke(Method.java:498) 
org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMetho
dWithGivenArgs(AbstractAspectJAdvice.java:620) 
org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMetho
d(AbstractAspectJAdvice.java:609) 
org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroun
dAdvice.java:68) 
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Re
flectiveMethodInvocation.java:168) 
org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(
ExposeInvocationInterceptor.java:92) 
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Re
flectiveMethodInvocation.java:179) 
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicA
opProxy.java:208)  com.sun.proxy.$Proxy26.runInTransaction(Unknown
Source) 
pl.edu.icm.unity.engine.endpoints.EndpointsUpdater.updateInternal(Endpo
intsUpdater.java:75) 
pl.edu.icm.unity.utils.ScheduledUpdaterBase.update(ScheduledUpdaterBase
.java:53) 
pl.edu.icm.unity.utils.ScheduledUpdaterBase.run(ScheduledUpdaterBase.ja
va:88) 
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
  java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) 
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.ac
cess$301(ScheduledThreadPoolExecutor.java:180) 
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.ru
n(ScheduledThreadPoolExecutor.java:294) 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.ja
va:1142) 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.j
ava:617)  java.lang.Thread.run(Thread.java:745)
-- 
Federated Systems and Data
Juelich Supercomputing Centre

phone: +49 2461 61 8847
fax: +49 2461 61 6656
email: sa....@fz...

-----------------------------------------------------------------------
-----------------------------------------------------------------------
Forschungszentrum Juelich GmbH
52425 Juelich
Sitz der Gesellschaft: Juelich
Eingetragen im Handelsregister des Amtsgerichts Dueren Nr. HR B 3498
Vorsitzender des Aufsichtsrats: MinDir Dr. Karl Eugen Huthmacher
Geschaeftsfuehrung: Prof. Dr.-Ing. Wolfgang Marquardt (Vorsitzender),
Karsten Beneke (stellv. Vorsitzender), Prof. Dr.-Ing. Harald Bolt,
Prof. Dr. Sebastian M. Schmidt
-----------------------------------------------------------------------
-----------------------------------------------------------------------