search

aiokitchen / hasql

hasql - is a library for high available PostgreSQL clusters.
Apache License 2.0
42 stars 7 forks source link

Added COMMIT after detect role of pool #15

Closed Logioniz closed 1 day ago

Logioniz commented 1 week ago

We have two problem with system connection:

  1. The age of the system transaction is growing very much image
  2. After promote replica to master the result of "SHOW transaction_read_only" command always "on" because the transaction started before the promote. Promote to master does not break transaction/connection.

I added COMMIT to solve them both.

mosquito commented 1 day ago

Released as https://pypi.org/project/hasql/0.8.0/