Issue Summary
I am trying to upgrade my redash setup on k8 from v8 to v10. I am using external redis and postgre. After the upgrade, two pods give me an error which is stated below. Would appreciate any help that I can get.
We are using k8 based deployments on this repo - GitHub - getredash/contrib-helm-chart: Community maintained Redash Helm Chart
Some extra details: In the VM based docker composer, I have run the below command to upgrade db’s. Is this issue happening due to that? What is the equivalent command to run in k8 setup to upgrade it?
docker-compose run --rm server manage db upgrade
redash-bigquery-tools-scheduledworker - Crashes
logs - Starting RQ scheduler…
[2022-04-08 05:39:55,024][PID:7][INFO][rq_scheduler.scheduler] Registering birth
Traceback (most recent call last):
File “/app/manage.py”, line 9, in
manager()
File “/usr/local/lib/python3.7/site-packages/click/core.py”, line 722, in call
return self.main(*args, **kwargs)
File “/usr/local/lib/python3.7/site-packages/flask/cli.py”, line 586, in main
return super(FlaskGroup, self).main(*args, **kwargs)
File “/usr/local/lib/python3.7/site-packages/click/core.py”, line 697, in main
rv = self.invoke(ctx)
File “/usr/local/lib/python3.7/site-packages/click/core.py”, line 1066, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/usr/local/lib/python3.7/site-packages/click/core.py”, line 1066, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/usr/local/lib/python3.7/site-packages/click/core.py”, line 895, in invoke
return ctx.invoke(self.callback, **ctx.params)
File “/usr/local/lib/python3.7/site-packages/click/core.py”,
redash-bigquery-tools-upgrade-c29mj - Gets stuck in error state.
Logs -
Status: Traceback (most recent call last):
File “/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py”, line 1249, in _execute_context
cursor, statement, parameters, context
File “/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/default.py”, line 580, in do_execute
cursor.execute(statement, parameters)
psycopg2.errors.UndefinedColumn: column dashboards.options does not exist
LINE 2: …rds_is_draft, dashboards.tags AS dashboards_tags, dashboards…
^
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File “/app/manage.py”, line 9, in
manager()
File “/usr/local/lib/python3.7/site-packages/click/core.py”, line 722, in call
return self.main(*args, **kwargs)
Technical details:
- Redash Version: v8 - v10
- Browser/OS:
- How did you install Redash: Through helm
