arrow-adbc: adbc_driver_postgresql.dbapi causes silent program exit on connection attempt to db

Config:

  • Windows
  • python=3.11.7
  • pandas=2.2.0
  • adbc-driver-manager=0.9.0
  • adbc-driver-postgresql=0.9.0
  • pyarrow=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)

Most upvoted comments

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.