asyncpg

asyncpg copied to clipboard

* **asyncpg version**: 0.30.0 * **PostgreSQL version**: 16.1 * **Do you use a PostgreSQL SaaS? If so, which? Can you reproduce the issue with a local PostgreSQL install?**: No *...

eamial-pub

```py conn = await asyncpg.connect( user=os.getenv("DB_USER"), password=os.getenv("DB_USER_PASSWORD"), database=os.getenv("DB_NAME"), host=os.getenv("DB_HOST") ) # None type conn.cursor() # None type ```

deadafaccount

It seems like releasing a connection back to the pool doesn't entirely reset its state in a way that makes it brand new for the next user. Is it expected...

y4n9squared

Segmentation fault on 0.31.0 when inside a Temporal activity

4

I'm not sure if the root cause is with `asyncpg` or with `temporal` but this code works fine on `0.30.0`, and crashes on `0.31.0` in `await asyncpg.connect`. Python 3.12.9. ```py...

idevelop

Basically as the title says: Trying to connect with a DSN that contains no password does not work DSN in question: ` @property def dsn(self) -> str: return f"postgresql+asyncpg://{self.pguser}@{self.pghost}:{self.pgport}/{self.pgdatabase}" `...

andreas-esders-kopecky

Hi! I'm using asyncpg 0.30.0 with python 3.12 and faced strange behaviour of jsonb, my db row contains something like [] or [{},...,{}] and most of it is arrays contains...

aidonchuk

Handle PROTOCOL_CANCELLED (state 3) in _dispatch_result.

1

Prior to this patch the state machine did not handle results arriving after cancellation. This add explicit support for that scenario by keeping track of the state prior to cancellation...

mnbbrown

### Related To #1268 ### Under heavy load, or when max_inactive_connection_lifetime exceeds the pool’s configured connection lifetime (like after inactivity for few minutes when lifetime is set to 300), the...

mamfyou

Add pool_timeout parameter to prevent pool operation hangs (#431)

1

# Summary Adds pool_timeout parameter to Pool and create_pool() to prevent indefinite hangs in pool operations. # Problem Pool operations could hang indefinitely, particularly during connection cleanup and cancellation (issue...

ermakov-oleg

Prepared Statement connection is active and wait for ClientRead.

1

Hi team, Right now, asyncpg does prepared statements in two steps. 1. Parse, Describe, Flush. 2. Bind, Execute, Sync. Two coroutines represent these two steps. In a highly concurrent setup,...

dingxiong