Skip to content

SNOW-2149941: HTTPS_PROXY triggers a TLS error #2356

@Lilja-at-funnel

Description

@Lilja-at-funnel

Python version

Python 3.13.3

Operating system and processor architecture

macOS-15.5-arm64-arm-64bit-Mach-O

Installed packages

asn1crypto==1.5.1
boto3==1.38.35
botocore==1.38.35
certifi==2025.4.26
cffi==1.17.1
charset-normalizer==3.4.2
cryptography==45.0.4
filelock==3.18.0
idna==3.10
jmespath==1.0.1
packaging==25.0
platformdirs==4.3.8
pycparser==2.22
PyJWT==2.10.1
pyOpenSSL==25.1.0
python-dateutil==2.9.0.post0
pytz==2025.2
requests==2.32.4
s3transfer==0.13.0
six==1.17.0
snowflake-connector-python==3.15.0
sortedcontainers==2.4.0
tomlkit==0.13.3
typing_extensions==4.14.0
urllib3==2.4.0

What did you do?

As per this issue, I'm trying to connect to snowflake using a specific IP adress. As some of our clients has locked down their table/database to a specific IP.

I seem to get this error:

TLS in TLS requires SSLContext.wrap_bio() which isn't available on non-native SSLContext

Click me to see the python script
import logging
import requests
import os
from cryptography.hazmat.primitives import serialization
from cryptography.hazmat.backends import default_backend
import snowflake.connector as sc

for logger_name in ['snowflake.sqlalchemy', 'snowflake.connector', 'botocore']:
    logger = logging.getLogger(logger_name)
    logger.setLevel(logging.DEBUG)
    ch = logging.StreamHandler()
    ch.setLevel(logging.DEBUG)
    ch.setFormatter(logging.Formatter('%(asctime)s - %(threadName)s %(filename)s:%(lineno)d - %(funcName)s() - %(levelname)s - %(message)s'))
    logger.addHandler(ch)

proxy = "https://proxyuser:pass@proxy.example.com:443"


os.environ["HTTPS_PROXY"] = proxy


req = requests.get("https://ifconfig.me")

print(req.text)
assert requests.get("https://ifconfig.me").text == "213.112.22.208", "Proxy not working as expected"


key = """-----BEGIN PRIVATE KEY-----
MIIEvwIBADANBgkqhkiG9w
....
rDiz+BK8VYtMAaujPNMbQ==
-----END PRIVATE KEY-----
"""

private_key = serialization.load_pem_private_key(
    key.encode(), password=None, backend=default_backend()
)
private_key = private_key.private_bytes(
    encoding=serialization.Encoding.DER,
    format=serialization.PrivateFormat.PKCS8,
    encryption_algorithm=serialization.NoEncryption(),
)
args = {
    "private_key": private_key,
    "login_timeout": 1,
}

conn = sc.connect(
    account="FUNNEL-CUSTOM_TEST_ACCOUNT",
    user="ERIK_DB_USER",
    **args,
)

What did you expect to see?

A successful connection to snowflake

Can you set logging to DEBUG and collect the logs?

