how to catch Sequelize connection error

Question

How to catch a sequelize connection error in case there is one?

I tried to do

var connection = new Sequelize("db://uri");
connection.on("error", function() { /* perhaps reconnect here */ });

but apparently this is not supported.

I wanted to do this because I think sequelize might be throwing an occasional unhandled ETIMEOUT and crashing my node process.

Currently I am using sequelize to connect a mysql instance. I only need it for like 2-3 hours and during that time I will be doing a many read queries. The mysql server will not be connected to anything else during that time.

Answer 1

Using sync() for this is considerably dangerous when using external migrations or when database integrity is paramount (when isn't it!)

The more up-to-date way of doing this is to use authenticate()

sequelize
  .authenticate()
  .then(() => {
    console.log('Connection has been established successfully.');
  })
  .catch(err => {
    console.error('Unable to connect to the database:', err);
  });