AWS Serverless lambda times out while connecting to redshift

Question

I am getting constant timeout while connecting from AWS lambda to redshift.

I get Timeout exception from my python code

I have already added the vpc section:

  vpc:
    securityGroupIds:
      - sg-xxxxxxx
    subnetIds:
      - subnet-xxxxxxx

So whats happenign here?

score 3 · Answer 1 · answered Jan 19 '21 at 10:21

To troubleshoot this issue, you can use following steps;

Use VPC Reachability Analyzer : Create and analyze path with Source type Network Interfaces and Source as Network Interface Id of the your AWS Lambda. Furthermore, select Destination type as Network Interfaces and Destination as network Interface Id of the AWS Red Shift. Put Destination port as 5439 or the communication port you are using, keep Protocol as TCP.

Note: It takes few minutes for completion of this path analysis.*

OR

If you have enabled VPC Flow Logs, then you can trace vpc flow logs to check, which AWS resource is rejecting the network traffic.

Note: It takes few minutes to load vpc network flow logs in aws cloudwatch

1 Answers1