The information you are about to copy is INTERNAL!
DO NOT share it with anyone outside Check Point.
The postgres.elg file keeps growing
Technical Level
Solution ID
sk143852
Technical Level
Product
Security Management, Multi-Domain Management
Version
R80, R80.10, R80.20
OS
Gaia
Date Created
03-Jan-2019
Last Modified
16-Sep-2019
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.