jessicachen888 commented on issue #3694: Foreign table cannot be loaded in SQL lab Tab URL: https://github.com/apache/incubator-superset/issues/3694#issuecomment-337852058 I copy the SQL query from the Slice Tab and paste it into the SQL lab to get the following server log: ![image](https://user-images.githubusercontent.com/16902443/31764052-aedf314a-b485-11e7-899d-ffd5ae653342.png) `2017-10-19 17:19:54,321:INFO:root:Database.get_sqla_engine(). Masked URL: postgresql://Jessica:XXXXXXXXXX@localhost/Jessica 2017-10-19 17:19:54,341:INFO:root:Database.get_sqla_engine(). Masked URL: postgresql://Jessica:XXXXXXXXXX@localhost/Jessica 2017-10-19 17:19:54,480:INFO:werkzeug:127.0.0.1 - - [19/Oct/2017 17:19:54] "GET /databaseasync/api/read?_flt_0_expose_in_sqllab=1&_oc_DatabaseAsync=database_name&_od_DatabaseAsync=asc HTTP/1.1" 200 - 2017-10-19 17:19:54,591:INFO:werkzeug:127.0.0.1 - - [19/Oct/2017 17:19:54] "GET /superset/schemas/2/ HTTP/1.1" 200 - 2017-10-19 17:19:54,595:INFO:root:Database.get_sqla_engine(). Masked URL: postgresql://Jessica:XXXXXXXXXX@localhost/Jessica 2017-10-19 17:19:54,677:INFO:werkzeug:127.0.0.1 - - [19/Oct/2017 17:19:54] "GET /superset/tables/2/public/undefined/ HTTP/1.1" 200 - 2017-10-19 17:19:54,708:INFO:root:[stats_logger] (incr) sql_json 2017-10-19 17:19:54,712:INFO:root:Parsing with sqlparse statement SELECT "Station" AS "Station", COUNT(*) AS count FROM public.event_warnings WHERE "Start_Time" >= '2016-01-01 00:00:00' AND "Start_Time" <= '2017-10-19 15:02:07' GROUP BY "Station" ORDER BY count DESC LIMIT 50000 2017-10-19 17:19:54,782:INFO:werkzeug:127.0.0.1 - - [19/Oct/2017 17:19:54] "GET /static/appbuilder/fonts/fontawesome-webfont.woff?v=4.7.0 HTTP/1.1" 304 - 2017-10-19 17:19:54,870:INFO:root:Triggering query_id: 32 2017-10-19 17:19:54,870:INFO:root:Running query on a Celery worker 2017-10-19 17:19:55,565:ERROR:root:[Errno 61] Connection refused Traceback (most recent call last): File "/Users/Jessica/anaconda/lib/python3.4/site-packages/kombu/utils/__init__.py", line 423, 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 "/Users/Jessica/anaconda/lib/python3.4/site-packages/kombu/connection.py", line 449, in _ensured return fun(*args, **kwargs) File "/Users/Jessica/anaconda/lib/python3.4/site-packages/kombu/messaging.py", line 177, in _publish channel = self.channel File "/Users/Jessica/anaconda/lib/python3.4/site-packages/kombu/messaging.py", line 194, in _get_channel channel = self._channel = channel() File "/Users/Jessica/anaconda/lib/python3.4/site-packages/kombu/utils/__init__.py", line 425, in __call__ value = self.__value__ = self.__contract__() File "/Users/Jessica/anaconda/lib/python3.4/site-packages/kombu/messaging.py", line 209, in <lambda> channel = ChannelPromise(lambda: connection.default_channel) File "/Users/Jessica/anaconda/lib/python3.4/site-packages/kombu/connection.py", line 771, in default_channel self.connection File "/Users/Jessica/anaconda/lib/python3.4/site-packages/kombu/connection.py", line 756, in connection self._connection = self._establish_connection() File "/Users/Jessica/anaconda/lib/python3.4/site-packages/kombu/connection.py", line 711, in _establish_connection conn = self.transport.establish_connection() File "/Users/Jessica/anaconda/lib/python3.4/site-packages/kombu/transport/pyamqp.py", line 116, in establish_connection conn = self.Connection(**opts) File "/Users/Jessica/anaconda/lib/python3.4/site-packages/amqp/connection.py", line 165, in __init__ self.transport = self.Transport(host, connect_timeout, ssl) File "/Users/Jessica/anaconda/lib/python3.4/site-packages/amqp/connection.py", line 186, in Transport return create_transport(host, connect_timeout, ssl) File "/Users/Jessica/anaconda/lib/python3.4/site-packages/amqp/transport.py", line 299, in create_transport return TCPTransport(host, connect_timeout) File "/Users/Jessica/anaconda/lib/python3.4/site-packages/amqp/transport.py", line 95, in __init__ raise socket.error(last_err) OSError: [Errno 61] Connection refused During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/Users/Jessica/Desktop/work/incubator-superset-master/superset/views/core.py", line 2106, in sql_json store_results=not query.select_as_cta, user_name=g.user.username) File "/Users/Jessica/anaconda/lib/python3.4/site-packages/celery/app/task.py", line 461, in delay return self.apply_async(args, kwargs) File "/Users/Jessica/anaconda/lib/python3.4/site-packages/celery/app/task.py", line 573, in apply_async **dict(self._get_exec_options(), **options) File "/Users/Jessica/anaconda/lib/python3.4/site-packages/celery/app/base.py", line 354, in send_task reply_to=reply_to or self.oid, **options File "/Users/Jessica/anaconda/lib/python3.4/site-packages/celery/app/amqp.py", line 310, in publish_task **kwargs File "/Users/Jessica/anaconda/lib/python3.4/site-packages/kombu/messaging.py", line 172, in publish routing_key, mandatory, immediate, exchange, declare) File "/Users/Jessica/anaconda/lib/python3.4/site-packages/kombu/connection.py", line 470, in _ensured interval_max) File "/Users/Jessica/anaconda/lib/python3.4/site-packages/kombu/connection.py", line 382, in ensure_connection interval_start, interval_step, interval_max, callback) File "/Users/Jessica/anaconda/lib/python3.4/site-packages/kombu/utils/__init__.py", line 246, in retry_over_time return fun(*args, **kwargs) File "/Users/Jessica/anaconda/lib/python3.4/site-packages/kombu/connection.py", line 250, in connect return self.connection File "/Users/Jessica/anaconda/lib/python3.4/site-packages/kombu/connection.py", line 756, in connection self._connection = self._establish_connection() File "/Users/Jessica/anaconda/lib/python3.4/site-packages/kombu/connection.py", line 711, in _establish_connection conn = self.transport.establish_connection() File "/Users/Jessica/anaconda/lib/python3.4/site-packages/kombu/transport/pyamqp.py", line 116, in establish_connection conn = self.Connection(**opts) File "/Users/Jessica/anaconda/lib/python3.4/site-packages/amqp/connection.py", line 165, in __init__ self.transport = self.Transport(host, connect_timeout, ssl) File "/Users/Jessica/anaconda/lib/python3.4/site-packages/amqp/connection.py", line 186, in Transport return create_transport(host, connect_timeout, ssl) File "/Users/Jessica/anaconda/lib/python3.4/site-packages/amqp/transport.py", line 299, in create_transport return TCPTransport(host, connect_timeout) File "/Users/Jessica/anaconda/lib/python3.4/site-packages/amqp/transport.py", line 95, in __init__ raise socket.error(last_err) OSError: [Errno 61] Connection refused `
---------------------------------------------------------------- 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: us...@infra.apache.org With regards, Apache Git Services