These are chat archives for getredash/redash

29th
Jan 2016
fatayri
@fatayri
Jan 29 2016 16:41
hi Arik! Can I ask you to add me to Redash's Slack? samer@bookmate.com
Arik Fraimovich
@arikfr
Jan 29 2016 20:53
@fatayri join here: slack.redash.io
Aviv Laufer
@avivl
Jan 29 2016 20:57

`New migrations to run:
0014_add_alert_rearm_seconds.py, 0014_migrate_existing_es_to_kibana.py, 0015_add_schedule_query_permission.py, 0016_add_alert_subscriber.py, 0016_drop_tables_from_group.py, 0017_add_organization.py, 0018_add_groups_refs.py, 0019_add_super_admin_permission.py, 0020_change_ds_name_to_non_uniqe.py
Apply new migrations? (make sure you have backup) [Y/n] y
Applying 0014_add_alert_rearm_seconds.py...
[redash.rounds.com] run: sudo sudo -u redash PYTHONPATH=. bin/run python migrations/0014_add_alert_rearm_seconds.py
[redash.rounds.com] out: [2016-01-29 20:53:47,649][PID:17499][WARNING][redash.query_runner] MQL query runner enabled but not supported, not registering. Either disable or install missing dependencies.
[redash.rounds.com] out: [2016-01-29 20:53:47,691][PID:17499][WARNING][redash.query_runner] Oracle query runner enabled but not supported, not registering. Either disable or install missing dependencies.
[redash.rounds.com] out: [2016-01-29 20:53:47,720][PID:17499][ERROR][peewee] ALTER TABLE "alerts" ADD COLUMN "rearm" INTEGER []
[redash.rounds.com] out: Traceback (most recent call last):
[redash.rounds.com] out: File "/usr/local/lib/python2.7/dist-packages/playhouse/postgres_ext.py", line 360, in execute_sql
[redash.rounds.com] out: cursor.execute(sql, params or ())
[redash.rounds.com] out: ProgrammingError: column "rearm" of relation "alerts" already exists
[redash.rounds.com] out:
[redash.rounds.com] out: Traceback (most recent call last):
[redash.rounds.com] out: File "migrations/0014_add_alert_rearm_seconds.py", line 12, in <module>
[redash.rounds.com] out: migrator.add_column('alerts', 'rearm', models.Alert.rearm),
[redash.rounds.com] out: File "/usr/local/lib/python2.7/dist-packages/playhouse/migrate.py", line 575, in migrate
[redash.rounds.com] out: operation.run()
[redash.rounds.com] out: File "/usr/local/lib/python2.7/dist-packages/playhouse/migrate.py", line 144, in run
[redash.rounds.com] out: getattr(self.migrator, self.method)(self.args, **kwargs))
[redash.rounds.com] out: File "/usr/local/lib/python2.7/dist-packages/playhouse/migrate.py", line 138, in _handle_result
[redash.rounds.com] out: self._handle_result(item)
[redash.rounds.com] out: File "/usr/local/lib/python2.7/dist-packages/playhouse/migrate.py", line 135, in _handle_result
[redash.rounds.com] out: result.run()
[redash.rounds.com] out: File "/usr/local/lib/python2.7/dist-packages/playhouse/migrate.py", line 144, in run
[redash.rounds.com] out: getattr(self.migrator, self.method)(
self.args, kwargs))
[redash.rounds.com] out: File "/usr/local/lib/python2.7/dist-packages/playhouse/migrate.py", line 133, in _handle_result
[redash.rounds.com] out: self.execute(result)
[redash.rounds.com] out: File "/usr/local/lib/python2.7/dist-packages/playhouse/migrate.py", line 129, in execute
[redash.rounds.com] out: self.migrator.database.execute_sql(sql, params)
[redash.rounds.com] out: File "/opt/redash/redash.0.9.1.b1377/redash/metrics/database.py", line 22, in execute_sql
[redash.rounds.com] out: result = super(MeteredPostgresqlExtDatabase, self).execute_sql(*args,
kwargs)
[redash.rounds.com] out: File "/usr/local/lib/python2.7/dist-packages/playhouse/postgres_ext.py", line 369, in execute_sql
[redash.rounds.com] out: self.commit()
[redash.rounds.com] out: File "/usr/local/lib/python2.7/dist-packages/peewee.py", line 2922, in exit
[redash.rounds.com] out: reraise(new_type, new_type(*exc_value.args), traceback)
[redash.rounds.com] out: File "/usr/local/lib/python2.7/dist-packages/playhouse/postgres_ext.py", line 360, in execute_sql
[redash.rounds.com] out: cursor.execute(sql, params or ())
[redash.rounds.com] out: peewee.ProgrammingError: column "rearm" of relation "alerts" already exists
[redash.rounds.com] out:
[redash.rounds.com] out:

Fatal error: run() received nonzero return code 1 while executing!

Requested: sudo sudo -u redash PYTHONPATH=. bin/run python migrations/0014_add_alert_rearm_seconds.py
Executed: /bin/bash -l -c "cd /opt/redash/r

Arik Fraimovich
@arikfr
Jan 29 2016 20:59
@avivl did you run migrations twice?
Aviv Laufer
@avivl
Jan 29 2016 20:59
it failed on the first & second tries
Arik Fraimovich
@arikfr
Jan 29 2016 21:05
what was the failure on the first run?
Aviv Laufer
@avivl
Jan 29 2016 21:14
same

`
Applying 0014_migrate_existing_es_to_kibana.py...
[redash.rounds.com] run: sudo sudo -u redash PYTHONPATH=. bin/run python migrations/0014_migrate_existing_es_to_kibana.py
[redash.rounds.com] out: [2016-01-29 20:49:21,223][PID:16975][WARNING][redash.query_runner] MQL query runner enabled but not supported, not registering. Either disable or install missing dependencies.
[redash.rounds.com] out: [2016-01-29 20:49:21,276][PID:16975][WARNING][redash.query_runner] Oracle query runner enabled but not supported, not registering. Either disable or install missing dependencies.
[redash.rounds.com] out: [2016-01-29 20:49:21,324][PID:16975][ERROR][peewee] SELECT "t1"."id", "t1"."org_id", "t1"."name", "t1"."type", "t1"."options", "t1"."queue_name", "t1"."scheduled_queue_name", "t1"."created_at" FROM "data_sources"
AS t1 []
[redash.rounds.com] out: Traceback (most recent call last):
[redash.rounds.com] out: File "/usr/local/lib/python2.7/dist-packages/playhouse/postgres_ext.py", line 360, in execute_sql
[redash.rounds.com] out: cursor.execute(sql, params or ())
[redash.rounds.com] out: ProgrammingError: column t1.org_id does not exist
[redash.rounds.com] out: LINE 1: SELECT "t1"."id", "t1"."org_id", "t1"."name", "t1"."type", "...
[redash.rounds.com] out: ^
[redash.rounds.com] out:
[redash.rounds.com] out: Traceback (most recent call last):
[redash.rounds.com] out: File "migrations/0014_migrate_existing_es_to_kibana.py", line 7, in <module>
[redash.rounds.com] out: for ds in DataSource.select():
[redash.rounds.com] out: File "/usr/local/lib/python2.7/dist-packages/peewee.py", line 2689, in iter
[redash.rounds.com] out: return iter(self.execute())
[redash.rounds.com] out: File "/usr/local/lib/python2.7/dist-packages/peewee.py", line 2682, in execute
[redash.rounds.com] out: self._qr = ResultWrapper(model_class, self._execute(), query_meta)
[redash.rounds.com] out: File "/opt/redash/redash.0.9.1.b1377/redash/metrics/database.py", line 50, in metered_execute
[redash.rounds.com] out: result = real_execute(self, args, **kwargs)
[redash.rounds.com] out: File "/usr/local/lib/python2.7/dist-packages/peewee.py", line 2371, in _execute
[redash.rounds.com] out: return self.database.execute_sql(sql, params, self.require_commit)
[redash.rounds.com] out: File "/opt/redash/redash.0.9.1.b1377/redash/metrics/database.py", line 22, in execute_sql
[redash.rounds.com] out: result = super(MeteredPostgresqlExtDatabase, self).execute_sql(
args, *kwargs)
[redash.rounds.com] out: File "/usr/local/lib/python2.7/dist-packages/playhouse/postgres_ext.py", line 369, in execute_sql
[redash.rounds.com] out: self.commit()
[redash.rounds.com] out: File "/usr/local/lib/python2.7/dist-packages/peewee.py", line 2922, in exit
[redash.rounds.com] out: reraise(new_type, new_type(
exc_value.args), traceback)
[redash.rounds.com] out: File "/usr/local/lib/python2.7/dist-packages/playhouse/postgres_ext.py", line 360, in execute_sql
[redash.rounds.com] out: cursor.execute(sql, params or ())
[redash.rounds.com] out: peewee.ProgrammingError: column t1.org_id does not exist
[redash.rounds.com] out: LINE 1: SELECT "t1"."id", "t1"."org_id", "t1"."name", "t1"."type", "...
[redash.rounds.com] out: ^
[redash.rounds.com] out:
[redash.rounds.com] out:

