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
profile picture
asked 3 months ago169 views
1 Answer
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
Regina
answered 3 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions