Support Center > Search Results > SecureKnowledge Details
The postgres.elg file keeps growing
Symptoms

  • The postgres.elg file grows and fills up the disk space.

  • The postgres.elg contains the following messages:

    [DATE TIME PID] 82/48522802 ERROR: could not serialize access due to concurrent update
    [DATE TIME PID] 3798265791 82/48522802 CONTEXT: SQL statement "SELECT 1 FROM ONLY "public"."gateways" x WHERE "obj_id" OPERATOR(pg_catalog.=) $1 FOR SHARE OF x"
    [DATE TIME PID] 82/48522802 STATEMENT: WITH UPSERT AS (UPDATE blade_status SET update_date = $1 , status_code = $2 , status_short_desc = $3 , status_long_desc = $4 WHERE obj_id = $5 AND status_blade_name = $6 RETURNING obj_id , status_blade_name ) INSERT INTO blade_status ( update_date , status_code , status_short_desc , status_long_desc , obj_id , status_blade_name ) SELECT $7 , $8 , $9 , $10 , $11 , $12 WHERE NOT EXISTS (SELECT 1 FROM UPSERT)

Cause

The monitoring Database is operating in a 'repeatable read' mode.


Solution
 Note: To view this solution you need to Sign In .