Fatal error: run() received nonzero return code 1 while executing!

Requested: sudo sudo -u redash PYTHONPATH=. bin/run python migrations/0014_migrate_existing_es_to_kibana.py
Executed: /bin/bash -l -c "cd /opt/redash/redash.0.9.1.b1377 >/dev/null && sudo sudo -u redash PYTHONPATH=. bin/run python migrations/0014_migrate_existing_es_to_kibana.py" `

Arik Fraimovich
@arikfr
Jan 29 2016 21:17
this one I fixed . just tell it to install unstable version (deploy_latest_release:stable=false).
that's what you get for not upgrading regularly :)
Aviv Laufer
@avivl
Jan 29 2016 21:18
trying :stable=false
works! thanks
but something is wrong with the charts. All legend moved to the right and not the bottom, and when trying to edit a chart columns mapping nothing is selected
Arik Fraimovich
@arikfr
Jan 29 2016 21:22
legend moved -> we switched to plot.ly.
issue w/ columns mapping -> shouldn't happen. can you add a screenshot?
Aviv Laufer
@avivl
Jan 29 2016 21:23
blob
blob
blob
Arik Fraimovich
@arikfr
Jan 29 2016 21:25
it shows you old UI :O
so weird - it shows you plot.ly (new) with old chart editor
try clearing cache
Aviv Laufer
@avivl
Jan 29 2016 21:26
blob
Arik Fraimovich
@arikfr
Jan 29 2016 21:28
blob
this is how it looks like now
clear browser cache or something
Aviv Laufer
@avivl
Jan 29 2016 21:29
clearing the cache helpd
Arik Fraimovich
@arikfr
Jan 29 2016 21:29
iirc, in this version, I updated the headers so it won't cache these stuff
Aviv Laufer
@avivl
Jan 29 2016 21:32
I feels faster :)
thanks for the help, good night
Arik Fraimovich
@arikfr
Jan 29 2016 21:33
sure thing. good night :)