Handler error when connecting lambda function to RDS database

Question

I am trying to follow the tutorial in https://docs.aws.amazon.com/lambda/latest/dg/services-rds-tutorial.html to connect a lambda function to my database. I did not create a database from the tutorial, as I am trying to connect to an existing database. Whenever I run the code

aws lambda invoke --function-name CreateTableAddRecordsAndRead output.txt

I get the following error:

{"errorMessage": "Handler 'handler' missing on module 'app'", "errorType": "Runtime.HandlerNotFound", "stackTrace": []}.

I don't have any error with creating the lambda function. Does anyone know how I can fix this?

Answer

Try renaming handler(event, context) with lambda_handler(event, context) in app.py

Answer

you need to upload pymysql to your lambda fucntion as layer. Than you need to update your lamda script ....lambda_handler (event, context)

Handler error when connecting lambda function to RDS database

Relevant questions

Internal Server Error from API Gateway when sending queries through gateway to Lambda function connected to RDS database

How to export environment variables from a Lambda function.

is it possible that SQS Triggers to a Lambda Function Alias?

Is there a way to recover the deleted lambda function?

Handler error python lambda function

Timeout error accesing MySql RDS from a Lambda function

Error connecting to Aurora PostgreSQL dB in .NET Core Lambda function.