Sequelize misbehaving with Node v14

[kororos]

Today I upgraded to Node v14. However, I run into some interesting issue, most probably with Sequelize.

The problem that I run into is that in a normal execution of my app, sequelize will never return from the queries. However, if I run my program using VSCode debug, it goes through without problems. I have tried it with both v5.21.7 and v6.0.0.-beta.5

Below is the package.json that I have. Note that CLS is not used for Sequelize. I was hoping to replace CLS with Node v14 AsyncLocalStorage.

{
  "name": "backend",
  "version": "1.0.0",
  "main": "app.js",
  "author": "",
  "license": "MIT",
  "scripts": {
    "start": "babel-node src/app.js",
    "dev": "nodemon --watch src --exec BABEL_DISABLE_CACHE=1 babel-node src/app.js",
    "lint": "eslint --fix src",
    "clean": "rimraf dist",
    "build": "babel src -d dist --source-maps --copy-files",
    "build_prod": "babel src -d dist --copy-files",
    "clean-build": "yarn run clean && yarn run build"
  },
  "devDependencies": {
    "@babel/cli": "^7.8.4",
    "@babel/core": "^7.9.0",
    "@babel/node": "^7.8.7",
    "@babel/preset-env": "^7.9.5",
    "babel-polyfill": "^6.26.0",
    "eslint": "^6.8.0",
    "jsdoc": "^3.6.4",
    "rimraf": "^3.0.2"
  },
  "dependencies": {
    "babel-plugin-inline-dotenv": "^1.5.0",
    "bcrypt": "^4.0.1",
    "body-parser": "^1.19.0",
    "continuation-local-storage": "^3.2.1",
    "cors": "^2.8.5",
    "express": "^4.17.1",
    "express-session": "^1.17.0",
    "jsonwebtoken": "^8.5.1",
    "nodemon": "^2.0.3",
    "pg": "^8.0.2",
    "pg-hstore": "^2.3.3",
    "sequelize": "^5.21.7",
    "sequelize-cli": "^5.5.1"
  }
}

[Vardiak]

I have the same problem, the sequelize.authenticate() method doesn't resolve, without any error.

[papb]

Hmm... Can someone please create a minimal reproducible example for this?

[tevonsb]

We are having the same issue. Will post a minimal example soon!

[tevonsb]

I can confirm that the issue is node v14, when we downgrade to 13.x.x the issue goes away. We are using sequelize 5.21.7.

The issue we experience is: any sequelize call (sync, findOne, etc) hangs indefinitely with no error messages. For us, this caused Heroku to time out our servers main process.

[papb]

The first hypothesis that comes to my mind is that something is wrong with Bluebird in Node 14...

[dioslibre]

The problem I think is in pg and not sequelize. sequelize.authenticate() doesn't resolve because pg.client.connect() doesn't. sqlite on the other hand works fine.

[kororos]

I have some findings. I tried with a very simple project and it worked. I examined the differences between the packages of this simple project and the project where I faced the issue that I reported and I noticed that in the working project, I had [email protected]. When I installed version 8.0.2 of pg it failed with node v14 (silently) but worked with version 13.13.0. With this in mind I believe that upgrading [email protected] may resolve the problem. Note, that [email protected] was only released yesterday.

When I upgraded the failing project to [email protected] it worked without a problem.

[dioslibre]

Yes @kororos, upgrading [email protected] did resolve the problem.

[papb]

By the way there has been some unexpected breaking changes in Node 14 regarding streams as well, not sure if related: nodejs/node#33050 and nodejs/node#32954

[ryosua]

Thanks @kororos ! Updating pg worked for me too.

[juberjj]

Thanks a lot @kororos upgrading [email protected] worked as it should.

[kd-krishna]

@tevonsb jeez thanks a lot , downgrading nodejs version did the trick. I was going mad as to what was going on.

[kororos]

@kd-krishna check my earlier comment above. Upgrading pg package resolved the issue (without having to downgrade node.js)

[kororos]

I accidentally closed the issue. Reopened it now.

[nickzelei]

I can confirm that upgrading to pg 8+ worked (with node 14.17.1)

    "pg": "8.6.0",
    "sequelize": "4.44.4"

Beforehand we had pg 6 + in one of our dependencies which caused a connect method to not resolve.

This worked for me as well. I'm upgrading a legacy system from node 12 to 14 and are almost on identical versions!

  "pg": "6.4.2",
  "sequelize": "4.44.0"

Bumping to [email protected] rectified this.

[eliasfeijo]

Same problem here, but bumping versions didn't work for me, I've tried node 14, 12 and 10, pg 8.7.1, sequelize 6.6.5... the program hangs on await connection.authenticate() and doesn't throw an error or timeout... in my case this bug started happening after I changed the database configuration of my application, but I've tested the connection running a script with pg only, and it works just fine with that same db config... I don't know what to do now, it's very frustrating that it only happens with sequelize and not with the pg script =/

[r0bynh00d]

I can confirm that the issue is node v14, when we downgrade to 13.x.x the issue goes away. We are using sequelize 5.21.7.

The issue we experience is: any sequelize call (sync, findOne, etc) hangs indefinitely with no error messages. For us, this caused Heroku to time out our servers main process.

