-
Notifications
You must be signed in to change notification settings - Fork 516
Open
Labels
enhancementThe issue is a request for improvement or a new featureThe issue is a request for improvement or a new featurestatus-triage_doneInitial triage done, will be further handled by the driver teamInitial triage done, will be further handled by the driver team
Description
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
Assignees
Labels
enhancementThe issue is a request for improvement or a new featureThe issue is a request for improvement or a new featurestatus-triage_doneInitial triage done, will be further handled by the driver teamInitial triage done, will be further handled by the driver team