Error: read ECONNRESET when connected to a mysql server with Node.js

Question

I'm trying to establish a simple connection to my database with the mysql npm package. At first glance, everything works fine and I can get the information I need, however, if I leave the server running for some time I get the following error:
Error: read ECONNRESET at TCP.onStreamRead

const express = require('express');
const app = express();`

const mysql = require('mysql');

 const db = mysql.createConnection({
  host: 'XXXX.mysql.database.azure.com',
  user: 'XXXXX',
 password: 'XXXXX',
 database: 'XXXXX'

})
    db.connect((err)=>{
    if(err){
       console.log(err.message);
    } else {
        console.log('Connected to the database');
    }
})

As far as I understand the problem stems from the database connection being in idle mode. Do I need to configure the Azure server or is there something else I need to do?

Try it with mysql workbench and see if it can get a connection. If not see if there is an error learn.microsoft.com/en-us/azure/azure-monitor/app/… maybe a restart helps. — nbk
– nbk, Commented Nov 3, 2019 at 22:36
Tried it with the workbench, tried restarting the database, no luck so far.. — Tachevv
– Tachevv, Commented Nov 3, 2019 at 22:57
contact the support.I am wondering why nothing shows up in the logs. — nbk
– nbk, Commented Nov 3, 2019 at 23:11

Mohit Verma · Accepted Answer · 2019-11-04 03:51:53Z

1

Couple of things to try:

You can try creating connection pool instead of **createConnection**

mysql.createPool({});
Modify your package.json like below:

    "dependencies": {
        "mysql": "git://github.com/mysqljs/mysql#e3e123e9af7c0829a6c1417d911572a75b4a5f95"
      },

It is described in detail here:

Bad handshake or ECONNRESET Azure Mysql Nodejs

https://social.msdn.microsoft.com/Forums/en-US/c8fedbcc-909d-41ce-8c72-0374f76fdf82/cannot-connect-from-nodejs?forum=AzureDatabaseforMySQL

Hope it helps.

answered Nov 4, 2019 at 3:51

Mohit Verma

5,3002 gold badges14 silver badges28 bronze badges

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

3 Comments

Tachevv Over a year ago

It seems the createPool solved the problem. Thank you for your help and sorry for the late reply!

Mohit Verma Over a year ago

Glad to know it helped!!

Nithur Over a year ago

@MohitVerma can you explain how this works? and why that error happens?

Collectives™ on Stack Overflow

Error: read ECONNRESET when connected to a mysql server with Node.js

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related