These are chat archives for getredash/redash

19th
Jul 2016
yonger1516
@yonger1516
Jul 19 2016 01:44
@arikfr I redeploy the stack and the issue has gone.
But it seems there is no difference with other tool, such as grafana
I am seeking to a tool that works like version before 0.9 of influxdb
what we query is what we can see
no need to build the chart, and generate a set of charts within one sql
anybody can give me a recommendation?
Arik Fraimovich
@arikfr
Jul 19 2016 07:11
@yonger1516 you might have better answers in an influx chat room...
@runa I'm planning to add the ability to customize the table. It will make more sense to add it then, as another option.
sivasankarmanuh
@sivasankarmanuh
Jul 19 2016 12:16
Hi Arik,
Installed redash in centos, started redash server. But ports (9001, 5000) are not showing when I did netstat (netstat -aNp). Checked logs, didn't find any errors. What can I check to resolve the issue?
sivasankarmanuh
@sivasankarmanuh
Jul 19 2016 12:54

Hi Arik,
Made few changes and started the nginx, getting the following error

[root@master ~]# service nginx restart
nginx: [emerg] a duplicate default server for 0.0.0.0:80 in /etc/nginx/sites-enabled/redash:9
nginx: configuration file /etc/nginx/nginx.conf test failed

sivasankarmanuh
@sivasankarmanuh
Jul 19 2016 13:26

Arik, solved duplicate dafault server issue, but getting following error when I call the redash ui

OperationalError: FATAL: role "root" does not exist

[2016-07-19 18:55:29,115][PID:29127][ERROR][redash] Exception on / [GET]
Traceback (most recent call last):
File "/usr/lib/python2.7/site-packages/flask/app.py", line 1817, in wsgi_app
response = self.full_dispatch_request()
File "/usr/lib/python2.7/site-packages/flask/app.py", line 1477, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/lib/python2.7/site-packages/flaskrestful/_init.py", line 271, in error_router
return original_handler(e)
File "/usr/lib/python2.7/site-packages/flask/app.py", line 1381, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/usr/lib/python2.7/site-packages/flask/app.py", line 1473, in full_dispatch_request
rv = self.preprocess_request()
File "/usr/lib/python2.7/site-packages/flask/app.py", line 1666, in preprocess_request
rv = func()
File "/opt/redash/redash.0.10.1.b1834/redash/models.py", line 41, in connect_db
self.database.connect()
File "/usr/lib/python2.7/site-packages/peewee.py", line 3404, in connect
self.initialize_connection(self.local.conn)
File "/usr/lib/python2.7/site-packages/peewee.py", line 3316, in
exit
reraise(new_type, new_type(exc_args), traceback)
File "/usr/lib/python2.7/site-packages/peewee.py", line 3402, in connect
self.connect_kwargs)
File "/usr/lib/python2.7/site-packages/playhouse/postgres_ext.py", line 384, in _connect
conn = super(PostgresqlExtDatabase, self)._connect(database,
kwargs)
File "/usr/lib/python2.7/site-packages/peewee.py", line 3779, in _connect
conn = psycopg2.connect(database=database, *
kwargs)
File "/usr/lib64/python2.7/site-packages/psycopg2/
init.py", line 164, in connect
conn = _connect(dsn, connection_factory=connection_factory, async=async)
OperationalError: FATAL: role "root" does not exist

[2016-07-19 18:55:29,116][PID:29127][INFO][metrics] method=GET path=/ endpoint=redash.index status=500 content_type=? content_length=-1 duration=3.93 query_count=0 query_duration=0.00

sivasankarmanuh
@sivasankarmanuh
Jul 19 2016 14:21
Solved the issue, created role for root.
leoliu1994
@leoliu1994
Jul 19 2016 16:16
@arikfr Hi! Is there a way to prevent the same problem happen again?
sivasankarmanuh
@sivasankarmanuh
Jul 19 2016 16:31

Arik, getting following error when I am trying open redash UI

