Node js (Express js) Mysql read ECONNRESET error [duplicate]

Question

var express = require('express');
var mysql = require('mysql');
var connection = module.exports = mysql.createConnection({
  host: 'myhost.com',
  port:'3307',
  user: 'username',
  password: 'password',
  database: 'mydatabase'
});

connection.connect(function(err) {
  if (err){
    throw err;
  }
  else
  console.log('You are now connected...');
});

Sometimes when I try to connect to the database I get read ECONNRESET error. Please help. I tried many things, but nothing seems to work.

putuyuwono · Accepted Answer · 2017-07-08 02:35:52Z

1

You can find the solution in this answer: https://stackoverflow.com/a/22906189/1790397

MySQL does indeed prune idle connections. There's a MySQL variable "wait_timeout" that sets the number of second before timeout and the default is 8 hours. We can set the default to be much larger than that. Use show variables like 'wait_timeout'; to view your timeout setting and set wait_timeout=28800; to change it.
According to this issue, node-mysql doesn't prune pool connections after these sorts of disconnections. The module developers recommended using a heartbeat to keep the connection alive such as calling SELECT 1; on an interval. They also recommended using the node-pool module and its idleTimeoutMillis option to automatically prune idle connections.

answered Jul 8, 2017 at 2:35

putuyuwono

11910 bronze badges

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

2 Comments

Darshana Over a year ago

You should have put this as a comment to the answer. Shouldn't have repeat things.

putuyuwono Over a year ago

Cannot do that since I don't have enough reputation.

double-beep · Accepted Answer · 2019-08-05 13:49:02Z

0

You can use connection variable .timeout function:

connection.timeout = 0;

edited Aug 5, 2019 at 13:49

double-beep

5,67019 gold badges43 silver badges50 bronze badges

answered Aug 5, 2019 at 13:40

Lazy Programmer

354 bronze badges

Collectives™ on Stack Overflow

Node js (Express js) Mysql read ECONNRESET error [duplicate]

2 Answers 2

2 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Linked

Related