跳至内容

RDS Proxy causes intermittent "Connection timed out" errors

0

We have a SQLServer RDS Instance configured with a RDS Proxy in front of it. Connections direct to the database work fine reliably with no errors ever. Connection via the Proxy intermittently fail with Connection/Connection timed out error. Errors occur with the proxy in the following instances:

  • From PHP code using the latest SQL Server linux driver
  • From Dbeaver - using the latest JDBC SQL Driver We've been unable to replicate the error when using microsoft sql server management studio

已提问 2 年前819 查看次数

1 回答
0

Hi, I would recommend to check for any network-related issues between the connecting clients and the proxy endpoint that could cause delays. Ensure no security or firewall rules would block or slow traffic. (include Security group) Also verify the clients are connecting with TLS enabled as required by the proxy. Without encryption, connections may time out. And Review any application-level timeouts configured in the PHP code or JDBC driver. These could cause premature timeouts if higher than the underlying network timeouts. if there is ttl setting, try increasing various connection/read timeout values temporarily to see if errors still occur, which may provide clues. For gather more information check the RDS Proxy access logs for any errors or response delays that coincide with the connection failures.

AWS

已回答 2 年前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。