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
feita há 3 anos685 visualizações
1 Resposta
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
respondido há 3 anos

Você não está conectado. Fazer login para postar uma resposta.

Uma boa resposta responde claramente à pergunta, dá feedback construtivo e incentiva o crescimento profissional de quem perguntou.

Diretrizes para responder a perguntas