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

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


Here are the (redacted) env vars set on Heroku

DATABASE_URL: postgres://ForestAdmin:xxx
FORESTADMIN_URL: postgres://ForestAdmin: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

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?


Another remark:

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


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

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