'Cannot read property replace of null' sequelize error

OdinSon · December 29, 2020, 2:29pm

I have a working app perfectly on my local pc with development mode. I switched to heroku, and configured NODE_ENV variable. Somehow it does not work in production mode it is giving me this error:

"atlassian-connect-express": "^6.2.3",
"sequelize": "^6.3.5",

/app/node_modules/sequelize/lib/sequelize.js:1
TypeError: Cannot read property 'replace' of null
    at new Sequelize (/app/node_modules/sequelize/lib/sequelize.js:187:43)
    at new SequelizeAdapter (/app/node_modules/atlassian-connect-express/lib/store/sequelize.js:59:33)      
    at module.exports (/app/node_modules/atlassian-connect-express/lib/store/sequelize.js:186:10)
    at Function.stores.create (/app/node_modules/atlassian-connect-express/lib/store/index.js:20:10)        
    at stores (/app/node_modules/atlassian-connect-express/lib/store/index.js:12:17)
    at new Addon (/app/node_modules/atlassian-connect-express/lib/index.js:35:38)
    at module.exports (/app/node_modules/atlassian-connect-express/lib/index.js:231:10)
    at Object.<anonymous> (/app/app.js:57:15)
    at Generator.next (<anonymous>)

ndao · January 6, 2021, 4:32am

sequelize code:

github.com

sequelize/sequelize/blob/v6.3.5/lib/sequelize.js

'use strict';

const url = require('url');
const path = require('path');
const retry = require('retry-as-promised');
const _ = require('lodash');

const Utils = require('./utils');
const Model = require('./model');
const DataTypes = require('./data-types');
const Deferrable = require('./deferrable');
const ModelManager = require('./model-manager');
const Transaction = require('./transaction');
const QueryTypes = require('./query-types');
const TableHints = require('./table-hints');
const IndexHints = require('./index-hints');
const sequelizeErrors = require('./errors');
const Hooks = require('./hooks');
const Association = require('./associations/index');
const Validator = require('./utils/validator-extras').validator;

This file has been truncated. show original

atlassian-connect-express code:
https://bitbucket.org/atlassian/atlassian-connect-express/src/v6.2.3-0/lib/store/sequelize.js

I guess the DB connection URL in your Heroku environment is not as you expect.
Please try logging it out to check if it’s correct.

YashShivhare · January 22, 2022, 4:05pm

Hello, can you provide us some source so that we know, how to get this DB Connection URL, or we have to create our own Postgres database and put that URL in the heroku environment?