Article ID: 128018, created on Jan 11, 2016, last review on Mar 9, 2016

  • Applies to:
  • Operations Automation 6.0
  • Operations Automation 5.5

Symptoms

After an attempt to manually run periodic task Synchronize resource usage for instances of APS applications the following error message is thrown:

Internal error: Resource usage synchronization is already in progress.

Cause

Task likely fails due to a database deadlock, please refer to #117637 "Database deadlocks in OA".

Resolution

Please collect the information on deadlocks by running query

plesk=> SELECT bl.pid AS blocked_pid, a.usename AS blocked_user,kl.pid AS blocking_pid, ka.usename AS blocking_user, a.current_query AS blocked_statement FROM pg_catalog.pg_locks bl JOIN pg_catalog.pg_stat_activity a  ON bl.pid = a.procpid JOIN pg_catalog.pg_locks kl JOIN pg_catalog.pg_stat_activity ka ON kl.pid = ka.procpid ON bl.transactionid = kl.transactionid AND bl.pid != kl.pid WHERE NOT bl.granted;

Restart PEM and PAU services (or only PEM service in case of OA <= 6.0) on osscore as described in #4642 "How to restart OA system services: UI, Management Node, Agents". To find out the root cause of the deadlock, please contact Odin technical support and provide the result of query above.

Search Words

POA TASK "Synchronize resource usage for instances of APS applications" already running

usage is not correct

Synchronize resource usage for instances of APS applications

Internal error: Resource usage synchronization is already in progress

POA TASK "Synchronize resource usage for instances of APS applications" blocked

Internal error: Resource usage synchronization is already in progress.

5356b422f65bdad1c3e9edca5d74a1ae caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07 956c448bddc7e1f3585373687602379f 6f1456866eed87488c0f02b298a741c0 5b048d9bddf8048a00aba7e0bdadef37 2554725ed606193dd9bbce21365bed4e

Email subscription for changes to this article
Save as PDF