Advertisement
Guest User

Untitled

a guest
Sep 4th, 2021
1,560
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.67 KB | None | 0 0
  1. ---------------------------------------------------------------------------
  2. WantReadError Traceback (most recent call last)
  3. /local_disk0/.ephemeral_nfs/envs/pythonEnv-073a97aa-ae3c-411b-80dd-d03e4f76502e/lib/python3.8/site-packages/snowflake/connector/vendored/urllib3/contrib/pyopenssl.py in wrap_socket(self, sock, server_side, do_handshake_on_connect, suppress_ragged_eofs, server_hostname)
  4. 487 try:
  5. --> 488 cnx.do_handshake()
  6. 489 except OpenSSL.SSL.WantReadError:
  7.  
  8. /databricks/python/lib/python3.8/site-packages/OpenSSL/SSL.py in do_handshake(self)
  9. 1933 result = _lib.SSL_do_handshake(self._ssl)
  10. -> 1934 self._raise_ssl_error(self._ssl, result)
  11. 1935
  12.  
  13. /databricks/python/lib/python3.8/site-packages/OpenSSL/SSL.py in _raise_ssl_error(self, ssl, result)
  14. 1645 if error == _lib.SSL_ERROR_WANT_READ:
  15. -> 1646 raise WantReadError()
  16. 1647 elif error == _lib.SSL_ERROR_WANT_WRITE:
  17.  
  18. WantReadError:
  19.  
  20. During handling of the above exception, another exception occurred:
  21.  
  22. AttributeError Traceback (most recent call last)
  23. /local_disk0/.ephemeral_nfs/envs/pythonEnv-073a97aa-ae3c-411b-80dd-d03e4f76502e/lib/python3.8/site-packages/snowflake/connector/network.py in _request_exec(self, session, method, full_url, headers, data, token, catch_okta_unauthorized_error, is_raw_text, is_raw_binary, binary_data_handler, socket_timeout)
  24. 809 # ReadTimeout is raised.
  25. --> 810 raw_ret = session.request(
  26. 811 method=method,
  27.  
  28. /local_disk0/.ephemeral_nfs/envs/pythonEnv-073a97aa-ae3c-411b-80dd-d03e4f76502e/lib/python3.8/site-packages/snowflake/connector/vendored/requests/sessions.py in request(self, method, url, params, data, headers, cookies, files, auth, timeout, allow_redirects, proxies, hooks, stream, verify, cert, json)
  29. 529 send_kwargs.update(settings)
  30. --> 530 resp = self.send(prep, **send_kwargs)
  31. 531
  32.  
  33. /local_disk0/.ephemeral_nfs/envs/pythonEnv-073a97aa-ae3c-411b-80dd-d03e4f76502e/lib/python3.8/site-packages/snowflake/connector/vendored/requests/sessions.py in send(self, request, **kwargs)
  34. 642 # Send the request
  35. --> 643 r = adapter.send(request, **kwargs)
  36. 644
  37.  
  38. /local_disk0/.ephemeral_nfs/envs/pythonEnv-073a97aa-ae3c-411b-80dd-d03e4f76502e/lib/python3.8/site-packages/snowflake/connector/vendored/requests/adapters.py in send(self, request, stream, timeout, verify, cert, proxies)
  39. 438 if not chunked:
  40. --> 439 resp = conn.urlopen(
  41. 440 method=request.method,
  42.  
  43. /local_disk0/.ephemeral_nfs/envs/pythonEnv-073a97aa-ae3c-411b-80dd-d03e4f76502e/lib/python3.8/site-packages/snowflake/connector/vendored/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)
  44. 669 # Make the request on the httplib connection object.
  45. --> 670 httplib_response = self._make_request(
  46. 671 conn,
  47.  
  48. /local_disk0/.ephemeral_nfs/envs/pythonEnv-073a97aa-ae3c-411b-80dd-d03e4f76502e/lib/python3.8/site-packages/snowflake/connector/vendored/urllib3/connectionpool.py in _make_request(self, conn, method, url, timeout, chunked, **httplib_request_kw)
  49. 380 try:
  50. --> 381 self._validate_conn(conn)
  51. 382 except (SocketTimeout, BaseSSLError) as e:
  52.  
  53. /local_disk0/.ephemeral_nfs/envs/pythonEnv-073a97aa-ae3c-411b-80dd-d03e4f76502e/lib/python3.8/site-packages/snowflake/connector/vendored/urllib3/connectionpool.py in _validate_conn(self, conn)
  54. 977 if not getattr(conn, "sock", None): # AppEngine might not have `.sock`
  55. --> 978 conn.connect()
  56. 979
  57.  
  58. /local_disk0/.ephemeral_nfs/envs/pythonEnv-073a97aa-ae3c-411b-80dd-d03e4f76502e/lib/python3.8/site-packages/snowflake/connector/vendored/urllib3/connection.py in connect(self)
  59. 361
  60. --> 362 self.sock = ssl_wrap_socket(
  61. 363 sock=conn,
  62.  
  63. /local_disk0/.ephemeral_nfs/envs/pythonEnv-073a97aa-ae3c-411b-80dd-d03e4f76502e/lib/python3.8/site-packages/snowflake/connector/ssl_wrap_socket.py in ssl_wrap_socket_with_ocsp(*args, **kwargs)
  64. 69
  65. ---> 70 ret = ssl_.ssl_wrap_socket(*args, **kwargs)
  66. 71
  67.  
  68. /local_disk0/.ephemeral_nfs/envs/pythonEnv-073a97aa-ae3c-411b-80dd-d03e4f76502e/lib/python3.8/site-packages/snowflake/connector/vendored/urllib3/util/ssl_.py in ssl_wrap_socket(sock, keyfile, certfile, cert_reqs, ca_certs, server_hostname, ssl_version, ciphers, ssl_context, ca_cert_dir, key_password, ca_cert_data)
  69. 383 if HAS_SNI and server_hostname is not None:
  70. --> 384 return context.wrap_socket(sock, server_hostname=server_hostname)
  71. 385
  72.  
  73. /local_disk0/.ephemeral_nfs/envs/pythonEnv-073a97aa-ae3c-411b-80dd-d03e4f76502e/lib/python3.8/site-packages/snowflake/connector/vendored/urllib3/contrib/pyopenssl.py in wrap_socket(self, sock, server_side, do_handshake_on_connect, suppress_ragged_eofs, server_hostname)
  74. 489 except OpenSSL.SSL.WantReadError:
  75. --> 490 if not util.wait_for_read(sock, sock.gettimeout()):
  76. 491 raise timeout("select timed out")
  77.  
  78. /local_disk0/.ephemeral_nfs/envs/pythonEnv-073a97aa-ae3c-411b-80dd-d03e4f76502e/lib/python3.8/site-packages/snowflake/connector/vendored/urllib3/util/wait.py in wait_for_read(sock, timeout)
  79. 145 """
  80. --> 146 return wait_for_socket(sock, read=True, timeout=timeout)
  81. 147
  82.  
  83. /local_disk0/.ephemeral_nfs/envs/pythonEnv-073a97aa-ae3c-411b-80dd-d03e4f76502e/lib/python3.8/site-packages/snowflake/connector/vendored/urllib3/util/wait.py in poll_wait_for_socket(sock, read, write, timeout)
  84. 97 mask |= select.POLLOUT
  85. ---> 98 poll_obj = select.poll()
  86. 99 poll_obj.register(sock, mask)
  87.  
  88. AttributeError: module 'select' has no attribute 'poll'
  89.  
  90. During handling of the above exception, another exception occurred:
  91.  
  92. RetryRequest Traceback (most recent call last)
  93. /local_disk0/.ephemeral_nfs/envs/pythonEnv-073a97aa-ae3c-411b-80dd-d03e4f76502e/lib/python3.8/site-packages/snowflake/connector/network.py in _request_exec_wrapper(self, session, method, full_url, headers, data, retry_ctx, no_retry, token, **kwargs)
  94. 656 try:
  95. --> 657 return_object = self._request_exec(
  96. 658 session=session,
  97.  
  98. /local_disk0/.ephemeral_nfs/envs/pythonEnv-073a97aa-ae3c-411b-80dd-d03e4f76502e/lib/python3.8/site-packages/snowflake/connector/network.py in _request_exec(self, session, method, full_url, headers, data, token, catch_okta_unauthorized_error, is_raw_text, is_raw_binary, binary_data_handler, socket_timeout)
  99. 910 exc_info=True)
  100. --> 911 raise RetryRequest(err)
  101. 912 except Exception as err:
  102.  
  103. RetryRequest: module 'select' has no attribute 'poll'
  104.  
  105. During handling of the above exception, another exception occurred:
  106.  
  107. OperationalError Traceback (most recent call last)
  108. <command-216810807432721> in <module>
  109. 124 try:
  110. --> 125 ctx = snowflake.connector.connect(
  111. 126 user=dbutils.secrets.get("snowflake", "snowflakeusr"),
  112.  
  113. /local_disk0/.ephemeral_nfs/envs/pythonEnv-073a97aa-ae3c-411b-80dd-d03e4f76502e/lib/python3.8/site-packages/snowflake/connector/__init__.py in Connect(**kwargs)
  114. 49 def Connect(**kwargs):
  115. ---> 50 return SnowflakeConnection(**kwargs)
  116. 51
  117.  
  118. /local_disk0/.ephemeral_nfs/envs/pythonEnv-073a97aa-ae3c-411b-80dd-d03e4f76502e/lib/python3.8/site-packages/snowflake/connector/connection.py in __init__(self, **kwargs)
  119. 227 self.converter = None
  120. --> 228 self.connect(**kwargs)
  121. 229 self._telemetry = TelemetryClient(self._rest)
  122.  
  123. /local_disk0/.ephemeral_nfs/envs/pythonEnv-073a97aa-ae3c-411b-80dd-d03e4f76502e/lib/python3.8/site-packages/snowflake/connector/connection.py in connect(self, **kwargs)
  124. 422 self.__set_error_attributes()
  125. --> 423 self.__open_connection()
  126. 424
  127.  
  128. /local_disk0/.ephemeral_nfs/envs/pythonEnv-073a97aa-ae3c-411b-80dd-d03e4f76502e/lib/python3.8/site-packages/snowflake/connector/connection.py in __open_connection(self)
  129. 632 auth.read_temporary_credentials(self.host, self.user, self._session_parameters)
  130. --> 633 self._authenticate(auth_instance)
  131. 634
  132.  
  133. /local_disk0/.ephemeral_nfs/envs/pythonEnv-073a97aa-ae3c-411b-80dd-d03e4f76502e/lib/python3.8/site-packages/snowflake/connector/connection.py in _authenticate(self, auth_instance)
  134. 865 try:
  135. --> 866 self.__authenticate(self.__preprocess_auth_instance(auth_instance))
  136. 867 except ReauthenticationRequest as ex:
  137.  
  138. /local_disk0/.ephemeral_nfs/envs/pythonEnv-073a97aa-ae3c-411b-80dd-d03e4f76502e/lib/python3.8/site-packages/snowflake/connector/connection.py in __authenticate(self, auth_instance)
  139. 883 auth = Auth(self.rest)
  140. --> 884 self._session_parameters = auth.authenticate(
  141. 885 auth_instance=auth_instance,
  142.  
  143. /local_disk0/.ephemeral_nfs/envs/pythonEnv-073a97aa-ae3c-411b-80dd-d03e4f76502e/lib/python3.8/site-packages/snowflake/connector/auth.py in authenticate(self, auth_instance, account, user, database, schema, warehouse, role, passcode, passcode_in_password, mfa_callback, password_callback, session_parameters, timeout)
  144. 196 try:
  145. --> 197 ret = self._rest._post_request(
  146. 198 url, headers, json.dumps(body),
  147.  
  148. /local_disk0/.ephemeral_nfs/envs/pythonEnv-073a97aa-ae3c-411b-80dd-d03e4f76502e/lib/python3.8/site-packages/snowflake/connector/network.py in _post_request(self, url, headers, body, token, timeout, _no_results, no_retry, socket_timeout, _include_retry_params)
  149. 540
  150. --> 541 ret = self.fetch('post', full_url, headers, data=body,
  151. 542 timeout=timeout, token=token,
  152.  
  153. /local_disk0/.ephemeral_nfs/envs/pythonEnv-073a97aa-ae3c-411b-80dd-d03e4f76502e/lib/python3.8/site-packages/snowflake/connector/network.py in fetch(self, method, full_url, headers, data, timeout, **kwargs)
  154. 621 while True:
  155. --> 622 ret = self._request_exec_wrapper(
  156. 623 session, method, full_url, headers, data, retry_ctx,
  157.  
  158. /local_disk0/.ephemeral_nfs/envs/pythonEnv-073a97aa-ae3c-411b-80dd-d03e4f76502e/lib/python3.8/site-packages/snowflake/connector/network.py in _request_exec_wrapper(self, session, method, full_url, headers, data, retry_ctx, no_retry, token, **kwargs)
  159. 712 else:
  160. --> 713 self.handle_invalid_certificate_error(
  161. 714 conn, full_url, cause)
  162.  
  163. /local_disk0/.ephemeral_nfs/envs/pythonEnv-073a97aa-ae3c-411b-80dd-d03e4f76502e/lib/python3.8/site-packages/snowflake/connector/network.py in handle_invalid_certificate_error(self, conn, full_url, cause)
  164. 738 # all other errors raise exception
  165. --> 739 Error.errorhandler_wrapper(
  166. 740 conn, None, OperationalError,
  167.  
  168. /local_disk0/.ephemeral_nfs/envs/pythonEnv-073a97aa-ae3c-411b-80dd-d03e4f76502e/lib/python3.8/site-packages/snowflake/connector/errors.py in errorhandler_wrapper(connection, cursor, error_class, error_value)
  169. 226 elif connection is not None:
  170. --> 227 connection.errorhandler(connection, cursor, error_class, error_value)
  171. 228 return
  172.  
  173. /local_disk0/.ephemeral_nfs/envs/pythonEnv-073a97aa-ae3c-411b-80dd-d03e4f76502e/lib/python3.8/site-packages/snowflake/connector/errors.py in default_errorhandler(connection, cursor, error_class, error_value)
  174. 178 """
  175. --> 179 raise error_class(
  176. 180 msg=error_value.get('msg'),
  177.  
  178. OperationalError: 250003: Failed to execute request: module 'select' has no attribute 'poll'
  179.  
  180. During handling of the above exception, another exception occurred:
  181.  
  182. Exception Traceback (most recent call last)
  183. <command-216810807432721> in <module>
  184. 455 except Exception as error:
  185. --> 456 raise Exception("Error fetching data from Snowflake: " + str(error))
  186. 457 finally:
  187.  
  188. Exception: Error fetching data from Snowflake: 250003: Failed to execute request: module 'select' has no attribute 'poll'
  189.  
  190. During handling of the above exception, another exception occurred:
  191.  
  192. NameError Traceback (most recent call last)
  193. <command-216810807432721> in <module>
  194. 456 raise Exception("Error fetching data from Snowflake: " + str(error))
  195. 457 finally:
  196. --> 458 cs.close()
  197. 459 ctx.close()
  198.  
  199. NameError: name 'cs' is not defined
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement