These are chat archives for getredash/redash

18th
Jul 2016
sivasankarmanuh
@sivasankarmanuh
Jul 18 2016 09:43

Hi Arik,
Getting following error when I tried to run redash in centos.

ImportError: No module named flask_sslify
[2016-07-18 15:09:59 +0000] [21180] [INFO] Worker exiting (pid: 21180)
Traceback (most recent call last):
File "/usr/bin/gunicorn", line 11, in <module>
sys.exit(run())
File "/usr/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py", line 74, in run
WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run()
File "/usr/lib/python2.7/site-packages/gunicorn/app/base.py", line 189, in run
super(Application, self).run()
File "/usr/lib/python2.7/site-packages/gunicorn/app/base.py", line 72, in run
Arbiter(self).run()
File "/usr/lib/python2.7/site-packages/gunicorn/arbiter.py", line 174, in run
self.manage_workers()
File "/usr/lib/python2.7/site-packages/gunicorn/arbiter.py", line 477, in manage_workers
self.spawn_workers()
File "/usr/lib/python2.7/site-packages/gunicorn/arbiter.py", line 541, in spawn_workers
time.sleep(0.1 * random.random())
File "/usr/lib/python2.7/site-packages/gunicorn/arbiter.py", line 214, in handle_chld
self.reap_workers()
File "/usr/lib/python2.7/site-packages/gunicorn/arbiter.py", line 459, in reap_workers
raise HaltServer(reason, self.WORKER_BOOT_ERROR)
gunicorn.errors.HaltServer: <HaltServer 'Worker failed to boot.' 3>

yonger1516
@yonger1516
Jul 18 2016 12:42
Hi, does redash support to influxdb?
yonger1516
@yonger1516
Jul 18 2016 12:48
if yes, how to config the url?
is it look like "http://host:8086/database_name"
Arik Fraimovich
@arikfr
Jul 18 2016 12:50
@yonger1516 it takes a DSN, so should be something like this: "influxdb://username:password@localhost:8086/databasename"
@sivasankarmanuh you have missing python dependencies. install the packages in requirements.txt.
@ttheune looks like recent changes to the models made the older migrations not work :( I think it will work if you upgrade to 0.10 first and then to 0.11. or you can run the migrations manually, applying needed fixes
yonger1516
@yonger1516
Jul 18 2016 12:53
so how about if i not setup any user&password in influxdb?
Arik Fraimovich
@arikfr
Jul 18 2016 12:56
then just "influxdb://localhost:8086/databasename"
yonger1516
@yonger1516
Jul 18 2016 12:56
OK. thank u @arikfr
yonger1516
@yonger1516
Jul 18 2016 13:04
@arikfr this error message popup when execute query:
7/19/2016 5:03:09 AM File "/usr/local/lib/python2.7/dist-packages/playhouse/postgres_ext.py", line 360, in execute_sql
7/19/2016 5:03:09 AM cursor.execute(sql, params or ())
7/19/2016 5:03:09 AMInternalError: MultiXactId 2 has not been created yet -- apparent wraparound
7/19/2016 5:03:09 AMCONTEXT: SQL statement "SELECT 1 FROM ONLY "public"."organizations" x WHERE "id" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x"
is there something i missing ?
Arik Fraimovich
@arikfr
Jul 18 2016 13:05
Looks like a query error.
yonger1516
@yonger1516
Jul 18 2016 13:09
I notice the same error message in log file when requesting to redash ifself
for example, i enter the datasource details page, it will have this error in log file
Arik Fraimovich
@arikfr
Jul 18 2016 13:11
how did you setup redash?
yonger1516
@yonger1516
Jul 18 2016 13:12
the way of docker compose
i follow that guide, all goes well except the last line in create_database.sh
i add "-n" prefix to "re:dash metadata"
and the issue seems fixed
Arik Fraimovich
@arikfr
Jul 18 2016 13:15
cool
yonger1516
@yonger1516
Jul 18 2016 13:24
any misunderstand for you?
@arikfr i said the issue have been fixed means an issue found in my setup, not the issue i request to you.
Arik Fraimovich
@arikfr
Jul 18 2016 13:54
not sure I understand then
yonger1516
@yonger1516
Jul 18 2016 13:59
I just have fixed an issue which in setup stage, but the issue that i send you was happened in the after
yonger1516
@yonger1516
Jul 18 2016 14:05
i paste the entire log print when i req to details of an datasource:
7/19/2016 6:05:01 AM[2016-07-18 22:05:01,949][PID:24][INFO][metrics] method=GET path=/api/data_sources/2 endpoint=data_source status=200 content_type=application/json content_length=228 duration=8025.47 query_count=6 query_duration=9.93
7/19/2016 6:05:01 AM[2016-07-18 22:05:01,951][PID:24][INFO][metrics] method=GET path=/api/data_sources/2 endpoint=data_source status=500 content_type=? content_length=-1 duration=8027.35 query_count=6 query_duration=9.93
7/19/2016 6:05:01 AM[2016-07-18 22:05:01,963][PID:30][INFO][metrics] method=GET path=/api/data_sources/types endpoint=data_source_types status=200 content_type=application/json content_length=6355 duration=8017.95 query_count=3 query_duration=6.24
7/19/2016 6:05:01 AM[2016-07-18 22:05:01,965][PID:30][INFO][metrics] method=GET path=/api/data_sources/types endpoint=data_source_types status=500 content_type=? content_length=-1 duration=8020.16 query_count=3 query_duration=6.24
7/19/2016 6:05:02 AM[2016-07-18 22:05:02,938][PID:33][INFO][metrics] method=POST path=/api/events endpoint=events status=200 content_type=application/json content_length=4 duration=8020.30 query_count=3 query_duration=5.74
7/19/2016 6:05:02 AM[2016-07-18 22:05:02,940][PID:33][INFO][metrics] method=POST path=/api/events endpoint=events status=500 content_type=? content_length=-1 duration=8021.84 query_count=3 query_duration=5.74
7/19/2016 6:05:10 AM[2016-07-18 22:05:10,952: ERROR/Worker-46] INSERT INTO "events" ("org_id", "user_id", "action", "object_type", "object_id", "additional_properties", "created_at") VALUES (%s, %s, %s, %s, %s, %s, %s) RETURNING "id" [1, 1, u'view', u'page', u'admin/data_source', u'{"ip": "10.239.4.80", "user_agent": "Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/51.0.2704.103 Safari/537.36"}', datetime.datetime(2016, 7, 18, 14, 3, 37, 93000)]
7/19/2016 6:05:10 AMTraceback (most recent call last):
7/19/2016 6:05:10 AM File "/usr/local/lib/python2.7/dist-packages/playhouse/postgres_ext.py", line 360, in execute_sql
7/19/2016 6:05:10 AM cursor.execute(sql, params or ())
7/19/2016 6:05:10 AMInternalError: MultiXactId 2 has not been created yet -- apparent wraparound
7/19/2016 6:05:10 AMCONTEXT: SQL statement "SELECT 1 FROM ONLY "public"."organizations" x WHERE "id" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x"
7/19/2016 6:05:10 AM
7/19/2016 6:05:10 AM[2016-07-18 22:05:10,957: ERROR/MainProcess] Task redash.tasks.record_event[60891811-01b7-48cc-a140-a05bffc9dcbd] raised unexpected: InternalError('MultiXactId 2 has not been created yet -- apparent wraparound\nCONTEXT: SQL statement "SELECT 1 FROM ONLY "public"."organizations" x WHERE "id" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x"\n',)
7/19/2016 6:05:10 AMTraceback (most recent call last):
7/19/2016 6:05:10 AM File "/usr/local/lib/python2.7/dist-packages/celery/app/trace.py", line 240, in trace_task
7/19/2016 6:05:10 AM R = retval = fun(args, **kwargs)
7/19/2016 6:05:10 AM File "/opt/redash/current/redash/tasks/base.py", line 13, in call
7/19/2016 6:05:10 AM return super(BaseTask, self).call(
args, kwargs)
7/19/2016 6:05:10 AM File "/usr/local/lib/python2.7/dist-packages/celery/app/trace.py", line 437, in protected_call
7/19/2016 6:05:10 AM return self.run(*args,
kwargs)
7/19/2016 6:05:10 AM File "/opt/redash/current/redash/tasks/general.py", line 13, in record_event
7/19/2016 6:05:10 AM models.Event.record(event)
7/19/2016 6:05:10 AM File "/opt/redash/current/redash/models.py", line 1056, in record
7/19/2016 6:05:10 AM additional_properties=additional_properties, created_at=created_at)
7/19/2016 6:05:10 AM File "/usr/local/lib/python2.7/dist-packages/peewee.py", line 4001, in create
7/19/2016 6:05:10 AM inst.save(force_insert=True)
7/19/2016 6:05:10 AM File "/opt/redash/current/redash/models.py", line 96, in save
7/19/2016 6:05:10 AM super(BaseModel, self).save(args, *kwargs)
7/19/2016 6:05:10 AM File "/usr/local/lib/python2.7/dist-packages/peewee.py", line 4148, in save
7/19/2016 6:05:10 AM pk_from_cursor =
Travis Theune
@ttheune
Jul 18 2016 14:33
This message was deleted
@arikfr if I wanted to upgrade to .10 first where would I get that from?
Travis Theune
@ttheune
Jul 18 2016 14:39
@arikfr n/m I got it :) thanks so much! fully upgraded
leoliu1994
@leoliu1994
Jul 18 2016 16:48
@arikfr The gunicorn processes always restart by itself. Is there a way to prevent it from restarting?
This message was deleted
martin sarsale
@runa
Jul 18 2016 16:57
@arikfr hey :) Do you like like sparklines? Do you think it makes sense to create a new visualization which is similar to the results table + a new column with a sparkline with values from another column, separated by ',' or something
leoliu1994
@leoliu1994
Jul 18 2016 17:07
@arikfr fixed. Thanks!
But is there a way to prevent this problem happen again?