eclipse-vertx / eclipse-vertx/vertx-sql-client

postgres pgpool holds on to the previously active primary server connection

Aperta
#981 13 commenti 0 reazioni 1 assegnatario Rivendicata da @tsegismont Vedi su GitHub
bug
Lingua principale
Java
Stelle
912
Fork
214
Merge medio
3g 18h
PR unite (30g)
4

Descrizione

### Questions
we have F5 VIP for our postgres db, with gtm_monitor set which in realtime points to either the primary or secondary or DR server based on whichever is active.
using the PgPool seems to hold on to the connections to the previously active server and does not discard it.
postgres seems to be specifically returning an error code: 25006
exception message returned to app server (when connections from previous active servers are used): cannot execute INSERT in a read-only transaction
error code: 25006

can there be a method to discard connections from the pool when such error occurs? or this be handled internally?

### Version
Which version(s) did you encounter this bug ?
vertx-pg-client: 3.9.7

### Do you have a reproducer?
No

### Steps to reproduce
Note: application connects to F5 VIP created for postgres
1. primary server is ACTIVE, secondary server is on STANDBY
2. APP starts sending requests to db with connection pool size atleast 1
3. EFM is used on postgres to do the switch over for DB maintainence. This sets secondary server as ACTIVE and primary server to STANDBY.
4. App continues to send requests, and all the requests fail with error code: 25006 and message: cannot execute INSERT in a read-only transaction

Guida per i contributori

Apri la guida per i contributori

Valutazione

Questa issue non è ancora stata valutata.

Ricevi le nuove issue nella tua casella

Un breve riepilogo di issue GitHub adatte ai principianti.