{"action":"created","issue":{"url":"https://api.github.com/repos/airbnb/superset/issues/1741","repository_url":"https://api.github.com/repos/airbnb/superset","labels_url":"https://api.github.com/repos/airbnb/superset/issues/1741/labels{/name}","comments_url":"https://api.github.com/repos/airbnb/superset/issues/1741/comments","events_url":"https://api.github.com/repos/airbnb/superset/issues/1741/events","html_url":"https://github.com/airbnb/superset/issues/1741","id":193107269,"number":1741,"title":"Run Async in SQL Lab is not working (socket error)","user":{"login":"Gowtham95india","id":8710113,"avatar_url":"https://avatars.githubusercontent.com/u/8710113?v=3","gravatar_id":"","url":"https://api.github.com/users/Gowtham95india","html_url":"https://github.com/Gowtham95india","followers_url":"https://api.github.com/users/Gowtham95india/followers","following_url":"https://api.github.com/users/Gowtham95india/following{/other_user}","gists_url":"https://api.github.com/users/Gowtham95india/gists{/gist_id}","starred_url":"https://api.github.com/users/Gowtham95india/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Gowtham95india/subscriptions","organizations_url":"https://api.github.com/users/Gowtham95india/orgs","repos_url":"https://api.github.com/users/Gowtham95india/repos","events_url":"https://api.github.com/users/Gowtham95india/events{/privacy}","received_events_url":"https://api.github.com/users/Gowtham95india/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2016-12-02T12:40:23Z","updated_at":"2016-12-03T10:20:50Z","closed_at":null,"body":"Make sure these boxes are checked before submitting your issue - thank you!\r\n\r\n- [Yes] I have checked the superset logs for python stacktraces and included it here as text if any\r\n- [Yes] I have reproduced the issue with at least the latest released version of superset\r\n- [Yes] I have checked the issue tracker for the same issue and I haven't found one similar\r\n\r\n\r\n### Superset version - 0.14.1\r\n\r\n\r\n### Expected results\r\nShould run the query in Async mode and show result. \r\n\r\n\r\n### Actual results\r\nException -\r\n\r\n```\r\nTraceback (most recent call last):\r\n  File \"/usr/local/lib/python2.7/dist-packages/flask/app.py\", line 2000, in __call__\r\n    return self.wsgi_app(environ, start_response)\r\n  File \"/usr/local/lib/python2.7/dist-packages/flask/app.py\", line 1991, in wsgi_app\r\n    response = self.make_response(self.handle_exception(e))\r\n  File \"/usr/local/lib/python2.7/dist-packages/flask/app.py\", line 1567, in handle_exception\r\n    reraise(exc_type, exc_value, tb)\r\n  File \"/usr/local/lib/python2.7/dist-packages/flask/app.py\", line 1988, in wsgi_app\r\n    response = self.full_dispatch_request()\r\n  File \"/usr/local/lib/python2.7/dist-packages/flask/app.py\", line 1641, in full_dispatch_request\r\n    rv = self.handle_user_exception(e)\r\n  File \"/usr/local/lib/python2.7/dist-packages/flask/app.py\", line 1544, in handle_user_exception\r\n    reraise(exc_type, exc_value, tb)\r\n  File \"/usr/local/lib/python2.7/dist-packages/flask/app.py\", line 1639, in full_dispatch_request\r\n    rv = self.dispatch_request()\r\n  File \"/usr/local/lib/python2.7/dist-packages/flask/app.py\", line 1625, in dispatch_request\r\n    return self.view_functions[rule.endpoint](**req.view_args)\r\n  File \"/usr/local/lib/python2.7/dist-packages/flask_appbuilder/security/decorators.py\", line 52, in wraps\r\n    return f(self, *args, **kwargs)\r\n  File \"/usr/local/lib/python2.7/dist-packages/superset/models.py\", line 2279, in wrapper\r\n    return f(*args, **kwargs)\r\n  File \"/usr/local/lib/python2.7/dist-packages/superset/views.py\", line 2373, in sql_json\r\n    store_results=not query.select_as_cta)\r\n  File \"/usr/local/lib/python2.7/dist-packages/celery/app/task.py\", line 453, in delay\r\n    return self.apply_async(args, kwargs)\r\n  File \"/usr/local/lib/python2.7/dist-packages/celery/app/task.py\", line 565, in apply_async\r\n    **dict(self._get_exec_options(), **options)\r\n  File \"/usr/local/lib/python2.7/dist-packages/celery/app/base.py\", line 354, in send_task\r\n    reply_to=reply_to or self.oid, **options\r\n  File \"/usr/local/lib/python2.7/dist-packages/celery/app/amqp.py\", line 310, in publish_task\r\n    **kwargs\r\n  File \"/usr/local/lib/python2.7/dist-packages/kombu/messaging.py\", line 172, in publish\r\n    routing_key, mandatory, immediate, exchange, declare)\r\n  File \"/usr/local/lib/python2.7/dist-packages/kombu/connection.py\", line 470, in _ensured\r\n    interval_max)\r\n  File \"/usr/local/lib/python2.7/dist-packages/kombu/connection.py\", line 382, in ensure_connection\r\n    interval_start, interval_step, interval_max, callback)\r\n  File \"/usr/local/lib/python2.7/dist-packages/kombu/utils/__init__.py\", line 246, in retry_over_time\r\n    return fun(*args, **kwargs)\r\n  File \"/usr/local/lib/python2.7/dist-packages/kombu/connection.py\", line 250, in connect\r\n    return self.connection\r\n  File \"/usr/local/lib/python2.7/dist-packages/kombu/connection.py\", line 756, in connection\r\n    self._connection = self._establish_connection()\r\n  File \"/usr/local/lib/python2.7/dist-packages/kombu/connection.py\", line 711, in _establish_connection\r\n    conn = self.transport.establish_connection()\r\n  File \"/usr/local/lib/python2.7/dist-packages/kombu/transport/pyamqp.py\", line 116, in establish_connection\r\n    conn = self.Connection(**opts)\r\n  File \"/usr/local/lib/python2.7/dist-packages/amqp/connection.py\", line 165, in __init__\r\n    self.transport = self.Transport(host, connect_timeout, ssl)\r\n  File \"/usr/local/lib/python2.7/dist-packages/amqp/connection.py\", line 186, in Transport\r\n    return create_transport(host, connect_timeout, ssl)\r\n  File \"/usr/local/lib/python2.7/dist-packages/amqp/transport.py\", line 299, in create_transport\r\n    return TCPTransport(host, connect_timeout)\r\n  File \"/usr/local/lib/python2.7/dist-packages/amqp/transport.py\", line 95, in __init__\r\n    raise socket.error(last_err)\r\nerror: [Errno 111] Connection refused\r\n```\r\n\r\n\r\n\r\n\r\n### Steps to reproduce\r\n\r\n> Type any proper query in sql lab and click on **Run Async**\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/airbnb/superset/issues/comments/264630622","html_url":"https://github.com/airbnb/superset/issues/1741#issuecomment-264630622","issue_url":"https://api.github.com/repos/airbnb/superset/issues/1741","id":264630622,"user":{"login":"Gowtham95india","id":8710113,"avatar_url":"https://avatars.githubusercontent.com/u/8710113?v=3","gravatar_id":"","url":"https://api.github.com/users/Gowtham95india","html_url":"https://github.com/Gowtham95india","followers_url":"https://api.github.com/users/Gowtham95india/followers","following_url":"https://api.github.com/users/Gowtham95india/following{/other_user}","gists_url":"https://api.github.com/users/Gowtham95india/gists{/gist_id}","starred_url":"https://api.github.com/users/Gowtham95india/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Gowtham95india/subscriptions","organizations_url":"https://api.github.com/users/Gowtham95india/orgs","repos_url":"https://api.github.com/users/Gowtham95india/repos","events_url":"https://api.github.com/users/Gowtham95india/events{/privacy}","received_events_url":"https://api.github.com/users/Gowtham95india/received_events","type":"User","site_admin":false},"created_at":"2016-12-03T10:20:50Z","updated_at":"2016-12-03T10:20:50Z","body":"@mistercrunch \r\n\r\nDo I need to start celery workers? I'm getting the following error when starting them using \r\n\r\n> celery worker -A  superset\r\n\r\n> Traceback (most recent call last):\r\n  File \"/usr/local/bin/celery\", line 11, in <module>\r\n    sys.exit(main())\r\n  File \"/usr/local/lib/python2.7/dist-packages/celery/__main__.py\", line 14, in main\r\n    _main()\r\n  File \"/usr/local/lib/python2.7/dist-packages/celery/bin/celery.py\", line 326, in main\r\n    cmd.execute_from_commandline(argv)\r\n  File \"/usr/local/lib/python2.7/dist-packages/celery/bin/celery.py\", line 488, in execute_from_commandline\r\n    super(CeleryCommand, self).execute_from_commandline(argv)))\r\n  File \"/usr/local/lib/python2.7/dist-packages/celery/bin/base.py\", line 276, in execute_from_commandline\r\n    argv = self.setup_app_from_commandline(argv)\r\n  File \"/usr/local/lib/python2.7/dist-packages/celery/bin/base.py\", line 486, in setup_app_from_commandline\r\n    self._handle_user_preload_options(argv)\r\n  File \"/usr/local/lib/python2.7/dist-packages/celery/bin/base.py\", line 491, in _handle_user_preload_options\r\n    user_preload = tuple(self.app.user_options['preload'] or ())\r\nAttributeError: 'Flask' object has no attribute 'user_options'\r\n"}}
{"actor":{"display_login":"Gowtham95india"}}