Migration to v7. Works 99%, just the production DB never returns query results

Help me!
1

Expected behavior

I step through the V6 to V7 upgrade for the ExpressJs / Sequelize upgrade. It works 100% on our local / dev setup. I push to production on Heroku and everything loads and authenticates. Just the queries do not return.

Actual behavior

I can see the initial count queries that are run on our standard Forest dashboard never return. They timeout after 30 seconds. Note that rolling back to V6 fixes everything. My gut feeling is that somewhere between the new databases.js config and the ENV variables something is missing or wrong and I missed this in the upgrade guide.

Again, I can see the requests coming in, being authenticated and then never returning.

Failure Logs

Context

Here are the (redacted) env vars set on Heroku

DATABASE_SSL: true
DATABASE_URL: postgres://ForestAdmin:xxx
FORESTADMIN_URL: postgres://ForestAdmin:xxxx
FOREST_AUTH_SECRET: xxxx
FOREST_ENV_SECRET: xxxx
NODE_ENV: production
PGSSLMODE: require
APPLICATION_URL: “the domain of the Heroku app”

  • Package Version: 7.0.0
  • Express Version: 4.17.1
  • Sequelize Version: 5.21.3
  • Database Dialect: Postgres
  • Database Version: 10.18
  • Project Name: Checkly
2

Hi @Tim_Nolet,

Can you please:

  • go to version last of 7 (it’s 7.12.2)
  • put a console.log in the ‘forest/[model-name].js’ file, can you reach it?

Regards

3

Another remark:

Updating your pg (postgres driver version) may helps.
Please let me know.

Regards

4

I managed to get this running. It was jumping from error to error though. The last one I had to tackle was DATABASE_REJECT_UNAUTHORIZED

5

Happy to hear that everything is up and running @Tim_Nolet. Let us know if you encounter any other issue. :slight_smile: