applicaitons are unable to connect to rds-postgress after few hours

hello all,

I have a java & python based application which connects to db and stores data, I'm using postgress db (db.m5d.large) size with 12000 IOPS. Issue comes after few hours applications are unable to connect to db but if I reboot DB then able to establish connection again and work normal. So can anyone help on this what would be the cause and fix this issue.

主题

数据库

标签

PostgreSQL

语言

English

已提问 6 个月前222 查看次数

2 回答

最新
投票最多
评论最多

这些答案有用吗？为正确答案投票，以帮助社区从您的知识中受益。

Hi,

It's hard to say without additional information.

What the error message you have in app when trying to connect? Is it timeout or other type of error?
If application is not closing DB connections and initiating new it could be that you reached max connections limit
You need to check if anything suspicious in the DB logs or monitoring metrics
Check if you have latest minor version installed
Turn on Performance insights and check if anything suspicious there
Turn on GuardDuty for DB

It must give you a starting point for troubleshooting, if not helped feel free to provide more details.

专家

Dmytro Sirant

已回答 6 个月前

ap
6 个月前
thank you for providing some insight, I will check on last 5th & 6th point GuardDuty for DB & Performance insights for suspicious. But to answer your question,
point#1 => unable to accquire db connection (attached screenshot as well.) point#2 => I saw the connections as well it was not going beyond 50, so I don't think its issue with connection limits. point#3 => checked db monitoring as well, I saw there EBSByteBalance% & EBSIOBalance% showing almost 99%+. point#4 => recently launched db, so nothing upgraded till now. If you need more details then please let me know and help me.
Dmytro Sirant 专家
6 个月前
Could you please show the settings of Security Group(s) attached to the RDS DB?

5 个月前

Hi Sirant, Sorry for late response, following are my observations -

my security group allows all traffic to the vpc cidr address i.e (10.0.0.0/16) and application is deployed in the same vpc.

RDS is in private subnet
Application is in public subnet So application is starts up and run for some hours may be 24-30 hours or more then that but after sometime if application want to connects to db at that time it fails so at that time tried 2 things i.e -
restarting application -> after restart application doesn't come up and it get stuck at the connection to DB (screenshot attached above)
restarting DB -> if DB is restarted then application starts creating connection and boots up runs fine. My DB configuration is db.m5d.large and connections goes up to 35-40 max. Can you tell me what could be the issue here ?

point#1 => Enter image description here point#3 =>

已回答 6 个月前

Dmytro Sirant 专家
6 个月前
These metrics in a good state, there is no problem.

applicaitons are unable to connect to rds-postgress after few hours

相关内容