[2016-07-19 21:53:59,049][PID:2043][INFO][metrics] method=GET path=/api/queries/recent endpoint=recent_queries status=500 content_type=application/json content_length=36 duration=11.14 query_count=4 query_duration=4.35
[2016-07-19 21:53:59,050][PID:2043][INFO][metrics] method=GET path=/api/queries/recent endpoint=recent_queries status=500 content_type=? content_length=-1 duration=12.05 query_count=4 query_duration=4.35
[2016-07-19 21:53:59,061][PID:2037][ERROR][peewee] SELECT "t1"."id", "t1"."updated_at", "t1"."created_at", "t1"."org_id", "t1"."slug", "t1"."name", "t1"."user_email", "t1"."user_id", "t1"."layout", "t1"."dashboard_filters_enabled", "t1"."is_archived" FROM "dashboards" AS t1 LEFT OUTER JOIN "events" AS t2 ON ("t1"."id" = ("t2"."object_id" :: integer)) LEFT OUTER JOIN "widgets" AS t3 ON ("t1"."id" = "t3"."dashboard_id") LEFT OUTER JOIN "visualizations" AS t4 ON ("t3"."visualization_id" = "t4"."id") LEFT OUTER JOIN "queries" AS t5 ON ("t4"."query_id" = "t5"."id") LEFT OUTER JOIN "data_source_groups" AS t6 ON ("t5"."data_source_id" = "t6"."data_source_id") WHERE ((((((("t2"."created_at" > current_date - 7) AND ("t2"."action" IN (%s, %s))) AND NOT ("t2"."object_id" IS %s)) AND ("t2"."object_type" = %s)) AND ("t1"."is_archived" = %s)) AND ((("t6"."group_id" IN (%s, %s)) OR ("t1"."user_id" = %s)) OR (NOT ("t3"."dashboard_id" IS %s) AND ("t3"."visualization_id" IS %s)))) AND ("t2"."user_id" = %s)) GROUP BY "t2"."object_id", "t1"."id" ORDER BY count(0) desc LIMIT 20 [u'edit', u'view', None, u'dashboard', False, 2, 1, 1, None, None, 1]
Traceback (most recent call last):
File "/usr/lib/python2.7/site-packages/playhouse/postgres_ext.py", line 360, in execute_sql
cursor.execute(sql, params or ())
ProgrammingError: column "t1.updated_at" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: SELECT "t1"."id", "t1"."updated_at", "t1"."created_at", "t1"...
^

[2016-07-19 21:53:59,061][PID:2037][ERROR][redash] Exception on /api/dashboards/recent [GET]
Traceback (most recent call last):
File "/usr/lib/python2.7/site-packages/flask/app.py", line 1475, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/lib/python2.7/site-packages/flask/app.py", line 1461, in dispatch_request
return self.view_functionsrule.endpoint
File "/usr/lib/python2.7/site-packages/flaskrestful/_init.py", line 477, in wrapper
resp = resource(args, **kwargs)
File "/usr/lib/python2.7/site-packages/flask_login.py", line 792, in decorated_view
return func(
args, kwargs)
File "/usr/lib/python2.7/site-packages/flask/views.py", line 84, in view
return self.dispatch_request(*args,
kwargs)
File "/opt/redash/redash.0.10.1.b1834/redash/handlers/base.py", line 25, in dispatch_request
return super(BaseResource, self).dispatch_request(args, **kwargs)
File "/usr/lib/python2.7/site-packages/flaskrestful/_init.py", line 587, in dispatch_request
resp = meth(
args, kwargs)
File "/opt/redash/redash.0.10.1.b1834/redash/permissions.py", line 40, in decorated
return fn(*args,
kwargs)
File "/opt/redash/redash.0.10.1.b1834/redash/handlers/dashboards.py", line 14, in get
recent = [d.to_dict() for d in models.Dashboard.recent(self.current_user.groups, self.current_user.id, for_user=True)]
File "/usr/lib/python2.7/site-packages/peewee.py", line 2689, in iter
return iter(self.execute())
File "/usr/lib/python2.7/site-packages/peewee.py", line 2682, in execute
self._qr = ResultWrapper(model_class, self._execute(), query_meta)
File "/opt/redash/redash.0.10.1.b1834/redash/metrics/database.py", line 50, in metered_execute
result = real_execute(self, args, *kwargs)
File "/usr/lib/python2.7/site-packages/peewee.py", line 2371, in _execute
return self.database.execute_sql(sql, params, self.require_commit)
File "/opt/redash/redash.0.10.1.b1834/redash/metrics/database.py", line 22, in execute_sql
result = super(MeteredPostgresqlExtDatab

leoliu1994
@leoliu1994
Jul 19 2016 16:40
What is best practice for setting the max number of workers of redash_celery and redash_celery_scheduled?
Nick Grygiel
@ngrygs
Jul 19 2016 17:49

Hey Everybody - I'm having 2 problems regarding scheduled queries.

The first problem is that I'm having some scheduled queries repeatedly try to run despite failing. For example, I came in this morning and found a single scheduled query that had been executed (and failed in 0s) at least the 50 times shown on the Running Queries page.

My second problem is that I'm having queries run under the 'Scheduled' username at times when they aren't scheduled to execute; I'm noticing it today for the first time, and it seems to happen within half an hour of me editing the query (but without me ever hitting the execute button). These queries also tend to fail a few times and then retry, though these ones have been able to finish eventually.

Any ideas on either of my problems? They're turning out to be rather major, as they can tax my database at random times of the day, locking up the software that the company uses. Any help is appreciated.

Ramya Kalyanaraman
@ramyakalyan_twitter
Jul 19 2016 20:42
Hi Arik, I am in the process of setting up dev environment using Vagrant. Installed vagrant and cloned redash git, now when I run the app using ./bin/vagrant_ctl.sh start I get a message saying "missing job name" Usage: start[OPTION]..JOB [KEY=VALUE]... Please let me know if I am missing something when executing the above command. Thanks!