EM logs filling up with debug entries from PostgreSQL

Products

• CA Application Performance Management (APM / Wily / Introscope)
• CA Application Performance Management Agent (APM / Wily / Introscope)
• CA Application Performance Management SaaS
• APM
• DX APM SaaS

Issue/Introduction

We have a disk space problem, the em.log file keeps growing and occupies too many gigabytes.

It is continuously reporting postgres activity. How can we deactivate it?

Example of the data appeared in the em.log file:

Dec 01, 2023 2:05:05 PM org.postgresql.core.v3.QueryExecutorImpl execute
FINEST:   simple execute, handler=org.postgresql.jdbc.PgStatement$StatementResultHandler@1d80757b, maxRows=0, fetchSize=0, flags=20
Dec 01, 2023 2:05:05 PM org.postgresql.core.v3.QueryExecutorImpl sendBind
FINEST:  FE=> Bind(stmt=S_1,portal=null,$1=<'2023-12-01 07:09:40.62+00'>,type=UNSPECIFIED,$2=<'2023-12-01 13:00:15.255+00'>,type=UNSPECIFIED,$3=<id>,type=INT8,$4=<'{"type":".AlertEventStatement","version":"10.8_1","suspect":{"vertexId":"id","name":"<name>|JBoss|objname"},"firstOccurrence":1701414580620,"lastOccurrence":1701435615255,"alertInfo":[{"alertId":"SuperDomain:Default:Heap Used Percent"}],"eventType":"ALERT","alertsCount":1}'>,type=VARCHAR,$5=<1>,type=INT4,$6=<1704>,type=INT4,$7=<'3070'>,type=VARCHAR,$8=<'AlertEventStatement'>,type=VARCHAR,$9=<86>,type=INT4)
Dec 01, 2023 2:05:05 PM org.postgresql.core.v3.QueryExecutorImpl sendExecute
FINEST:  FE=> Execute(portal=null,limit=1)

 

Environment

APM 10.8

Cause

The entries filling up the em.log correspond to Postgres. By default, the Postgres log level is controlled by a global configuration file, logging.properties, in the lib folder of the Java installation directory.

e.g.

\CA APM\Introscope10.8.0.27\jre\lib\logging.properties

Based on the log, you probable have an entry like this:

 

org.postgresql.level = FINEST

 

This is the highest value for the logging.

 

Possible values are:

SEVERE > WARNING > INFO > CONFIG > FINE > FINER > FINEST > OFF

 

Resolution

Reduce the level of log details by following these steps:

- Open  \CA APM\Introscope10.8.0.27\jre\lib\logging.properties

- Search for org.postgresql.level

- Set to a lower value, for example:

     org.postgresql.level = FINE

- Save changes