metaperl opened a new issue #8520: `superset load_examples` times out with 
TimeoutError: [Errno 110] Connection timed out
URL: https://github.com/apache/incubator-superset/issues/8520
 
 
   A clear and concise description of what the bug is.
   
   ### Expected results
   
   Successful load of examples after invoking `superset load_examples`
   
   ### Actual results
   ` TimeoutError: [Errno 110] Connection timed out `
   
   #### Screenshots
   
   ```
   (venv-superset) [root@usb-gce-superset-dev-01 ~]# superset load_examples
   2019-11-06 20:55:20,276:INFO:root:Configured event logger of type <class 
'superset.utils.log.DBEventLogger'>
   Loading examples metadata and related data into examples
   Creating default CSS templates
   Loading energy related dataset
   2019-11-06 20:55:21,806:INFO:root:Database.get_sqla_engine(). Masked URL: 
sqlite:////root/.superset/superset.db
   Traceback (most recent call last):
     File "/usr/lib64/python3.6/urllib/request.py", line 1318, in do_open
       encode_chunked=req.has_header('Transfer-encoding'))
     File "/usr/lib64/python3.6/http/client.py", line 1254, in request
       self._send_request(method, url, body, headers, encode_chunked)
     File "/usr/lib64/python3.6/http/client.py", line 1300, in _send_request
       self.endheaders(body, encode_chunked=encode_chunked)
     File "/usr/lib64/python3.6/http/client.py", line 1249, in endheaders
       self._send_output(message_body, encode_chunked=encode_chunked)
     File "/usr/lib64/python3.6/http/client.py", line 1036, in _send_output
       self.send(msg)
     File "/usr/lib64/python3.6/http/client.py", line 974, in send
       self.connect()
     File "/usr/lib64/python3.6/http/client.py", line 1407, in connect
       super().connect()
     File "/usr/lib64/python3.6/http/client.py", line 946, in connect
       (self.host,self.port), self.timeout, self.source_address)
     File "/usr/lib64/python3.6/socket.py", line 724, in create_connection
       raise err
     File "/usr/lib64/python3.6/socket.py", line 713, in create_connection
       sock.connect(sa)
   TimeoutError: [Errno 110] Connection timed out
   
   During handling of the above exception, another exception occurred:
   
   Traceback (most recent call last):
     File "/root/venv-superset/bin/superset", line 31, in <module>
       cli()
     File "/root/venv-superset/lib/python3.6/site-packages/click/core.py", line 
722, in __call__
       return self.main(*args, **kwargs)
     File "/root/venv-superset/lib/python3.6/site-packages/flask/cli.py", line 
586, in main
       return super(FlaskGroup, self).main(*args, **kwargs)
     File "/root/venv-superset/lib/python3.6/site-packages/click/core.py", line 
697, in main
       rv = self.invoke(ctx)
     File "/root/venv-superset/lib/python3.6/site-packages/click/core.py", line 
1066, in invoke
       return _process_result(sub_ctx.command.invoke(sub_ctx))
     File "/root/venv-superset/lib/python3.6/site-packages/click/core.py", line 
895, in invoke
       return ctx.invoke(self.callback, **ctx.params)
     File "/root/venv-superset/lib/python3.6/site-packages/click/core.py", line 
535, in invoke
       return callback(*args, **kwargs)
     File 
"/root/venv-superset/lib/python3.6/site-packages/click/decorators.py", line 17, 
in new_func
       return f(get_current_context(), *args, **kwargs)
     File "/root/venv-superset/lib/python3.6/site-packages/flask/cli.py", line 
426, in decorator
       return __ctx.invoke(f, *args, **kwargs)
     File "/root/venv-superset/lib/python3.6/site-packages/click/core.py", line 
535, in invoke
       return callback(*args, **kwargs)
     File "/root/venv-superset/lib/python3.6/site-packages/superset/cli.py", 
line 143, in load_examples
       load_examples_run(load_test_data, only_metadata, force)
     File "/root/venv-superset/lib/python3.6/site-packages/superset/cli.py", 
line 84, in load_examples_run
       examples.load_energy(only_metadata, force)
     File 
"/root/venv-superset/lib/python3.6/site-packages/superset/examples/energy.py", 
line 38, in load_energy
       data = get_example_data("energy.json.gz")
     File 
"/root/venv-superset/lib/python3.6/site-packages/superset/examples/helpers.py", 
line 72, in get_example_data
       content = request.urlopen(f"{BASE_URL}{filepath}?raw=true").read()
     File "/usr/lib64/python3.6/urllib/request.py", line 223, in urlopen
       return opener.open(url, data, timeout)
     File "/usr/lib64/python3.6/urllib/request.py", line 526, in open
       response = self._open(req, data)
     File "/usr/lib64/python3.6/urllib/request.py", line 544, in _open
       '_open', req)
     File "/usr/lib64/python3.6/urllib/request.py", line 504, in _call_chain
       result = func(*args)
     File "/usr/lib64/python3.6/urllib/request.py", line 1361, in https_open
       context=self._context, check_hostname=self._check_hostname)
     File "/usr/lib64/python3.6/urllib/request.py", line 1320, in do_open
       raise URLError(err)
   urllib.error.URLError: <urlopen error [Errno 110] Connection timed out>
   (venv-superset) [root@usb-gce-superset-dev-01 ~]#
   ```
   
   #### How to reproduce the bug
   
   1.  `pip install superset`
   2. `superset db upgrade`
   3. `export FLASK_APP=superset; flask fab create-admin`
   4. `superset load_examples`
   
   ### Environment
   
   (please complete the following information):
   
   - superset version: Superset 0.30.0
   - python version: Python 3.6.8
   - node.js version: bash: node: command not found
   - npm version: bash: npm: command not found
   
   ### Checklist
   
   Make sure these boxes are checked before submitting your issue - thank you!
   
   - **I have no idea where to find the logs**
   - [x ] I have reproduced the issue with at least the latest released version 
of superset.
   
   SIMILAR ISSUE -> https://github.com/apache/incubator-superset/issues/8491
   
   # Speculation
   
   Corporate proxy is blocking access to raw.githubusercontent.com and there is 
no way to provide a proxy.
   
   

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to 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

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to