Empty IOException when installing JSON Extension

[mosegui]

I have seen some other similar cases of error appearing upon installation of extensions. These referred to 0.3.X or so releases and had mostly to do with extension files not being found.

I am running DuckDB 0.7.1 and Python 3.10.10 on Windows 10 in the following pipenv:

aiohttp==3.8.4
aiosignal==1.3.1
anyio==3.6.2
asttokens==2.2.1
async-timeout==4.0.2
attrs==22.2.0
backcall==0.2.0
backoff==2.2.1
certifi==2022.12.7
charset-normalizer==3.1.0
chromadb==0.3.17
click==8.1.3
clickhouse-connect==0.5.18
colorama==0.4.6
comm==0.1.3
dataclasses-json==0.5.7
debugpy==1.6.6
decorator==5.1.1
duckdb==0.7.1
executing==1.2.0
fastapi==0.95.0
filelock==3.10.7
frozenlist==1.3.3
greenlet==2.0.2
h11==0.14.0
hnswlib==0.7.0
httptools==0.5.0
huggingface-hub==0.13.3
idna==3.4
ipykernel==6.22.0
ipython==8.12.0
jedi==0.18.2
Jinja2==3.1.2
joblib==1.2.0
jupyter_client==8.1.0
jupyter_core==5.3.0
langchain==0.0.127
lz4==4.3.2
MarkupSafe==2.1.2
marshmallow==3.19.0
marshmallow-enum==1.5.1
matplotlib-inline==0.1.6
monotonic==1.6
mpmath==1.3.0
multidict==6.0.4
mypy-extensions==1.0.0
nest-asyncio==1.5.6
networkx==3.0
nltk==3.8.1
numpy==1.24.2
openai==0.27.2
packaging==23.0
pandas==1.5.3
parso==0.8.3
pickleshare==0.7.5
Pillow==9.4.0
platformdirs==3.2.0
posthog==2.4.2
prompt-toolkit==3.0.38
psutil==5.9.4
pure-eval==0.2.2
pydantic==1.10.7
Pygments==2.14.0
python-dateutil==2.8.2
python-dotenv==1.0.0
pytz==2023.3
pywin32==306
PyYAML==6.0
pyzmq==25.0.2
regex==2023.3.23
requests==2.28.2
scikit-learn==1.2.2
scipy==1.10.1
sentence-transformers==2.2.2
sentencepiece==0.1.97
six==1.16.0
sniffio==1.3.0
SQLAlchemy==1.4.47
stack-data==0.6.2
starlette==0.26.1
sympy==1.11.1
tenacity==8.2.2
threadpoolctl==3.1.0
tokenizers==0.13.2
torch==2.0.0
torchvision==0.15.1
tornado==6.2
tqdm==4.65.0
traitlets==5.9.0
transformers==4.27.4
typing-inspect==0.8.0
typing_extensions==4.5.0
urllib3==1.26.15
uvicorn==0.21.1
watchfiles==0.19.0
wcwidth==0.2.6
websockets==10.4
yarl==1.8.2
zstandard==0.20.0

Here is my simplest failing code snippet:

import duckdb

if __name__ == "__main__":
    # sys.setdlopenflags(os.RTLD_GLOBAL | os.RTLD_NOW)  # Running on Windows
    con = duckdb.connect()
    con.execute("INSTALL 'json';")

also tried downloading the file and installing manually without success:

import duckdb

if __name__ == "__main__":
    # File lies in CWD
    duckdb.install_extension("json.duckdb_extension")

both cases deliver the same error with no error message and no stack trace:

Traceback (most recent call last):
  File "c:\dev\projects\openai\debug.py", line 10, in <module>
    con.execute("INSTALL 'json';")
duckdb.IOException

thereby making it difficult to debug it further. I do not think this seems like a problem finding the installation file, not a syntax error in my DB query.

Any help would be appreciated.,

Thanks in advance,

D.