toncek87 commented on issue #3162: Redshift could not connect to the server URL: https://github.com/apache/incubator-superset/issues/3162#issuecomment-316685715 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: /usr/local/lib/python3.4/dist-packages/sqlalchemy/sql/compiler.py:624: SAWarning: Can't resolve label reference 'changed_on desc'; converting to text() (this warning may be suppressed after 10 occurrences) util.ellipses_string(element.element)) /usr/local/lib/python3.4/dist-packages/sqlalchemy/sql/compiler.py:624: SAWarning: Can't resolve label reference 'database_name asc'; converting to text() (this warning may be suppressed after 10 occurrences) util.ellipses_string(element.element)) 2017-07-20 14:15:42,256:INFO:root:Parsing with sqlparse statement SELECT count(uid) as pocet FROM events2 where event = 'pageview' and time like '%2017-06-30%' 2017-07-20 14:15:42,300:INFO:root:Triggering query_id: 43 /usr/local/lib/python3.4/dist-packages/sqlalchemy/sql/sqltypes.py:596: SAWarning: Dialect sqlite+pysqlite does *not* support Decimal objects natively, and SQLAlchemy must convert from floating point - rounding errors and other issues may occur. Please consider storing Decimal numbers as strings or integers on this platform for lossless storage. 'storage.' % (dialect.name, dialect.driver)) 2017-07-20 14:15:42,980:ERROR:root:[Errno 111] Connection refused Traceback (most recent call last): File "/usr/local/lib/python3.4/dist-packages/kombu/utils/functional.py", line 36, in __call__ return self.__value__ AttributeError: 'ChannelPromise' object has no attribute '__value__' During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/usr/local/lib/python3.4/dist-packages/kombu/connection.py", line 494, in _ensured return fun(*args, **kwargs) File "/usr/local/lib/python3.4/dist-packages/kombu/messaging.py", line 187, in _publish channel = self.channel File "/usr/local/lib/python3.4/dist-packages/kombu/messaging.py", line 209, in _get_channel channel = self._channel = channel() File "/usr/local/lib/python3.4/dist-packages/kombu/utils/functional.py", line 38, in __call__ value = self.__value__ = self.__contract__() File "/usr/local/lib/python3.4/dist-packages/kombu/messaging.py", line 224, in <lambda> channel = ChannelPromise(lambda: connection.default_channel) File "/usr/local/lib/python3.4/dist-packages/kombu/connection.py", line 819, in default_channel self.connection File "/usr/local/lib/python3.4/dist-packages/kombu/connection.py", line 802, in connection self._connection = self._establish_connection() File "/usr/local/lib/python3.4/dist-packages/kombu/connection.py", line 757, in _establish_connection conn = self.transport.establish_connection() File "/usr/local/lib/python3.4/dist-packages/kombu/transport/pyamqp.py", line 130, in establish_connection conn.connect() File "/usr/local/lib/python3.4/dist-packages/amqp/connection.py", line 296, in connect self.transport.connect() File "/usr/local/lib/python3.4/dist-packages/amqp/transport.py", line 123, in connect self._connect(self.host, self.port, self.connect_timeout) File "/usr/local/lib/python3.4/dist-packages/amqp/transport.py", line 164, in _connect self.sock.connect(sa) ConnectionRefusedError: [Errno 111] Connection refused During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/usr/local/lib/python3.4/dist-packages/kombu/connection.py", line 414, in _reraise_as_library_errors yield File "/usr/local/lib/python3.4/dist-packages/kombu/connection.py", line 515, in _ensured reraise_as_library_errors=False, File "/usr/local/lib/python3.4/dist-packages/kombu/connection.py", line 405, in ensure_connection callback) File "/usr/local/lib/python3.4/dist-packages/kombu/utils/functional.py", line 333, in retry_over_time return fun(*args, **kwargs) File "/usr/local/lib/python3.4/dist-packages/kombu/connection.py", line 261, in connect return self.connection File "/usr/local/lib/python3.4/dist-packages/kombu/connection.py", line 802, in connection self._connection = self._establish_connection() File "/usr/local/lib/python3.4/dist-packages/kombu/connection.py", line 757, in _establish_connection conn = self.transport.establish_connection() File "/usr/local/lib/python3.4/dist-packages/kombu/transport/pyamqp.py", line 130, in establish_connection conn.connect() File "/usr/local/lib/python3.4/dist-packages/amqp/connection.py", line 296, in connect self.transport.connect() File "/usr/local/lib/python3.4/dist-packages/amqp/transport.py", line 123, in connect self._connect(self.host, self.port, self.connect_timeout) File "/usr/local/lib/python3.4/dist-packages/amqp/transport.py", line 164, in _connect self.sock.connect(sa) ConnectionRefusedError: [Errno 111] Connection refused During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/usr/local/lib/python3.4/dist-packages/superset/views/core.py", line 2011, in sql_json store_results=not query.select_as_cta) File "/usr/local/lib/python3.4/dist-packages/celery/app/task.py", line 412, in delay return self.apply_async(args, kwargs) File "/usr/local/lib/python3.4/dist-packages/celery/app/task.py", line 535, in apply_async **options File "/usr/local/lib/python3.4/dist-packages/celery/app/base.py", line 737, in send_task amqp.send_task_message(P, name, message, **options) File "/usr/local/lib/python3.4/dist-packages/celery/app/amqp.py", line 558, in send_task_message **properties File "/usr/local/lib/python3.4/dist-packages/kombu/messaging.py", line 181, in publish exchange_name, declare, File "/usr/local/lib/python3.4/dist-packages/kombu/connection.py", line 527, in _ensured errback and errback(exc, 0) File "/usr/lib/python3.4/contextlib.py", line 77, in __exit__ self.gen.throw(type, value, traceback) File "/usr/local/lib/python3.4/dist-packages/kombu/connection.py", line 419, in _reraise_as_library_errors sys.exc_info()[2]) File "/usr/local/lib/python3.4/dist-packages/vine/five.py", line 178, in reraise raise value.with_traceback(tb) File "/usr/local/lib/python3.4/dist-packages/kombu/connection.py", line 414, in _reraise_as_library_errors yield File "/usr/local/lib/python3.4/dist-packages/kombu/connection.py", line 515, in _ensured reraise_as_library_errors=False, File "/usr/local/lib/python3.4/dist-packages/kombu/connection.py", line 405, in ensure_connection callback) File "/usr/local/lib/python3.4/dist-packages/kombu/utils/functional.py", line 333, in retry_over_time return fun(*args, **kwargs) File "/usr/local/lib/python3.4/dist-packages/kombu/connection.py", line 261, in connect return self.connection File "/usr/local/lib/python3.4/dist-packages/kombu/connection.py", line 802, in connection self._connection = self._establish_connection() File "/usr/local/lib/python3.4/dist-packages/kombu/connection.py", line 757, in _establish_connection conn = self.transport.establish_connection() File "/usr/local/lib/python3.4/dist-packages/kombu/transport/pyamqp.py", line 130, in establish_connection conn.connect() File "/usr/local/lib/python3.4/dist-packages/amqp/connection.py", line 296, in connect self.transport.connect() File "/usr/local/lib/python3.4/dist-packages/amqp/transport.py", line 123, in connect self._connect(self.host, self.port, self.connect_timeout) File "/usr/local/lib/python3.4/dist-packages/amqp/transport.py", line 164, in _connect self.sock.connect(sa) kombu.exceptions.OperationalError: [Errno 111] Connection refused [2017-07-20 14:15:51 +0200] [1746] [INFO] Handling signal: winch [2017-07-20 14:15:51 +0200] [1746] [INFO] Handling signal: winch ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected]
With regards, Apache Git Services
