Redshift could not connect to the server

[toncek87]

I tried connect to my Redshift database. There are millions of rows. When query time is longer than
one minute, Superset response is "could not connect to the server". I checked Allow Run Async, but there is another message "Failed to start remote query on worker. Tell your administrator to verify the availability of the message queue." Could you help me with this issue?

[xrmx]

You can start by reading the documentation https://superset.incubator.apache.org/installation.html#sql-lab

[toncek87]

thanks, i missed it

[toncek87]

i've installed Redis, run superset worker and run superset server..
SQLlab gives me "Failed to start remote query on worker. Tell your administrator to verify the availability of the message queue."

and console where worker run:

[2017-07-20 14:19:45,658: WARNING/MainProcess] consumer: Connection to broker lost. Trying to re-establish the connection...
Traceback (most recent call last):
File "/home/rko/venv/lib/python3.4/site-packages/redis/connection.py", line 129, in _read_from_socket
raise socket.error(SERVER_CLOSED_CONNECTION_ERROR)
OSError: Connection closed by server.

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/home/rko/venv/lib/python3.4/site-packages/celery/worker/consumer/consumer.py", line 318, in start
blueprint.start(self)
File "/home/rko/venv/lib/python3.4/site-packages/celery/bootsteps.py", line 119, in start
step.start(parent)
File "/home/rko/venv/lib/python3.4/site-packages/celery/worker/consumer/consumer.py", line 594, in start
c.loop(*c.loop_args())
File "/home/rko/venv/lib/python3.4/site-packages/celery/worker/loops.py", line 88, in asynloop
next(loop)
File "/home/rko/venv/lib/python3.4/site-packages/kombu/async/hub.py", line 345, in create_loop
cb(*cbargs)
File "/home/rko/venv/lib/python3.4/site-packages/kombu/transport/redis.py", line 1039, in on_readable
self.cycle.on_readable(fileno)
File "/home/rko/venv/lib/python3.4/site-packages/kombu/transport/redis.py", line 337, in on_readable
chan.handlerstype
File "/home/rko/venv/lib/python3.4/site-packages/kombu/transport/redis.py", line 714, in _brpop_read
**options)
File "/home/rko/venv/lib/python3.4/site-packages/redis/client.py", line 585, in parse_response
response = connection.read_response()
File "/home/rko/venv/lib/python3.4/site-packages/redis/connection.py", line 577, in read_response
response = self._parser.read_response()
File "/home/rko/venv/lib/python3.4/site-packages/redis/connection.py", line 238, in read_response
response = self._buffer.readline()
File "/home/rko/venv/lib/python3.4/site-packages/redis/connection.py", line 168, in readline
self._read_from_socket()
File "/home/rko/venv/lib/python3.4/site-packages/redis/connection.py", line 143, in _read_from_socket
(e.args,))
redis.exceptions.ConnectionError: Error while reading from socket: ('Connection closed by server.',)

Where can be a problem? Thank you

[xrmx]

You have misconfigured celery, it's looking for an amqp broker while you said you want to use redis.

[xrmx]

You have to add to add proper quoting to your code excerpts otherwise it's impossible to help you.