apache / apache/arrow-adbc

adbc_driver_postgresql.dbapi causes silent program exit on connection attempt to db

Open
#1,531 34 comments 0 reactions 0 assignees View on GitHub
Dominant language
C#
Stars
627
Forks
217
Avg merge
17h
Merged PRs (30d)
57

Description

**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)`.

```python
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:

```python
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
```

Contributor guide

Open the contributing guide

Research direction

Start by reproducing the silent exit at adbc_driver_postgresql.dbapi.connect(uri) with the Windows and package versions listed. Compare it with the successful sqlalchemy connection, then determine what happens during the ADBC connection attempt; done means the failure is reported rather than terminating silently.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql, python, sqlalchemy
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
30/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.