Missing datasource after upgrade to v7

Issue Summary

Upgraded redash from v5 to v7 using and after that data source do not appaear on the redash console but the record exists in postgres database in encrypted version

Technical details:

  • Redash Version:7.0.0+b18042 . earlier version 5.0.2
  • Browser/OS:Chrome
  • How did you install Redash: Using docker image and deployment using ECS on AWS

docker images -a
docker run -it 0a8d2ac57b83 bash
export REDASH_DATABASE_URL=“postgresql://svc_redash:xxxxxx@xxxxxx/postgres”
export REDASH_REDIS_URL=“redis://redis.redashxxxxxxxx.net:6379/0”
bin/run ./manage.py check_settings
bin/run ./manage.py db upgrade

more details about the environment could be found on the below thread

even adding new data sources are not being visible in console but data exists in the table

Did you run the database migrations during your upgrade? Data source information is now encrypted in the Redash database. I wonder if that has something to do with what you’re seeing.

i ran the below command for the upgrade
bin/run ./manage.py db upgrade

shall i try without the upgrade to see if it works fine or not?even adding new data sources does not appear on console which is very weird

Have you had any success with this?

@samirs Have you managed to find a solution for this? I’m also suffering from the same issue and couldn’t find any solution, so far.

no solutions yet and we have to postpone the upgrade for prod because of this

Did your secret key change, by chance, during the upgrade?

no change to secret key