Schedule Analytics tables updating causing deadlock?

Support - Assistance technique
#1

I got the following error （not allways）, can’t login, system stop response:

  • INFO 2021-09-08T14:46:12,471 Analytics tables updated: 00:00:00.959 (NotificationLoggerUtil.java [taskScheduler-13])
  • INFO 2021-09-08T14:46:12,477 ‘system-process’ update org.hisp.dhis.schedulinedulbConfiguration, name: shorttime_update , uid: wP2viSaWahc (AuditLogUtil.java [taskSch
    er-13])
  • WARN 2021-09-08T14:55:18,982 com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@22f2ccda – APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks! (Slf4jMLog.java [C3P0PooledConnectionPoolManager[identityToken->1bqrxewaj1cxc6wyz791l6|56e0106e]-AdminTaskTimer])
  • WARN 2021-09-08T14:58:34,604 com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@22f2ccda – APPARENT DEADLOCK!!! Complete Status:
    Managed Threads: 3
    Active Threads: 3
    Active Tasks:
    com.mchange.v2.resourcepool.BasicResourcePool$1RefurbishCheckinResourceTask@19662bc2
    on thread: C3P0PooledConnectionPoolManager[identityToken->1bqrxewaj1cxc6wyz791l6|56e0106e]-HelperThread-#2
    com.mchange.v2.resourcepool.BasicResourcePool$1RefurbishCheckinResourceTask@2101892f
    on thread: C3P0PooledConnectionPoolManager[identityToken->1bqrxewaj1cxc6wyz791l6|56e0106e]-HelperThread-#0
    com.mchange.v2.resourcepool.BasicResourcePool$1RefurbishCheckinResourceTask@214d0f87
    on thread: C3P0PooledConnectionPoolManager[identityToken->1bqrxewaj1cxc6wyz791l6|56e0106e]-HelperThread-#1
    Pending Tasks:
    com.mchange.v2.resourcepool.BasicResourcePool$1RefurbishCheckinResourceTask@70b6d0a1
    com.mchange.v2.resourcepool.BasicResourcePool$1RefurbishCheckinResourceTask@5826cd4e
    com.mchange.v2.resourcepool.BasicResourcePool$1RefurbishCheckinResourceTask@75437f94
    com.mchange.v2.resourcepool.BasicResourcePool$1RefurbishCheckinResourceTask@3cbb778c
    com.mchange.v2.resourcepool.BasicResourcePool$1RefurbishCheckinResourceTask@7ace8b62
    com.mchange.v2.resourcepool.BasicResourcePool$1RefurbishCheckinResourceTask@14ec65c8
    com.mchange.v2.resourcepool.BasicResourcePool$1RefurbishCheckinResourceTask@7a3d171e
    com.mchange.v2.resourcepool.BasicResourcePool$1RefurbishCheckinResourceTask@1d5d18c2
    Pool thread stack traces:
    Thread[C3P0PooledConnectionPoolManager[identityToken->1bqrxewaj1cxc6wyz791l6|56e0106e]-HelperThread-#2,1,main]
    com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:720)
    Thread[C3P0PooledConnectionPoolManager[identityToken->1bqrxewaj1cxc6wyz791l6|56e0106e]-HelperThread-#0,1,main]
    com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:720)
    Thread[C3P0PooledConnectionPoolManager[identityToken->1bqrxewaj1cxc6wyz791l6|56e0106e]-HelperThread-#1,1,main]
    com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:720)
    (Slf4jMLog.java [C3P0PooledConnectionPoolManager[identityToken->1bqrxewaj1cxc6wyz791l6|56e0106e]-AdminTaskTimer])
  • INFO 2021-09-08T14:59:01,065 ‘system-process’ update org.hisp.dhis.schedulinedulbConfiguration, name: shorttime_update , uid: wP2viSaWahc (AuditLogUtil.java [taskSch
    er-3])
#2

Hey @linxd,
Please see if you have any long running queries or deadlocks in the DB? And, please share the dhis.conf for the db thread pool.

#3

dhis.conf has no specifial db pool setting.

1 Like
#4

Then it’s the default setting which I think is good, so you’ll have to check the DB.