Skip to content

DB connection issue in bike tutorial ipnb #29

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Closed
csaranbalaji opened this issue Oct 5, 2020 · 1 comment · Fixed by #30
Closed

DB connection issue in bike tutorial ipnb #29

csaranbalaji opened this issue Oct 5, 2020 · 1 comment · Fixed by #30

Comments

@csaranbalaji
Copy link
Contributor

csaranbalaji commented Oct 5, 2020

As mentioned in #22, Checked the bike-tutorial.
Using the latest version of terminusdb and terminusdb-client .
terminusdb-client = 0.4.0

image

Exception trace:

~/personal_repos/pycon-devsprint2020/terminusdb/terminusdb-bootstrap/env/lib/python3.7/site-packages/urllib3/connectionpool.py in urlopen(self, method, url, body, headers, retries, redirect, assert_same_host, timeout, pool_timeout, release_conn, chunked, body_pos, **response_kw)
    676                 headers=headers,
--> 677                 chunked=chunked,
    678             )

~/personal_repos/pycon-devsprint2020/terminusdb/terminusdb-bootstrap/env/lib/python3.7/site-packages/urllib3/connectionpool.py in _make_request(self, conn, method, url, timeout, chunked, **httplib_request_kw)
    425                     # Otherwise it looks like a bug in the code.
--> 426                     six.raise_from(e, None)
    427         except (SocketTimeout, BaseSSLError, SocketError) as e:

~/personal_repos/pycon-devsprint2020/terminusdb/terminusdb-bootstrap/env/lib/python3.7/site-packages/urllib3/packages/six.py in raise_from(value, from_value)

~/personal_repos/pycon-devsprint2020/terminusdb/terminusdb-bootstrap/env/lib/python3.7/site-packages/urllib3/connectionpool.py in _make_request(self, conn, method, url, timeout, chunked, **httplib_request_kw)
    420                 try:
--> 421                     httplib_response = conn.getresponse()
    422                 except BaseException as e:

/usr/local/Cellar/python/3.7.5/Frameworks/Python.framework/Versions/3.7/lib/python3.7/http/client.py in getresponse(self)
   1343             try:
-> 1344                 response.begin()
   1345             except ConnectionError:

/usr/local/Cellar/python/3.7.5/Frameworks/Python.framework/Versions/3.7/lib/python3.7/http/client.py in begin(self)
    305         while True:
--> 306             version, status, reason = self._read_status()
    307             if status != CONTINUE:

/usr/local/Cellar/python/3.7.5/Frameworks/Python.framework/Versions/3.7/lib/python3.7/http/client.py in _read_status(self)
    274             # sending a valid response.
--> 275             raise RemoteDisconnected("Remote end closed connection without"
    276                                      " response")

RemoteDisconnected: Remote end closed connection without response

During handling of the above exception, another exception occurred:

ProtocolError                             Traceback (most recent call last)
~/personal_repos/pycon-devsprint2020/terminusdb/terminusdb-bootstrap/env/lib/python3.7/site-packages/requests/adapters.py in send(self, request, stream, timeout, verify, cert, proxies)
    448                     retries=self.max_retries,
--> 449                     timeout=timeout
    450                 )

~/personal_repos/pycon-devsprint2020/terminusdb/terminusdb-bootstrap/env/lib/python3.7/site-packages/urllib3/connectionpool.py in urlopen(self, method, url, body, headers, retries, redirect, assert_same_host, timeout, pool_timeout, release_conn, chunked, body_pos, **response_kw)
    726             retries = retries.increment(
--> 727                 method, url, error=e, _pool=self, _stacktrace=sys.exc_info()[2]
    728             )

~/personal_repos/pycon-devsprint2020/terminusdb/terminusdb-bootstrap/env/lib/python3.7/site-packages/urllib3/util/retry.py in increment(self, method, url, response, error, _pool, _stacktrace)
    402             if read is False or not self._is_method_retryable(method):
--> 403                 raise six.reraise(type(error), error, _stacktrace)
    404             elif read is not None:

~/personal_repos/pycon-devsprint2020/terminusdb/terminusdb-bootstrap/env/lib/python3.7/site-packages/urllib3/packages/six.py in reraise(tp, value, tb)
    733             if value.__traceback__ is not tb:
--> 734                 raise value.with_traceback(tb)
    735             raise value

~/personal_repos/pycon-devsprint2020/terminusdb/terminusdb-bootstrap/env/lib/python3.7/site-packages/urllib3/connectionpool.py in urlopen(self, method, url, body, headers, retries, redirect, assert_same_host, timeout, pool_timeout, release_conn, chunked, body_pos, **response_kw)
    676                 headers=headers,
--> 677                 chunked=chunked,
    678             )

~/personal_repos/pycon-devsprint2020/terminusdb/terminusdb-bootstrap/env/lib/python3.7/site-packages/urllib3/connectionpool.py in _make_request(self, conn, method, url, timeout, chunked, **httplib_request_kw)
    425                     # Otherwise it looks like a bug in the code.
--> 426                     six.raise_from(e, None)
    427         except (SocketTimeout, BaseSSLError, SocketError) as e:

~/personal_repos/pycon-devsprint2020/terminusdb/terminusdb-bootstrap/env/lib/python3.7/site-packages/urllib3/packages/six.py in raise_from(value, from_value)

