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
已提問 3 年前檢視次數 685 次
1 個回答
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
已回答 3 年前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南