Handling Azure SQL errors in Node

Question

I'm using Azure MySQL database in my Node application which works fine except that after few minutes of usage, Azure closes the connection and Node throws error:

Error: read ECONNRESET

What I need is to prevent my Node app from crashing and tell it to reconnect after such exception. I have tried:

var con = mysql.createConnection({
  host: "mydatabase.mysql.database.azure.com",
  user: "nodeapp@mydatabase",
  password: "12345",
  database: "mydatabase",
  port: 3306
});

    process.on('uncaughtException', function(err) {
      con.destroy();
      con.connect();
      console.log(err);
    });

This prevents app from crashing, but my app cannot write to database after this so reconnection fails. How should I reconnect after such error? Any advise is highly appreciated.

Any advise guys? I'm not looking for the source of error, rather some way to reconnect when error occurs. — Mr. Engineer
– Mr. Engineer, Commented Apr 12, 2021 at 11:40

Doris Lv · Accepted Answer · 2021-04-14 01:32:41Z

0

Reproduced your error: Throw the below error after connecting about 3 minutes.

The reason seems to be some settings on your database like this: wait_timeout=180.

My solutions:

1. raise the value of wait_timeout:

2. If this happens when establishing a single reused connection, it can be avoided by establishing a connection pool instead. See this post.

edited Apr 14, 2021 at 1:32

answered Apr 13, 2021 at 10:11

Doris Lv

3,4261 gold badge8 silver badges16 bronze badges

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

2 Comments

Mr. Engineer Over a year ago

Thanks for taking the effort. Yeah the exception handling code prevents app from crashing but unfortunately does not reconnect properly. But raising the value of timeout parameter should work, thanks.

Doris Lv Over a year ago

Glad to hear it helps, I would delete the useless part in my answer.

Collectives™ on Stack Overflow

Handling Azure SQL errors in Node

1 Answer 1

My solutions:

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

My solutions:

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related