Python问题的Snowflake连接器

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

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

Answer 2

我用snowflake连接器也遇到了同样的问题。问题出在OCSP响应上。使用私有链路时，需要正确配置DNS以验证证书。

我可以使用connect调用中的"insecure_mode=True“选项来解决这个问题。