Support Center > Search Results > SecureKnowledge Details
'postgres' process on SmartEvent server consumes CPU at high level
Symptoms
  • 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
    
Solution
Note: To view this solution you need to Sign In .