Click to expand
2025-06-12 10:21:32,128 - MainThread config_manager.py:344 - read_config() - DEBUG - reading configuration file from /Users/lilja/Library/Application Support/snowflake/config.toml
2025-06-12 10:21:32,129 - MainThread connection.py:486 - __init__() - INFO - Snowflake Connector for Python Version: 3.15.0, Python Version: 3.13.3, Platform: macOS-15.5-arm64-arm-64bit-Mach-O
2025-06-12 10:21:32,130 - MainThread connection.py:860 - connect() - DEBUG - connect
2025-06-12 10:21:32,130 - MainThread connection.py:1308 - __config() - DEBUG - __config
2025-06-12 10:21:32,130 - MainThread connection.py:1391 - __config() - INFO - Connecting to GLOBAL Snowflake domain
2025-06-12 10:21:32,130 - MainThread connection.py:1508 - __config() - DEBUG - This connection is in OCSP Fail Open Mode. TLS Certificates would be checked for validity and revocation status. Any other Certificate Revocation related exceptions or OCSP Responder failures would be disregarded in favor of connectivity.
2025-06-12 10:21:32,130 - MainThread converter.py:155 - __init__() - DEBUG - use_numpy: False
2025-06-12 10:21:32,130 - MainThread connection.py:1072 - __open_connection() - DEBUG - REST API object was created: FUNNEL-CUSTOM_TEST_ACCOUNT.snowflakecomputing.com:443
2025-06-12 10:21:32,194 - MainThread keypair.py:181 - calculate_public_key_fingerprint() - DEBUG - Public key fingerprint is SHA256:E9I6/YKvIiHEDP+bJmu4j4PI+6uNrs98Gx/6kaLYJ/4=
2025-06-12 10:21:32,197 - MainThread _auth.py:144 - authenticate() - DEBUG - authenticate
2025-06-12 10:21:32,197 - MainThread _auth.py:184 - authenticate() - DEBUG - account=FUNNEL-CUSTOM_TEST_ACCOUNT, user=ERIK_DB_USER, database=None, schema=None, warehouse=None, role=None, request_id=eae373f1-9abe-4daf-b10d-634627998b7c
2025-06-12 10:21:32,197 - MainThread _auth.py:217 - authenticate() - DEBUG - body['data']: {'CLIENT_APP_ID': 'PythonConnector', 'CLIENT_APP_VERSION': '3.15.0', 'SVN_REVISION': None, 'ACCOUNT_NAME': 'FUNNEL-CUSTOM_TEST_ACCOUNT', 'LOGIN_NAME': 'ERIK_DB_USER', 'CLIENT_ENVIRONMENT': {'APPLICATION': 'PythonConnector', 'OS': 'Darwin', 'OS_VERSION': 'macOS-15.5-arm64-arm-64bit-Mach-O', 'PYTHON_VERSION': '3.13.3', 'PYTHON_RUNTIME': 'CPython', 'PYTHON_COMPILER': 'Clang 16.0.0 (clang-1600.0.26.6)', 'OCSP_MODE': 'FAIL_OPEN', 'TRACING': 10, 'LOGIN_TIMEOUT': 1, 'NETWORK_TIMEOUT': None, 'SOCKET_TIMEOUT': None}, 'AUTHENTICATOR': 'SNOWFLAKE_JWT', 'TOKEN': '******', 'SESSION_PARAMETERS': {'CLIENT_PREFETCH_THREADS': 4}}
2025-06-12 10:21:32,197 - MainThread retry.py:351 - from_int() - DEBUG - Converted retries value: 1 -> Retry(total=1, connect=None, read=None, redirect=None, status=None)
2025-06-12 10:21:32,197 - MainThread retry.py:351 - from_int() - DEBUG - Converted retries value: 1 -> Retry(total=1, connect=None, read=None, redirect=None, status=None)
2025-06-12 10:21:32,197 - MainThread network.py:1232 - _use_requests_session() - DEBUG - Session status for SessionPool 'funnel-custom_test_account.snowflakecomputing.com', SessionPool 1/1 active sessions
2025-06-12 10:21:32,197 - MainThread network.py:906 - _request_exec_wrapper() - DEBUG - remaining request timeout: N/A ms, retry cnt: 1
2025-06-12 10:21:32,197 - MainThread network.py:888 - add_request_guid() - DEBUG - Request guid: 550574e3-5d80-4933-b773-c74a1ee5f187
2025-06-12 10:21:32,197 - MainThread network.py:1078 - _request_exec() - DEBUG - socket timeout: 10
2025-06-12 10:21:32,198 - MainThread connectionpool.py:1019 - _new_conn() - DEBUG - Starting new HTTPS connection (1): funnel-custom_test_account.snowflakecomputing.com:443
2025-06-12 10:21:32,223 - MainThread ssl_wrap_socket.py:75 - ssl_wrap_socket_with_ocsp() - DEBUG - OCSP Mode: FAIL_OPEN, OCSP response cache file name: None
2025-06-12 10:21:32,253 - MainThread ocsp_snowflake.py:647 - reset_cache_dir() - DEBUG - cache directory: /Users/lilja/Library/Caches/Snowflake
2025-06-12 10:21:32,253 - MainThread ocsp_snowflake.py:685 - reset_ocsp_response_cache_uri() - DEBUG - ocsp_response_cache_uri: file:///Users/lilja/Library/Caches/Snowflake/ocsp_response_cache.json
2025-06-12 10:21:32,253 - MainThread ocsp_snowflake.py:688 - reset_ocsp_response_cache_uri() - DEBUG - OCSP_VALIDATION_CACHE size: 0
2025-06-12 10:21:32,253 - MainThread ocsp_snowflake.py:484 - reset_ocsp_dynamic_cache_server_url() - DEBUG - OCSP response cache server is enabled: http://ocsp.snowflakecomputing.io/ocsp_response_cache.json
2025-06-12 10:21:32,253 - MainThread ocsp_snowflake.py:497 - reset_ocsp_dynamic_cache_server_url() - DEBUG - OCSP dynamic cache server RETRY URL: None
2025-06-12 10:21:32,257 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2026-07-22 00:00:00+00:00
2025-06-12 10:21:32,258 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2026-07-22 00:00:00+00:00
2025-06-12 10:21:32,260 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:30+00:00
2025-06-12 10:21:32,260 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:25+00:00
2025-06-12 10:21:32,261 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:31+00:00
2025-06-12 10:21:32,261 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:33+00:00
2025-06-12 10:21:32,262 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:33+00:00
2025-06-12 10:21:32,262 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:31+00:00
2025-06-12 10:21:32,262 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:31+00:00
2025-06-12 10:21:32,263 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:33+00:00
2025-06-12 10:21:32,263 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:33+00:00
2025-06-12 10:21:32,264 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:33+00:00
2025-06-12 10:21:32,264 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:33+00:00
2025-06-12 10:21:32,265 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:25+00:00
2025-06-12 10:21:32,265 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:31+00:00
2025-06-12 10:21:32,266 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:30+00:00
2025-06-12 10:21:32,266 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:26+00:00
2025-06-12 10:21:32,266 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:30+00:00
2025-06-12 10:21:32,267 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:28+00:00
2025-06-12 10:21:32,267 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:31+00:00
2025-06-12 10:21:32,268 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:30+00:00
2025-06-12 10:21:32,268 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:31+00:00
2025-06-12 10:21:32,269 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:25+00:00
2025-06-12 10:21:32,269 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:30+00:00
2025-06-12 10:21:32,270 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:31+00:00
2025-06-12 10:21:32,270 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:26+00:00
2025-06-12 10:21:32,270 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:26+00:00
2025-06-12 10:21:32,271 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:30+00:00
2025-06-12 10:21:32,271 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:25+00:00
2025-06-12 10:21:32,272 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:30+00:00
2025-06-12 10:21:32,273 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:31+00:00
2025-06-12 10:21:32,273 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:33+00:00
2025-06-12 10:21:32,274 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-07 15:50:21+00:00
2025-06-12 10:21:32,274 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:30+00:00
2025-06-12 10:21:32,275 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:31+00:00
2025-06-12 10:21:32,275 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:33+00:00
2025-06-12 10:21:32,276 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:33+00:00
2025-06-12 10:21:32,276 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:30+00:00
2025-06-12 10:21:32,276 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:30+00:00
2025-06-12 10:21:32,277 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:30+00:00
2025-06-12 10:21:32,277 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:25+00:00
2025-06-12 10:21:32,278 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:26+00:00
2025-06-12 10:21:32,278 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:28+00:00
2025-06-12 10:21:32,279 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:28+00:00
2025-06-12 10:21:32,279 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:29+00:00
2025-06-12 10:21:32,279 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:25+00:00
2025-06-12 10:21:32,280 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:25+00:00
2025-06-12 10:21:32,280 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:29+00:00
2025-06-12 10:21:32,281 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:26+00:00
2025-06-12 10:21:32,281 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:25+00:00
2025-06-12 10:21:32,282 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:29+00:00
2025-06-12 10:21:32,282 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:25+00:00
2025-06-12 10:21:32,282 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:25+00:00
2025-06-12 10:21:32,283 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:28+00:00
2025-06-12 10:21:32,283 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:25+00:00
2025-06-12 10:21:32,284 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:26+00:00
2025-06-12 10:21:32,284 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:26+00:00
2025-06-12 10:21:32,285 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:26+00:00
2025-06-12 10:21:32,285 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:25+00:00
2025-06-12 10:21:32,285 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:29+00:00
2025-06-12 10:21:32,286 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:25+00:00
2025-06-12 10:21:32,286 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:26+00:00
2025-06-12 10:21:32,287 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:26+00:00
2025-06-12 10:21:32,287 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:26+00:00
2025-06-12 10:21:32,288 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:28+00:00
2025-06-12 10:21:32,288 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:25+00:00
2025-06-12 10:21:32,289 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:29+00:00
2025-06-12 10:21:32,289 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:26+00:00
2025-06-12 10:21:32,289 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:26+00:00
2025-06-12 10:21:32,290 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:28+00:00
2025-06-12 10:21:32,290 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:25+00:00
2025-06-12 10:21:32,291 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:30+00:00
2025-06-12 10:21:32,291 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:25+00:00
2025-06-12 10:21:32,292 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:26+00:00
2025-06-12 10:21:32,292 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:28+00:00
2025-06-12 10:21:32,292 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:26+00:00
2025-06-12 10:21:32,293 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:26+00:00
2025-06-12 10:21:32,293 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:26+00:00
2025-06-12 10:21:32,294 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:26+00:00
2025-06-12 10:21:32,294 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:29+00:00
2025-06-12 10:21:32,295 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:26+00:00
2025-06-12 10:21:32,295 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:28+00:00
2025-06-12 10:21:32,295 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:25+00:00
2025-06-12 10:21:32,296 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:26+00:00
2025-06-12 10:21:32,296 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:26+00:00
2025-06-12 10:21:32,297 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:26+00:00
2025-06-12 10:21:32,297 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:25+00:00
2025-06-12 10:21:32,298 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:25+00:00
2025-06-12 10:21:32,298 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:26+00:00
2025-06-12 10:21:32,298 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:25+00:00
2025-06-12 10:21:32,299 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:25+00:00
2025-06-12 10:21:32,299 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:26+00:00
2025-06-12 10:21:32,300 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:26+00:00
2025-06-12 10:21:32,300 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:29+00:00
2025-06-12 10:21:32,301 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:26+00:00
2025-06-12 10:21:32,301 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:25+00:00
2025-06-12 10:21:32,301 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:26+00:00
2025-06-12 10:21:32,302 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:29+00:00
2025-06-12 10:21:32,302 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:26+00:00
2025-06-12 10:21:32,303 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:26+00:00
2025-06-12 10:21:32,303 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:25+00:00
2025-06-12 10:21:32,304 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:26+00:00
2025-06-12 10:21:32,304 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:26+00:00
2025-06-12 10:21:32,304 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:25+00:00
2025-06-12 10:21:32,305 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:28+00:00
2025-06-12 10:21:32,305 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:26+00:00
2025-06-12 10:21:32,306 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:25+00:00
2025-06-12 10:21:32,306 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:26+00:00
2025-06-12 10:21:32,307 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:26+00:00
2025-06-12 10:21:32,307 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:25+00:00
2025-06-12 10:21:32,308 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:31+00:00
2025-06-12 10:21:32,308 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:30+00:00
2025-06-12 10:21:32,308 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:30+00:00
2025-06-12 10:21:32,309 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:30+00:00
2025-06-12 10:21:32,309 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:31+00:00
2025-06-12 10:21:32,310 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:30+00:00
2025-06-12 10:21:32,310 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:30+00:00
2025-06-12 10:21:32,311 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:30+00:00
2025-06-12 10:21:32,311 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:31+00:00
2025-06-12 10:21:32,311 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:31+00:00
2025-06-12 10:21:32,312 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:31+00:00
2025-06-12 10:21:32,312 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:30+00:00
2025-06-12 10:21:32,313 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:33+00:00
2025-06-12 10:21:32,313 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:30+00:00
2025-06-12 10:21:32,314 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:31+00:00
2025-06-12 10:21:32,314 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:30+00:00
2025-06-12 10:21:32,314 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:33+00:00
2025-06-12 10:21:32,315 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:31+00:00
2025-06-12 10:21:32,315 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:30+00:00
2025-06-12 10:21:32,316 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:30+00:00
2025-06-12 10:21:32,316 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:31+00:00
2025-06-12 10:21:32,317 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:31+00:00
2025-06-12 10:21:32,317 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:33+00:00
2025-06-12 10:21:32,317 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:31+00:00
2025-06-12 10:21:32,318 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:31+00:00
2025-06-12 10:21:32,318 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:30+00:00
2025-06-12 10:21:32,319 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:33+00:00
2025-06-12 10:21:32,319 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:31+00:00
2025-06-12 10:21:32,320 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:31+00:00
2025-06-12 10:21:32,320 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:33+00:00
2025-06-12 10:21:32,321 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:31+00:00
2025-06-12 10:21:32,321 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:31+00:00
2025-06-12 10:21:32,322 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:31+00:00
2025-06-12 10:21:32,322 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:26+00:00
2025-06-12 10:21:32,322 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:30+00:00
2025-06-12 10:21:32,323 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:30+00:00
2025-06-12 10:21:32,323 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:30+00:00
2025-06-12 10:21:32,324 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:33+00:00
2025-06-12 10:21:32,324 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:30+00:00
2025-06-12 10:21:32,325 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2026-07-22 00:00:00+00:00
2025-06-12 10:21:32,332 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2026-07-22 00:00:00+00:00
2025-06-12 10:21:32,340 - MainThread ocsp_asn1crypto.py:238 - is_valid_time() - DEBUG - Failed to validate ocsp response 254013: 254013: Response is unreliable. Its validity date is out of range: current_time=2025-06-12 08:21:32Z, this_update=2025-06-04 22:39:01Z, next_update=2025-06-11 21:39:01Z, tolerable next_update=2025-06-11 23:19:13Z. A potential cause is client clock is skewed, CA fails to update OCSP response in time.
2025-06-12 10:21:32,345 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:26+00:00
2025-06-12 10:21:32,345 - MainThread ocsp_asn1crypto.py:205 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-07-09 15:50:33+00:00
2025-06-12 10:21:32,346 - MainThread ocsp_snowflake.py:728 - read_ocsp_response_cache_file() - DEBUG - Read OCSP response cache file: /Users/lilja/Library/Caches/Snowflake/ocsp_response_cache.json, count=394
2025-06-12 10:21:32,346 - MainThread ocsp_snowflake.py:1126 - validate() - DEBUG - validating certificate: proxy.example.com
2025-06-12 10:21:32,346 - MainThread ocsp_snowflake.py:1132 - validate() - DEBUG - skipping OCSP check: proxy.example.com
2025-06-12 10:21:32,451 - MainThread network.py:1184 - _request_exec() - DEBUG - Hit a timeout error while logging in. Will be handled by authenticator. Ignore the following. Error stack: TLS in TLS requires SSLContext.wrap_bio() which isn't available on non-native SSLContext
Traceback (most recent call last):
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/network.py", line 1091, in _request_exec
    raw_ret = session.request(
        method=method,
    ...<6 lines>...
        auth=SnowflakeAuth(token),
    )
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/vendored/requests/sessions.py", line 589, in request
    resp = self.send(prep, **send_kwargs)
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/vendored/requests/sessions.py", line 703, in send
    r = adapter.send(request, **kwargs)
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/vendored/requests/adapters.py", line 485, in send
    resp = conn.urlopen(
        method=request.method,
    ...<9 lines>...
        chunked=chunked,
    )
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/vendored/urllib3/connectionpool.py", line 712, in urlopen
    self._prepare_proxy(conn)
    ~~~~~~~~~~~~~~~~~~~^^^^^^
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/vendored/urllib3/connectionpool.py", line 1012, in _prepare_proxy
    conn.connect()
    ~~~~~~~~~~~~^^
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/vendored/urllib3/connection.py", line 419, in connect
    self.sock = ssl_wrap_socket(
                ~~~~~~~~~~~~~~~^
        sock=conn,
        ^^^^^^^^^^
    ...<8 lines>...
        tls_in_tls=tls_in_tls,
        ^^^^^^^^^^^^^^^^^^^^^^
    )
    ^
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/ssl_wrap_socket.py", line 73, in ssl_wrap_socket_with_ocsp
    ret = ssl_.ssl_wrap_socket(*args, **kwargs)
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/vendored/urllib3/util/ssl_.py", line 449, in ssl_wrap_socket
    ssl_sock = _ssl_wrap_socket_impl(
        sock, context, tls_in_tls, server_hostname=server_hostname
    )
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/vendored/urllib3/util/ssl_.py", line 489, in _ssl_wrap_socket_impl
    SSLTransport._validate_ssl_context_for_tls_in_tls(ssl_context)
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/vendored/urllib3/util/ssltransport.py", line 39, in _validate_ssl_context_for_tls_in_tls
    raise ProxySchemeUnsupported(
    ...<2 lines>...
    )