~/personal_repos/pycon-devsprint2020/terminusdb/terminusdb-bootstrap/env/lib/python3.7/site-packages/urllib3/connectionpool.py in _make_request(self, conn, method, url, timeout, chunked, **httplib_request_kw)
    420                 try:
--> 421                     httplib_response = conn.getresponse()
    422                 except BaseException as e:

/usr/local/Cellar/python/3.7.5/Frameworks/Python.framework/Versions/3.7/lib/python3.7/http/client.py in getresponse(self)
   1343             try:
-> 1344                 response.begin()
   1345             except ConnectionError:

/usr/local/Cellar/python/3.7.5/Frameworks/Python.framework/Versions/3.7/lib/python3.7/http/client.py in begin(self)
    305         while True:
--> 306             version, status, reason = self._read_status()
    307             if status != CONTINUE:

/usr/local/Cellar/python/3.7.5/Frameworks/Python.framework/Versions/3.7/lib/python3.7/http/client.py in _read_status(self)
    274             # sending a valid response.
--> 275             raise RemoteDisconnected("Remote end closed connection without"
    276                                      " response")

ProtocolError: ('Connection aborted.', RemoteDisconnected('Remote end closed connection without response'))

During handling of the above exception, another exception occurred:

ConnectionError                           Traceback (most recent call last)
<ipython-input-10-4786c25b6cd9> in <module>
     12 
     13 client = woql.WOQLClient(server_url)
---> 14 client.connect(key=key, account=account_id, user=user_id)
     15 
     16 existing = client.get_metadata(db_id, client.uid())

~/personal_repos/pycon-devsprint2020/terminusdb/terminusdb-bootstrap/env/lib/python3.7/site-packages/terminusdb_client/woqlclient/woqlClient.py in connect(self, **kwargs)
     69             self.insecure = kwargs.get("insecure")
     70 
---> 71         json_obj = self.dispatch(APIEndpointConst.CONNECT, self.conConfig.api)
     72         self.conCapabilities.set_capabilities(json_obj)
     73         return json_obj

~/personal_repos/pycon-devsprint2020/terminusdb/terminusdb-bootstrap/env/lib/python3.7/site-packages/terminusdb_client/woqlclient/woqlClient.py in dispatch(self, action, url, payload, file_dict)
   1163             self.remote_auth(),
   1164             file_dict,
-> 1165             self.insecure,
   1166         )
   1167 

~/personal_repos/pycon-devsprint2020/terminusdb/terminusdb-bootstrap/env/lib/python3.7/site-packages/terminusdb_client/woqlclient/dispatchRequest.py in send_request_by_action(cls, url, action, payload, basic_auth, remote_auth, file_dict, insecure)
    150             ]:
    151                 request_response = cls.__get_call(
--> 152                     url, headers, payload, insecure=insecure
    153                 )
    154 

~/personal_repos/pycon-devsprint2020/terminusdb/terminusdb-bootstrap/env/lib/python3.7/site-packages/terminusdb_client/woqlclient/dispatchRequest.py in __get_call(url, headers, payload, insecure)
     28         if not _verify_check(url, insecure):
     29             warnings.simplefilter("ignore", InsecureRequestWarning)
---> 30         result = requests.get(url, headers=headers, verify=_verify_check(url, insecure))
     31         warnings.resetwarnings()
     32         return result

~/personal_repos/pycon-devsprint2020/terminusdb/terminusdb-bootstrap/env/lib/python3.7/site-packages/requests/api.py in get(url, params, **kwargs)
     74 
     75     kwargs.setdefault('allow_redirects', True)
---> 76     return request('get', url, params=params, **kwargs)
     77 
     78 

~/personal_repos/pycon-devsprint2020/terminusdb/terminusdb-bootstrap/env/lib/python3.7/site-packages/requests/api.py in request(method, url, **kwargs)
     59     # cases, and look like a memory leak in others.
     60     with sessions.Session() as session:
---> 61         return session.request(method=method, url=url, **kwargs)
     62 
     63 

~/personal_repos/pycon-devsprint2020/terminusdb/terminusdb-bootstrap/env/lib/python3.7/site-packages/requests/sessions.py in request(self, method, url, params, data, headers, cookies, files, auth, timeout, allow_redirects, proxies, hooks, stream, verify, cert, json)
    528         }
    529         send_kwargs.update(settings)
--> 530         resp = self.send(prep, **send_kwargs)
    531 
    532         return resp

~/personal_repos/pycon-devsprint2020/terminusdb/terminusdb-bootstrap/env/lib/python3.7/site-packages/requests/sessions.py in send(self, request, **kwargs)
    641 
    642         # Send the request
--> 643         r = adapter.send(request, **kwargs)
    644 
    645         # Total elapsed time of the request (approximately)

~/personal_repos/pycon-devsprint2020/terminusdb/terminusdb-bootstrap/env/lib/python3.7/site-packages/requests/adapters.py in send(self, request, stream, timeout, verify, cert, proxies)
    496 
    497         except (ProtocolError, socket.error) as err:
--> 498             raise ConnectionError(err, request=request)
    499 
    500         except MaxRetryError as e:

ConnectionError: ('Connection aborted.', RemoteDisconnected('Remote end closed connection without response'))```
@csaranbalaji
Copy link
Contributor Author

@Cheukting Could you please check the issue and PR?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant