I am attempting to setup redash so I can debug a new query_runner. Unfortunately, I need Celery to complicate the process. I can click on “execute” new query, I see the query be put on a queue, I see the query being processed by my new query_runner, and the query runner returns a pair indicating success.
The UI reports “Error running query: failed communicating with server. Please check your Internet connection and try again.” (the celery worker stacktrace is below). It would be nice if the errors revealed some particulars that would point to what went wrong, rather than the code that went wrong.
What “target machine actively refused” what request?
Thank you very much for this.
[2017-05-04 13:59:25,522: ERROR/MainProcess] Task redash.tasks.execute_query[478ee3c9-84eb-47ec-a2ff-e1955c8e4bb2] raised unexpected: error(error(10061, ‘No connection could be made because the target machine actively refused it’),)
Traceback (most recent call last):
File “C:\Users\kyle\code\redash\celery\app\trace.py”, line 240, in trace_task
R = retval = fun(*args, **kwargs)
File “C:\Users\kyle\code\redash\celery\app\trace.py”, line 438, in protected_call
return self.run(*args, **kwargs)
File “C:\Users\kyle\code\redash\redash\tasks\queries.py”, line 496, in execute_query
scheduled_query).run()
File “C:\Users\kyle\code\redash\redash\tasks\queries.py”, line 451, in run
check_alerts_for_query.delay(query_id)
File “C:\Users\kyle\code\redash\celery\app\task.py”, line 453, in delay
return self.apply_async(args, kwargs)
File “C:\Users\kyle\code\redash\celery\app\task.py”, line 565, in apply_async
**dict(self._get_exec_options(), **options)
File “C:\Users\kyle\code\redash\celery\app\base.py”, line 354, in send_task
reply_to=reply_to or self.oid, **options
File “C:\Users\kyle\code\redash\celery\app\amqp.py”, line 310, in publish_task
**kwargs
File “C:\Users\kyle\code\redash.env\lib\site-packages\kombu\messaging.py”, line 172, in publish
routing_key, mandatory, immediate, exchange, declare)
File “C:\Users\kyle\code\redash.env\lib\site-packages\kombu\connection.py”, line 470, in ensured
interval_max)
File “C:\Users\kyle\code\redash.env\lib\site-packages\kombu\connection.py”, line 382, in ensure_connection
interval_start, interval_step, interval_max, callback)
File "C:\Users\kyle\code\redash.env\lib\site-packages\kombu\utils_init.py", line 246, in retry_over_time
return fun(*args, **kwargs)
File “C:\Users\kyle\code\redash.env\lib\site-packages\kombu\connection.py”, line 250, in connect
return self.connection
File “C:\Users\kyle\code\redash.env\lib\site-packages\kombu\connection.py”, line 756, in connection
self._connection = self._establish_connection()
File “C:\Users\kyle\code\redash.env\lib\site-packages\kombu\connection.py”, line 711, in _establish_connection
conn = self.transport.establish_connection()
File “C:\Users\kyle\code\redash.env\lib\site-packages\kombu\transport\pyamqp.py”, line 116, in establish_connection
conn = self.Connection(**opts)
File “C:\Users\kyle\code\redash.env\lib\site-packages\amqp\connection.py”, line 165, in init
self.transport = self.Transport(host, connect_timeout, ssl)
File “C:\Users\kyle\code\redash.env\lib\site-packages\amqp\connection.py”, line 186, in Transport
return create_transport(host, connect_timeout, ssl)
File “C:\Users\kyle\code\redash.env\lib\site-packages\amqp\transport.py”, line 299, in create_transport
return TCPTransport(host, connect_timeout)
File “C:\Users\kyle\code\redash.env\lib\site-packages\amqp\transport.py”, line 95, in init
raise socket.error(last_err)
error: [Errno 10061] No connection could be made because the target machine actively refused it