'postgres' process on SmartEvent server consumes CPU at high level
||SmartEvent / Eventia Analyzer
|Platform / Model
postgres process on SmartEvent server consumes CPU at high level.
The following command can be used in expert mode to view the Postgres Processes resources usage:
# ps -C postgres -o %cpu,%mem,cmd
postgres debug shows:
ERROR: deadlock detected
DETAIL: Process <PID1> waits for ShareLock on transaction XXX; blocked by process <PID2>.
Process <PID2> waits for ShareLock on transaction XXX; blocked by process <PID1>.
STATEMENT: Update Source set hostname='HOSTNAME' where (EventID >= NNN) AND (IP = [IP Address]) AND (hostname IS NULL)
ERROR: current transaction is aborted, commands ignored until end of transaction block
Note: To view this solution you need to