You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@superset.apache.org by GitBox <gi...@apache.org> on 2017/10/19 09:27:03 UTC
[GitHub] jessicachen888 commented on issue #3694: Foreign table cannot be loaded in SQL lab Tab
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:
users@infra.apache.org
With regards,
Apache Git Services