挂在AWS Lambda上的数据库连接

Question

I am trying to do basic db connection in AWS Lambda with Go, and for some reason, it got stuck at db.prepare() and no log is presented in cloudwatch.

func Handler(request Request) (Response, error) {

    db, err := sql.Open("mysql", dbUsername+":"+dbPassword+"@tcp("+dbURL+":"+dbPort+")/"+dbName)
    if err != nil {
        log.Fatal(err)
    }
    defer db.Close()
    stmt, err := db.Prepare("SELECT id, password FROM package_passwords WHERE password = ?")
    return Response{
        Message: "rows",
        Ok:      false,
    }, nil
}

weird thing is that the code above stuck at least more than 5 second in AWS Lambda while it works fine in plain go run/ go build.

Answer 1

If it is a RDS operation, I think it is getting timeout. The default timeout of a lambda function is 6 seconds and therefore it is getting timeout before the operation finishes with RDS. To avoid this you do not have to increase the timeout. Instead of that you can make "callBackWaitsForEmptyEventLoop" false as your first line of code in lambda function.