AWS Lambda timeout

Question

I have an AWS Lambda function that connects to SQL DB and the timeout for lambda has been set to 120 seconds. But when there is some issue with the DB connection or query execution, lambda is getting timed out after 60 seconds. Below is my DB config. I used node-mssql module.

const DBConfig = {
    user: Config.DBUser,
    password: pswd,
    server: Config.DBHost,
    port: Config.DBPort,
    database: Config.DBName,
    connectionTimeout: 60000,
    requestTimeout: 60000,
    options: {
        encrypt: false
    }
}

Is your connection established outside of your handler function? — K Mo, Oct 30 '18 at 10:12

score 0 · Answer 1 · answered Oct 30 '18 at 03:54

0

This is because your connection is timing out when trying to connect to the database and you're not handling the timeout correctly inside the lambda function and there for your lambda will timeout.

answered Oct 30 '18 at 03:54

Chad Elias

637
6
7

score 0 · Answer 2 · answered Oct 30 '18 at 17:02

Lambda can not get timed out before its duration exceeds the configured timeout value. Other options for the execution termination are: - The handler function has finished. - An unhandled exception was raised. In NodeJS specifically, the error message in the Lambda logs will be: ‘process exited before completing request’ (though it doesn’t mean that there was a timeout). - There is an out of memory problem, but this doesn’t seem like your problem.

score 0 · Answer 3 · answered Mar 10 '21 at 01:57

0

Have you tried to increase the memory of your lambda function? In the past, when I bumped up the memory to 1GB+ this seems to have solved a number of connection problems for me.

answered Mar 10 '21 at 01:57

J00N

871
5
4

please do not ask questions in your answer. you can do that by adding comments. – Pejman Kheyri Mar 10 '21 at 07:13

AWS Lambda timeout

3 Answers3