Failed after upgrading docker image

Support
1

Hi Redash Team! Hope you’re all well.

Info:
Docker version: 1.13.1
Currently deployed:
Redash 3.0.0+b3134
redis:3.0-alpine
postgres:9.5.6-alpine

Scenario:
I have redash running in docker and wanted to upgrade it with the latest version.
What I did is migrate my postgres data to new server and use docker-compose.yml and run docker-compose up
Unfortunately I’m stuck with this error in postgres;
ERROR: column queries.search_vector does not exist at character 792
and in worker;
ProgrammingError: (psycopg2.ProgrammingError) column queries.search_vector does not exist

Tried searching complete guide to upgrade Redash docker image but found only a very basic setup which doesn’t work for me.

Please guide me how to do it properly; its been 1 week of searching guides to fix it but failed to find a thing.

Hoping for your soonest response.

2

Hi,

You need to apply migrations. You can do with something like:

docker-compose run --rm server manage db upgrade

You might need to change the name of the service (server), depends on your configuration.

3

Thanks a lot for you prompt response! :slight_smile:
Already did that but still got the same result. :cry:

ERROR: column queries.search_vector does not exist at character 792

Additional info about my existing redash, I just used the docker-compose.production.yml default to bring up the cluster, i just added google and cookie key that’s the only changes i made.

4

Do you have something like this guide for Docker? https://redash.io/help/open-source/admin-guide/how-to-upgrade.
Simply pulling the latest redash image and using existing postgres DB doesn’t work. :disappointed:
Even running “docker-compose run --rm server manage db upgrade” before and or after pulling latest docker image has no difference, still fails.

Also have tried this process but still no avail;

  1. Update the image reference to redash/redash:4.0.0.b3948.
  2. Stop services.
  3. Apply migrations (docker-compose run --rm server manage db upgrade).
  4. Start everything with docker-compose up.
5

Anybody please help. Does anyone encounter the same and solved it?

6

i have managed to upgrade the database as such:

Stop worked and scheduler containers.
Update server to the desired version.

Get into the server container and run

python manage.py db upgrade

update scheduler and workers.

other than this, follow the steps here: https://github.com/getredash/redash/releases

1 Like