snowflake.connector.vendored.urllib3.exceptions.ProxySchemeUnsupported: TLS in TLS requires SSLContext.wrap_bio() which isn't available on non-native SSLContext
2025-06-12 10:21:32,453 - MainThread network.py:1237 - _use_requests_session() - DEBUG - Session status for SessionPool 'funnel-custom_test_account.snowflakecomputing.com', SessionPool 0/1 active sessions
2025-06-12 10:21:32,453 - MainThread connection.py:1662 - _authenticate() - DEBUG - Operational Error raised at authenticationfor authenticator: AuthByKeyPair
2025-06-12 10:21:32,453 - MainThread keypair.py:205 - handle_timeout() - DEBUG - Invoking base timeout handler
2025-06-12 10:21:32,453 - MainThread by_plugin.py:204 - handle_timeout() - DEBUG - Default timeout handler invoked for authenticator
2025-06-12 10:21:32,453 - MainThread by_plugin.py:213 - handle_timeout() - DEBUG - Hit connection timeout, attempt number 1. Will retry in a bit...
2025-06-12 10:21:33,458 - MainThread time_util.py:158 - increment() - DEBUG - Update retry count to 1
2025-06-12 10:21:33,458 - MainThread time_util.py:159 - increment() - DEBUG - Update sleep time to 2 seconds
2025-06-12 10:21:33,458 - MainThread keypair.py:215 - handle_timeout() - DEBUG - Base timeout handler passed, preparing new token before retrying
2025-06-12 10:21:33,529 - MainThread keypair.py:181 - calculate_public_key_fingerprint() - DEBUG - Public key fingerprint is SHA256:E9I6/YKvIiHEDP+bJmu4j4PI+6uNrs98Gx/6kaLYJ/4=
2025-06-12 10:21:33,531 - MainThread _auth.py:144 - authenticate() - DEBUG - authenticate
2025-06-12 10:21:33,531 - MainThread _auth.py:184 - authenticate() - DEBUG - account=FUNNEL-CUSTOM_TEST_ACCOUNT, user=ERIK_DB_USER, database=None, schema=None, warehouse=None, role=None, request_id=50ab8eae-118d-4e87-9af4-54b32d75644b
2025-06-12 10:21:33,531 - MainThread _auth.py:217 - authenticate() - DEBUG - body['data']: {'CLIENT_APP_ID': 'PythonConnector', 'CLIENT_APP_VERSION': '3.15.0', 'SVN_REVISION': None, 'ACCOUNT_NAME': 'FUNNEL-CUSTOM_TEST_ACCOUNT', 'LOGIN_NAME': 'ERIK_DB_USER', 'CLIENT_ENVIRONMENT': {'APPLICATION': 'PythonConnector', 'OS': 'Darwin', 'OS_VERSION': 'macOS-15.5-arm64-arm-64bit-Mach-O', 'PYTHON_VERSION': '3.13.3', 'PYTHON_RUNTIME': 'CPython', 'PYTHON_COMPILER': 'Clang 16.0.0 (clang-1600.0.26.6)', 'OCSP_MODE': 'FAIL_OPEN', 'TRACING': 10, 'LOGIN_TIMEOUT': 1, 'NETWORK_TIMEOUT': None, 'SOCKET_TIMEOUT': None}, 'AUTHENTICATOR': 'SNOWFLAKE_JWT', 'TOKEN': '******', 'SESSION_PARAMETERS': {'CLIENT_PREFETCH_THREADS': 4}}
2025-06-12 10:21:33,532 - MainThread network.py:1232 - _use_requests_session() - DEBUG - Session status for SessionPool 'funnel-custom_test_account.snowflakecomputing.com', SessionPool 1/1 active sessions
2025-06-12 10:21:33,532 - MainThread network.py:906 - _request_exec_wrapper() - DEBUG - remaining request timeout: N/A ms, retry cnt: 1
2025-06-12 10:21:33,532 - MainThread network.py:888 - add_request_guid() - DEBUG - Request guid: 395af7fd-fc51-40f1-9055-ea8ff03aa71b
2025-06-12 10:21:33,532 - MainThread network.py:1078 - _request_exec() - DEBUG - socket timeout: 10
2025-06-12 10:21:33,532 - MainThread connectionpool.py:1019 - _new_conn() - DEBUG - Starting new HTTPS connection (2): funnel-custom_test_account.snowflakecomputing.com:443
2025-06-12 10:21:33,556 - MainThread ssl_wrap_socket.py:75 - ssl_wrap_socket_with_ocsp() - DEBUG - OCSP Mode: FAIL_OPEN, OCSP response cache file name: None
2025-06-12 10:21:33,556 - MainThread ocsp_snowflake.py:685 - reset_ocsp_response_cache_uri() - DEBUG - ocsp_response_cache_uri: file:///Users/lilja/Library/Caches/Snowflake/ocsp_response_cache.json
2025-06-12 10:21:33,556 - MainThread ocsp_snowflake.py:688 - reset_ocsp_response_cache_uri() - DEBUG - OCSP_VALIDATION_CACHE size: 394
2025-06-12 10:21:33,556 - MainThread ocsp_snowflake.py:484 - reset_ocsp_dynamic_cache_server_url() - DEBUG - OCSP response cache server is enabled: http://ocsp.snowflakecomputing.io/ocsp_response_cache.json
2025-06-12 10:21:33,556 - MainThread ocsp_snowflake.py:497 - reset_ocsp_dynamic_cache_server_url() - DEBUG - OCSP dynamic cache server RETRY URL: None
2025-06-12 10:21:33,556 - MainThread ocsp_snowflake.py:1126 - validate() - DEBUG - validating certificate: proxy.example.com
2025-06-12 10:21:33,556 - MainThread ocsp_snowflake.py:1132 - validate() - DEBUG - skipping OCSP check: proxy.example.com
2025-06-12 10:21:33,654 - MainThread network.py:1184 - _request_exec() - DEBUG - Hit a timeout error while logging in. Will be handled by authenticator. Ignore the following. Error stack: TLS in TLS requires SSLContext.wrap_bio() which isn't available on non-native SSLContext
Traceback (most recent call last):
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/network.py", line 1091, in _request_exec
    raw_ret = session.request(
        method=method,
    ...<6 lines>...
        auth=SnowflakeAuth(token),
    )
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/vendored/requests/sessions.py", line 589, in request
    resp = self.send(prep, **send_kwargs)
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/vendored/requests/sessions.py", line 703, in send
    r = adapter.send(request, **kwargs)
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/vendored/requests/adapters.py", line 485, in send
    resp = conn.urlopen(
        method=request.method,
    ...<9 lines>...
        chunked=chunked,
    )
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/vendored/urllib3/connectionpool.py", line 712, in urlopen
    self._prepare_proxy(conn)
    ~~~~~~~~~~~~~~~~~~~^^^^^^
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/vendored/urllib3/connectionpool.py", line 1012, in _prepare_proxy
    conn.connect()
    ~~~~~~~~~~~~^^
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/vendored/urllib3/connection.py", line 419, in connect
    self.sock = ssl_wrap_socket(
                ~~~~~~~~~~~~~~~^
        sock=conn,
        ^^^^^^^^^^
    ...<8 lines>...
        tls_in_tls=tls_in_tls,
        ^^^^^^^^^^^^^^^^^^^^^^
    )
    ^
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/ssl_wrap_socket.py", line 73, in ssl_wrap_socket_with_ocsp
    ret = ssl_.ssl_wrap_socket(*args, **kwargs)
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/vendored/urllib3/util/ssl_.py", line 449, in ssl_wrap_socket
    ssl_sock = _ssl_wrap_socket_impl(
        sock, context, tls_in_tls, server_hostname=server_hostname
    )
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/vendored/urllib3/util/ssl_.py", line 489, in _ssl_wrap_socket_impl
    SSLTransport._validate_ssl_context_for_tls_in_tls(ssl_context)
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/vendored/urllib3/util/ssltransport.py", line 39, in _validate_ssl_context_for_tls_in_tls
    raise ProxySchemeUnsupported(
    ...<2 lines>...
    )
snowflake.connector.vendored.urllib3.exceptions.ProxySchemeUnsupported: TLS in TLS requires SSLContext.wrap_bio() which isn't available on non-native SSLContext

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/connection.py", line 1647, in _authenticate
    auth.authenticate(
    ~~~~~~~~~~~~~~~~~^
        auth_instance=auth_instance,
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
    ...<10 lines>...
        session_parameters=self._session_parameters,
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
    )
    ^
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/auth/_auth.py", line 226, in authenticate
    ret = self._rest._post_request(
        url,
    ...<2 lines>...
        socket_timeout=auth_instance._socket_timeout,
    )
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/network.py", line 759, in _post_request
    ret = self.fetch(
        "post",
    ...<7 lines>...
        socket_timeout=socket_timeout,
    )
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/network.py", line 874, in fetch
    ret = self._request_exec_wrapper(
        session, method, full_url, headers, data, retry_ctx, **kwargs
    )
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/network.py", line 1002, in _request_exec_wrapper
    raise e
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/network.py", line 924, in _request_exec_wrapper
    return_object = self._request_exec(
        session=session,
    ...<6 lines>...
        **kwargs,
    )
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/network.py", line 1189, in _request_exec
    raise OperationalError(
    ...<2 lines>...
    )
snowflake.connector.errors.OperationalError: 251011: 251011: ConnectionTimeout occurred during login. Will be handled by authenticator

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/network.py", line 1091, in _request_exec
    raw_ret = session.request(
        method=method,
    ...<6 lines>...
        auth=SnowflakeAuth(token),
    )
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/vendored/requests/sessions.py", line 589, in request
    resp = self.send(prep, **send_kwargs)
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/vendored/requests/sessions.py", line 703, in send
    r = adapter.send(request, **kwargs)
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/vendored/requests/adapters.py", line 485, in send
    resp = conn.urlopen(
        method=request.method,
    ...<9 lines>...
        chunked=chunked,
    )
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/vendored/urllib3/connectionpool.py", line 712, in urlopen
    self._prepare_proxy(conn)
    ~~~~~~~~~~~~~~~~~~~^^^^^^
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/vendored/urllib3/connectionpool.py", line 1012, in _prepare_proxy
    conn.connect()
    ~~~~~~~~~~~~^^
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/vendored/urllib3/connection.py", line 419, in connect
    self.sock = ssl_wrap_socket(
                ~~~~~~~~~~~~~~~^
        sock=conn,
        ^^^^^^^^^^
    ...<8 lines>...
        tls_in_tls=tls_in_tls,
        ^^^^^^^^^^^^^^^^^^^^^^
    )
    ^
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/ssl_wrap_socket.py", line 73, in ssl_wrap_socket_with_ocsp
    ret = ssl_.ssl_wrap_socket(*args, **kwargs)
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/vendored/urllib3/util/ssl_.py", line 449, in ssl_wrap_socket
    ssl_sock = _ssl_wrap_socket_impl(
        sock, context, tls_in_tls, server_hostname=server_hostname
    )
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/vendored/urllib3/util/ssl_.py", line 489, in _ssl_wrap_socket_impl
    SSLTransport._validate_ssl_context_for_tls_in_tls(ssl_context)
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/vendored/urllib3/util/ssltransport.py", line 39, in _validate_ssl_context_for_tls_in_tls
    raise ProxySchemeUnsupported(
    ...<2 lines>...
    )
snowflake.connector.vendored.urllib3.exceptions.ProxySchemeUnsupported: TLS in TLS requires SSLContext.wrap_bio() which isn't available on non-native SSLContext
2025-06-12 10:21:33,657 - MainThread network.py:1237 - _use_requests_session() - DEBUG - Session status for SessionPool 'funnel-custom_test_account.snowflakecomputing.com', SessionPool 0/1 active sessions
2025-06-12 10:21:33,657 - MainThread connection.py:1694 - _authenticate() - DEBUG - Continuing authenticator specific timeout handling
2025-06-12 10:21:33,658 - MainThread keypair.py:205 - handle_timeout() - DEBUG - Invoking base timeout handler
2025-06-12 10:21:33,658 - MainThread by_plugin.py:204 - handle_timeout() - DEBUG - Default timeout handler invoked for authenticator
213.112.22.208
Traceback (most recent call last):
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/network.py", line 1091, in _request_exec
    raw_ret = session.request(
        method=method,
    ...<6 lines>...
        auth=SnowflakeAuth(token),
    )
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/vendored/requests/sessions.py", line 589, in request
    resp = self.send(prep, **send_kwargs)
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/vendored/requests/sessions.py", line 703, in send
    r = adapter.send(request, **kwargs)
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/vendored/requests/adapters.py", line 485, in send
    resp = conn.urlopen(
        method=request.method,
    ...<9 lines>...
        chunked=chunked,
    )
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/vendored/urllib3/connectionpool.py", line 712, in urlopen
    self._prepare_proxy(conn)
    ~~~~~~~~~~~~~~~~~~~^^^^^^
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/vendored/urllib3/connectionpool.py", line 1012, in _prepare_proxy
    conn.connect()
    ~~~~~~~~~~~~^^
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/vendored/urllib3/connection.py", line 419, in connect
    self.sock = ssl_wrap_socket(
                ~~~~~~~~~~~~~~~^
        sock=conn,
        ^^^^^^^^^^
    ...<8 lines>...
        tls_in_tls=tls_in_tls,
        ^^^^^^^^^^^^^^^^^^^^^^
    )
    ^
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/ssl_wrap_socket.py", line 73, in ssl_wrap_socket_with_ocsp
    ret = ssl_.ssl_wrap_socket(*args, **kwargs)
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/vendored/urllib3/util/ssl_.py", line 449, in ssl_wrap_socket
    ssl_sock = _ssl_wrap_socket_impl(
        sock, context, tls_in_tls, server_hostname=server_hostname
    )
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/vendored/urllib3/util/ssl_.py", line 489, in _ssl_wrap_socket_impl
    SSLTransport._validate_ssl_context_for_tls_in_tls(ssl_context)
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/vendored/urllib3/util/ssltransport.py", line 39, in _validate_ssl_context_for_tls_in_tls
    raise ProxySchemeUnsupported(
    ...<2 lines>...
    )
snowflake.connector.vendored.urllib3.exceptions.ProxySchemeUnsupported: TLS in TLS requires SSLContext.wrap_bio() which isn't available on non-native SSLContext

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/connection.py", line 1647, in _authenticate
    auth.authenticate(
    ~~~~~~~~~~~~~~~~~^
        auth_instance=auth_instance,
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
    ...<10 lines>...
        session_parameters=self._session_parameters,
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
    )
    ^
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/auth/_auth.py", line 226, in authenticate
    ret = self._rest._post_request(
        url,
    ...<2 lines>...
        socket_timeout=auth_instance._socket_timeout,
    )
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/network.py", line 759, in _post_request
    ret = self.fetch(
        "post",
    ...<7 lines>...
        socket_timeout=socket_timeout,
    )
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/network.py", line 874, in fetch
    ret = self._request_exec_wrapper(
        session, method, full_url, headers, data, retry_ctx, **kwargs
    )
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/network.py", line 1002, in _request_exec_wrapper
    raise e
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/network.py", line 924, in _request_exec_wrapper
    return_object = self._request_exec(
        session=session,
    ...<6 lines>...
        **kwargs,
    )
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/network.py", line 1189, in _request_exec
    raise OperationalError(
    ...<2 lines>...
    )
snowflake.connector.errors.OperationalError: 251011: 251011: ConnectionTimeout occurred during login. Will be handled by authenticator

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/Users/lilja/code/selfservice/scripts/sqlalch/script.py", line 72, in <module>
    conn = sc.connect(
        account="FUNNEL-CUSTOM_TEST_ACCOUNT",
        user="ERIK_DB_USER",
        **args,
    )
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/__init__.py", line 54, in Connect
    return SnowflakeConnection(**kwargs)
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/connection.py", line 548, in __init__
    self.connect(**kwargs)
    ~~~~~~~~~~~~^^^^^^^^^^
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/connection.py", line 901, in connect
    self.__open_connection()
    ~~~~~~~~~~~~~~~~~~~~~~^^
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/connection.py", line 1293, in __open_connection
    self.authenticate_with_retry(self.auth_class)
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/connection.py", line 1615, in authenticate_with_retry
    self._authenticate(auth_instance)
    ~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/connection.py", line 1693, in _authenticate
    raise auth_op from e
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/connection.py", line 1668, in _authenticate
    auth_instance.handle_timeout(
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~^
        authenticator=self._authenticator,
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
    ...<3 lines>...
        password=self._password,
        ^^^^^^^^^^^^^^^^^^^^^^^^
    )
    ^
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/auth/keypair.py", line 206, in handle_timeout
    super().handle_timeout(
    ~~~~~~~~~~~~~~~~~~~~~~^
        authenticator=authenticator,
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
    ...<4 lines>...
        delete_params=False,
        ^^^^^^^^^^^^^^^^^^^^
    )
    ^
  File "/Users/lilja/code/selfservice/scripts/sqlalch/venv/lib/python3.13/site-packages/snowflake/connector/auth/by_plugin.py", line 211, in handle_timeout
    raise error
snowflake.connector.errors.OperationalError: 250001: 250001: Could not connect to Snowflake backend after 2 attempt(s).Aborting

Metadata

Metadata

Labels

enhancementThe issue is a request for improvement or a new featurestatus-triage_doneInitial triage done, will be further handled by the driver team

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions