arrow-adbc: adbc_driver_postgresql.dbapi causes silent program exit on connection attempt to db
Config:
- Windows
python=3.11.7pandas=2.2.0adbc-driver-manager=0.9.0adbc-driver-postgresql=0.9.0pyarrow=15.0.0
Program exits silently (no exceptions raised) on adbc_driver_postgresql.dbapi.connect(uri).
import adbc_driver_postgresql.dbapi
uri = (
'postgresql://' +
f'{config["USERNAME"]}:' +
f'{config["PASSWORD"]}@' +
f'{config["HOST"]}:' +
'5432/' +
f'{config["DB_NAME"]}'
)
with adbc_driver_postgresql.dbapi.connect(uri) as conn: # program exits silently here
pass
Debugging
- Validated database can be connected to with:
import sqlalchemy
uri = (
'postgresql://' +
f'{config["USERNAME"]}:' +
f'{config["PASSWORD"]}@' +
f'{config["HOST"]}:' +
'5432/' +
f'{config["DB_NAME"]}'
)
engine = sqlalchemy.create_engine(uri)
with engine.connect() as conn:
pass
About this issue
- Original URL
- State: open
- Created 3 years ago
- Comments: 34 (23 by maintainers)
Thanks for the report. Windows support is a bit difficult for me but I will spin up a VM to investigate when I get a chance.
I’m not using AWS
Ok. It turns out, I dug up an old laptop (that I was planning on donating/recycling) but it happens to still be on Windows 10. When I can find more time again I’ll give it another shot.
Unfortunately I don’t and based on my research Windows no longer supports them. I’m hoping someone else has the same issue and discovers this thread to contribute.
The only other information I can give is when I attempt the connection I get the hourglass next to the mouse indicating some sort of processing is going on for a second before the python program dies.