AWS Lambda: How to call Mysql Query in sequence

Question

I want to call more than one sql queries in sequence. I have tried with below code but getting timeout error:

    exports.handler = function (event, context, callback) {

   getNumber()
    .then(result1 => {
        // Use result1
        return getNumber1(); // (A)
    })
    .then(result2 => { // (B)
        console.log(result2);
        callback(null, "OK");
    })
    .catch(error => {
        console.log(error);
        callback(null, "OK");
    });
};

function getNumber() {

      return new Promise(function(resolve, reject) {

          connection.query("SELECT 1+1 as test ", (error, data) => {

            if (error) {
                reject(error);
            } else {
                resolve(data);
            }
            });
      }); 
    }

    function getNumber1() {

      return new Promise(function(resolve, reject) {

          connection.query("SELECT 1+2 as test ", (error, data) => {

            if (error) {
                reject(error);
            } else {
                resolve(data);
            }
            });
      }); 
    }

Here I'm getting 'Task timed out after 3.00 seconds' error. So anyone can help me to call connection.query synchronously.

@Ashan, single query, you mean to just call 'getNumber().then(....).catch(....) ? — vibhav bhavsar
– vibhav bhavsar, Commented May 22, 2018 at 19:46
Yes. Does it work? Just want to check whether the DB is accessible from Lambda. — Ashan
– Ashan, Commented May 22, 2018 at 19:47
@Ashan, I have updated my question by adding image for lambda function execution log. please check and kindly give you advice. Thanks! — vibhav bhavsar
– vibhav bhavsar, Commented May 22, 2018 at 19:56

Robin Varghese · Accepted Answer · 2018-05-22 18:34:09Z

0

This can be solved by chaining of AWS Lambda functions. So in this case, each function has to be separated into different lambda functions. Then call them in a chain.

Still, keep in mind that Lambda functions have the time limit and will exit. So you may need different architecture/AWS component to achieve this if the Lambda running time is more.

Invoke multiple aws lambda functions

answered May 22, 2018 at 18:34

Robin Varghese

1,1891 gold badge11 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

AWS Lambda: How to call Mysql Query in sequence

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related