RDS Missing Cloudwatch Metrics + Too many open files


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.

preguntada hace 3 años686 visualizaciones
1 Respuesta

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.

respondido hace 3 años

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas