9.1. Possible Issues #

9.1.1. Database Instance Log Access Errors #

Symptoms:

  • Instance log data is not being collected.

  • The following error messages are displayed in the collector log:

{
  "level": "error",
  "ts": 1733457921.250963,
  "msg": "Failed to open file",
  "kind": "receiver",
  "name": "filelog",
  "data_type": "logs",
  "component": "fileconsumer",
  "error": "open /var/log/postgresql/postgresql-2024-12-06.csv: permission denied"
}

Root cause: The filelog receiver cannot read the logs specified in its configuration.

Solution: Configure file access permissions and set an appropriate value for log_file_mode in the database instance configuration so that new log files are created with the required permissions.