cannot execute UPDATE in a read-only transaction

[wht1998]

(sqlalchemy.dialects.postgresql.asyncpg.Error) <class 'asyncpg.exceptions.ReadOnlySQLTransactionError'>: cannot execute UPDATE in a read-only transaction\n[SQL: UPDATE sys_session SET access_token=$1::VARCHAR, refresh_token=$2::VARCHAR, updated_at=$3::TIMESTAMP WITHOUT TIME ZONE WHERE sys_session.user_id = $4::VARCHAR]

I have another question: why are there no database query statement logs?

[levkk]

Could you share:

1. pgdog version
2. pgdog config
3. the surrounding queries that ran, e.g. was this inside a transaction, and if so, did it have READ ONLY attribute set by accident

why are there no database query statement logs?

Too expensive to have on in prod. You can enable debug/trace logging though in local, that would be cool to attach here so I can see what actually executed:

export RUST_LOG=trace