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

@jesse please help/someone from team . We couldn’t migrate the setup in Kubernetes for new version of Redash

Hey there, the k8s helm distribution is not maintained by the core team. We hope to have better documentation around this at some point but at present none of us have worked with Redash on k8s :frowning:

I’ve done this migration on K8S few months ago
At that time, I had to cherry pick this commit: WIP: Changes required for redash v9 by jimsparkman · Pull Request #36 · getredash/contrib-helm-chart · GitHub

It has been merged on a fork.

1 Like