How to upgrade redash 0.6.1b857 → 0.11


#1

i used redash versiong 0.6.1b857
recently i try to upgrade redash version 0.6.1b857 → 0.11

but i found that there has some issue.

======================================================
[Error Log]

  1. re:dash server log
    File “/usr/local/lib/python2.7/dist-packages/peewee.py”, line 2922, in exit
    reraise(new_type, new_type(*exc_value.args), traceback)
    File “/usr/local/lib/python2.7/dist-packages/playhouse/postgres_ext.py”, line 360, in execute_sql
    cursor.execute(sql, params or ())
    ProgrammingError: column t1.org_id does not exist
    LINE 1: … “t1”.“id”, “t1”.“updated_at”, “t1”.“created_at”, “t1”."org_…
    =================================================
  2. update console log
    Fatal error: run() received nonzero return code 1 while executing!

Requested: sudo sudo -u redash PYTHONPATH=. bin/run python migrations/0009_add_api_key_to_user.py
Executed: /bin/bash -l -c “cd /opt/redash/redash.0.11.0.b2016 >/dev/null && sudo sudo -u redash PYTHONPATH=. bin/run python migrations/0009_add_api_key_to_user.py”

[Used Command]
fab -H {host} -u ubuntu -f /tmp/fabfile.py deploy_latest_release

[opnion]
in redash 0.6.1b857’s migration folder there has no 0009_add_api_key_to_user.py file

[File list in migration folder in redash 0.6.1b857]
0001_allow_delete_query.py
0002_fix_timestamp_fields.py
0003_update_data_source_config.py
0004_allow_null_in_event_user.py
0005_add_updated_at.py
0006_queries_last_edit_by.py
0007_add_schedule_to_queries.py
0008_make_ds_name_unique.py
add_created_at_field.py
add_global_filters_to_dashboard.py
add_password_to_users.py
add_permissions_to_user.py
add_queue_name_to_data_source.py
add_text_to_widgets.py
add_view_query_permission.py
change_queries_description_to_nullable.py
change_query_id_on_widgets_to_null.py
create_activity_log.py
create_data_sources.py
create_events.py
create_users.py
create_visualizations.py
permissions_migration.py

plz check how to upgrade


#2

Version 0.6.1 is a very old release, and can’t be upgraded automatically to 0.11.1 without some modifications to the migrations.

You can try upgrading to 0.9.0 or 0.10 first, and then upgrading to 0.11. You will need to edit the fabfile.py script and instead of letting it fetch the version automatically by querying GitHub’s API, specify the version you want manually.