You just saved me! I'd already spent 2+ days fighting with this issue in vain. Thank you.

[khaled]

FWIW, I ran into this problem when I upgraded from node:12.18.4-slim to node:12.22.6-bullseye-slim as my base container, using sequelize 6.6.5 and pg 7.18.2. I tried updating pg to 8.7.1 and it did not help. I reverted my base container to node:12.18.4-slim and the problem went away.

[github-actions]

This issue has been automatically marked as stale because it has been open for 7 days without activity. It will be closed if no further activity occurs. If this is still an issue, just leave a comment or remove the "stale" label. 🙂

[acharb]

Looks like the issue is for other Node versions as well. I ran into this problem of sequelize.authenticate() getting stuck when I upgraded a project from Node v10 to v16 (but thankfully saw this thread 😄 ), and going from pg ^7.4.3 to ^8.7.0 fixed it for me

[ranierimazili]

Same problem here, but with mysql...
I has having the problem with Node v12.22.1, so I updated to v14.18.2 and the problem persists.

"sequelize": "^6.11.0"
"mysql2": "^2.3.3"

[ranierimazili]

Just found the reason for my problem...
First I was trying findOne with the following code:

const organisationInfo: ITPSharedData = await ITPSharedData.findOne({ where: { organisation_id: "8292c33e-d95a-5fe7-8f27-dd7a95c68b55" } });

The code above was hanging without any error message... Then I tried with code below:

ITPSharedData.findOne({ where: { organisation_id: "8292c33e-d95a-5fe7-8f27-dd7a95c68b55" } })
        .then(a => {
            console.log(a);
        })
        .finally(() => {
            sequelize.close();
        });

And it "worked", showing the error message and the error was that sequelize was adding in the query the columns createdAt and updatedAt, and I don't have these columns on my table, so to make sequelize work without these columns I had to define my sequelize instance as below:

const sequelize = new Sequelize("mysql://<user>:<pass>@<server>:<port>/<db>",
    {   
        define: {
            timestamps: false
        }
    }
);    

and now my code with await works

[NeurAlch]

Had the same issue, no error or any message, updating the pg package worked for me while upgrading to Node 16.

Code had:

await database.authenticate();

This is on a legacy app with Sequelize 4. A google search took me here.

[ephys]

I'll close this issue as it's now documented that only pg 8 supports Node >= 14: https://sequelize.org/v6/manual/dialect-specific-things.html#postgresql

I would recommend upgrading to Sequelize 6, as Sequelize < 6 is not maintained anymore and we can't guarantee that they will continue working with more recent versions of node, or pg.

[IsmaelTerreno]

My good silent errors are the worst at all for any developer after 2 days. Anyway thanks for your tips, I upgraded to :
"pg": "^8.7.3", "pg-hstore": "^2.3.4", "sequelize": "^6.20.1", "sequelize-cli": "^6.4.1",
and my node version is v18.2.0.
After making the upgrade I can see typical errors and now works perfect.

Be careful devs and I hope this helps for some one else :)

[amzbiz]

Same issue for me, tried the error handling as recommended by others and still couldn't track down an error. Eventually identified that it was one of our internal packages node_modules that were the issue. I.e. they were old version of pg / sequelize etc. still. Once they were upgraded as well everything worked as expected.

[nitishsainani]

Issue happening with me tried almost all combinations above

[amzbiz]

Recently upgraded to Node 16 and had this issue again, was also further modules in one of our packages that needed to be upgraded to later versions, all postgres/database related.

[lualparedes]

My good silent errors are the worst at all for any developer after 2 days. Anyway thanks for your tips, I upgraded to : "pg": "^8.7.3", "pg-hstore": "^2.3.4", "sequelize": "^6.20.1", "sequelize-cli": "^6.4.1", and my node version is v18.2.0. After making the upgrade I can see typical errors and now works perfect.

Be careful devs and I hope this helps for some one else :)

Tried this and didn't work 😞

[benjaminHarroch]

i have the same issue , after changing all package to :
"pg": "^8.7.3", "pg-hstore": "^2.3.4", "sequelize": "^6.20.1", "sequelize-cli": "^6.4.1"

my node version is v16.7

some one please can help me?

[amzbiz]

Hi Benjamin, it's a matter of finding the right versions for your particular version of node, we were on 16.15 and using these versions which worked: "pg": "8.3.0", "pg-hstore": "2.3.3", "pg-promise": "10.9.1", "sequelize": "6.3.3". We used exact versions rather than allowing upgrade to make sure that they stayed working together.

[UmerMIB]

My good silent errors are the worst at all for any developer after 2 days. Anyway thanks for your tips, I upgraded to : "pg": "^8.7.3", "pg-hstore": "^2.3.4", "sequelize": "^6.20.1", "sequelize-cli": "^6.4.1", and my node version is v18.2.0. After making the upgrade I can see typical errors and now works perfect.

Be careful devs and I hope this helps for some one else :)

Didn't worked for me on ubuntu 20.04

[ConstantinTuca]

Upgrading the "pg" version also solved the problem for me
"pg": "8.11.3",
"sequelize": "6.37.3",
"node": "20.13.1"