RDS Missing Cloudwatch Metrics + Too many open files

0

We're currently experiencing an issue with our RDS instance, where the cloudwatch dashboard is only reporting CPU for the instance (no metrics for database connections, ReadIOPS, WriteIOPS, etc).

We're also seeing a large number of errors in the logs like:
2021-08-02 15:28:26 UTC::@:[74500]:LOG: could not open log file "/rdsdbdata/log/error/postgresql.log.2021-08-02-15": Too many open files in system

This is a db.r4.8xlarge postgresql instance. I'm not quite sure why cloudwatch isn't showing any metrics for this, but I have a feeling it's likely related to the open files issue. This is relatively high priority for us, so any help is appreciated.

rochadt
gefragt vor 3 Jahren687 Aufrufe
1 Antwort
0

For what it's worth, we ended up lowering the max_files_per_process for postgres, which resolved the issue with file descriptors, and everything seemed to start working again.

rochadt
beantwortet vor 3 Jahren

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen