跳至內容

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

已提問 3 年前檢視次數 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

已回答 3 年前

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

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