Schedule Analytics tables updating causing deadlock?

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])

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.

dhis.conf has no specifial db pool setting.

1 Like

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