The information you are about to copy is INTERNAL!
DO NOT share it with anyone outside Check Point.
The postgres.elg file keeps growing
| Solution ID |
sk143852 |
| 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.
Solution
|
Note: To view this solution you need to
Sign In
.
|
