Python问题的雪花连接器

Question

我安装了snowflake connector python并运行了我的代码。代码在联邦身份验证下运行良好

我试图再次运行代码，但出现错误。我早些时候在Anaconda中收到了相同的错误，然后不得不卸载并重新安装Anaconda，这没有帮助。我最终切换到python+pycharm。同样的错误和行为。代码没有运行。我已连接到VPN，我已断开VPN连接，将笔记本电脑置于睡眠状态，打开笔记本电脑并重新连接到VPN

从描述上看，这是某种证书颁发。我的证书或IP正在更改，导致代码失败

Fatal Python error: Cannot recover from stack overflow.
Python runtime state: initialized

Current thread 0x000022c4 (most recent call first):
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\asn1crypto\core.py", line 632 in dump
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\asn1crypto\core.py", line 1723 in dump
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\asn1crypto\core.py", line 3649 in _set_contents
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\asn1crypto\core.py", line 3421 in contents
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\asn1crypto\core.py", line 629 in dump
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\asn1crypto\core.py", line 4110 in dump
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\asn1crypto\core.py", line 3649 in _set_contents
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\asn1crypto\core.py", line 3421 in contents
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\asn1crypto\core.py", line 629 in dump
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\asn1crypto\core.py", line 4110 in dump
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\asn1crypto\core.py", line 3649 in _set_contents
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\asn1crypto\core.py", line 3421 in contents
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\asn1crypto\core.py", line 629 in dump
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\asn1crypto\core.py", line 4110 in dump
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\asn1crypto\core.py", line 4435 in _set_contents
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\asn1crypto\core.py", line 4191 in contents
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\asn1crypto\core.py", line 4172 in __init__
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\snowflake\connector\ocsp_asn1crypto.py", line 121 in create_ocsp_request
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1153 in _check_ocsp_response_cache_server
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1134 in _validate_certificates_sequential
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 953 in _validate
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 948 in validate
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\snowflake\connector\ssl_wrap_socket.py", line 401 in ssl_wrap_socket_with_ocsp
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\urllib3\connection.py", line 361 in connect
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\urllib3\connectionpool.py", line 976 in _validate_conn
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\urllib3\connectionpool.py", line 381 in _make_request
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\urllib3\connectionpool.py", line 670 in urlopen
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\requests\adapters.py", line 439 in send
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\requests\sessions.py", line 643 in send
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\requests\sessions.py", line 237 in resolve_redirects
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\requests\sessions.py", line 665 in <listcomp>
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\requests\sessions.py", line 665 in send
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\requests\sessions.py", line 530 in request
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\requests\sessions.py", line 543 in get
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 279 in _download_ocsp_response_cache
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 243 in download_cache_from_server
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1161 in _check_ocsp_response_cache_server
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1134 in _validate_certificates_sequential
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 953 in _validate
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 948 in validate
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\snowflake\connector\ssl_wrap_socket.py", line 401 in ssl_wrap_socket_with_ocsp
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\urllib3\connection.py", line 361 in connect
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\urllib3\connectionpool.py", line 976 in _validate_conn
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\urllib3\connectionpool.py", line 381 in _make_request
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\urllib3\connectionpool.py", line 670 in urlopen
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\requests\adapters.py", line 439 in send
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\requests\sessions.py", line 643 in send
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\requests\sessions.py", line 237 in resolve_redirects
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\requests\sessions.py", line 665 in <listcomp>
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\requests\sessions.py", line 665 in send
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\requests\sessions.py", line 530 in request
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\requests\sessions.py", line 543 in get
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 279 in _download_ocsp_response_cache
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 243 in download_cache_from_server
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1161 in _check_ocsp_response_cache_server
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1134 in _validate_certificates_sequential
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 953 in _validate
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 948 in validate
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\snowflake\connector\ssl_wrap_socket.py", line 401 in ssl_wrap_socket_with_ocsp
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\urllib3\connection.py", line 361 in connect
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\urllib3\connectionpool.py", line 976 in _validate_conn
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\urllib3\connectionpool.py", line 381 in _make_request
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\urllib3\connectionpool.py", line 670 in urlopen
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\requests\adapters.py", line 439 in send
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\requests\sessions.py", line 643 in send
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\requests\sessions.py", line 237 in resolve_redirects
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\requests\sessions.py", line 665 in <listcomp>
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\requests\sessions.py", line 665 in send
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\requests\sessions.py", line 530 in request
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1335 in _fetch_ocsp_response
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1068 in validate_by_direct_connection
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1139 in _validate_certificates_sequential
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 953 in _validate
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 948 in validate
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\snowflake\connector\ssl_wrap_socket.py", line 401 in ssl_wrap_socket_with_ocsp
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\urllib3\connection.py", line 361 in connect
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\urllib3\connectionpool.py", line 976 in _validate_conn
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\urllib3\connectionpool.py", line 381 in _make_request
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\urllib3\connectionpool.py", line 670 in urlopen
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\requests\adapters.py", line 439 in send
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\requests\sessions.py", line 643 in send
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\requests\sessions.py", line 237 in resolve_redirects
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\requests\sessions.py", line 665 in <listcomp>
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\requests\sessions.py", line 665 in send
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\requests\sessions.py", line 530 in request
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\requests\sessions.py", line 543 in get
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 279 in _download_ocsp_response_cache
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 243 in download_cache_from_server
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1161 in _check_ocsp_response_cache_server
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1134 in _validate_certificates_sequential
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 953 in _validate
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 948 in validate
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\snowflake\connector\ssl_wrap_socket.py", line 401 in ssl_wrap_socket_with_ocsp
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\urllib3\connection.py", line 361 in connect
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\urllib3\connectionpool.py", line 976 in _validate_conn
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\urllib3\connectionpool.py", line 381 in _make_request
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\urllib3\connectionpool.py", line 670 in urlopen
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\requests\adapters.py", line 439 in send
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\requests\sessions.py", line 643 in send
  File "C:\Users\SMudalgi\PycharmProjects\test.py\venv\lib\site-packages\requests\sessions.py", line 237 in resolve_redirects
  ...

Process finished with exit code -1073740791 (0xC0000409)

Answer 1

我的雪花连接器也有同样的问题。问题在于OCSP的响应。 使用privatelink，需要正确配置DNS以验证证书

我可以在connect调用中使用“unsecure_mode=True”选项来解决这个问题

Answer 2

FWIW，我今天遇到了同样的问题。问题是，根据雪花AWS VPC端点的文档（https://docs.snowflake.com/en/user-guide/admin-security-privatelink.html），没有为其正确设置环境DNS。如果没有这些DNS条目，它正在解析，但它给出了错误，因为（我认为）我想去的地方和我最终去的地方之间存在区域不匹配，所以证书验证失败。它不应该一次又一次地尝试溢出情况，但我认为根本原因是环境问题。也许您可以使用主机文件进行测试，并将OCSP/Snowflake服务器设置为您的端点IP