dbt-core: [CT-2292] [Bug] HTTPSConnectionPool(host='hub.getdbt.com', port=443): Max retries exceeded with url: /api/v1/index.json (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED]
Is this a new bug in dbt-core?
- I believe this is a new bug in dbt-core
- I have searched the existing issues, and I could not find an existing issue for this bug
Current Behavior
External connection exception occurred: HTTPSConnectionPool(host=‘hub.getdbt.com’, port=443): Max retries exceeded with url: /api/v1/index.json (Caused by SSLError(SSLCertVerificationError(1, ‘[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:992)’)))
Expected Behavior
Steps To Reproduce
det deps
Relevant log output
No response
Environment
- OS: Windows 10
- Python:3.11
- dbt:1.4.4
Which database adapter are you using with dbt?
No response
Additional Context
No vpn
About this issue
- Original URL
- State: closed
- Created a year ago
- Comments: 29 (14 by maintainers)
Thanks, Yes, I am also able to run dbt deps from my mac (with vpn), its from specific linux BM hosts we are getting timing out. Tried all options in the catalog, will keep posted if we figure out more on specific env
Thanks a lot @dbeatty10 🙏🏼
@HichemELB you can monitor the status here: https://status.getdbt.com/incidents/0mb25gcntq9g
Thanks for reporting this @HichemELB, we are investigating the issue currently.
Today, we are encountering the same error more frequently, 1 out of 10 jobs. We use dbt cloud, and nothing is self-hosted, even for development.
I am facing the same issue
@moseleyi two questions for you:
Windows operating system
Windows users have been able to resolve this with these instructions:
Corporate VPN
At least one corporate VPN user was able to resolve this by setting the
REQUESTS_CA_BUNDLEenvironment variable.Faced the same issue while installing package dbt-expectations with dbt 1.2.6, Windows 10 and python version 3.10.7 :
Initially tried installing pip-system-certs, but that didn’t work.
Installing python-certifi-win32 worked, cheers to @xmansch
Glad you got it to work by installing
python-certifi-win32! Presumably installingpip-system-certswould have also worked since it is a replacement forpython-certifi-win32.https://github.com/dbt-labs/dbt-core/issues/4909 has some additional context too.
What are the contents of your
packages.ymlfile? I’m curious which of the five (5) different methods you were trying to use:Also, did you try running this for a Python version other than 3.11? I’m wondering if this worked without modification in Python <= 3.10 and then stopped working in 3.11.
The last thing I’m wondering about is if this would have affected you with a different operating system like a Linux distribution or macOS or if it only affected Windows?
i resolve this issue , when install pip install python-certifi-win32 thanks