Client not able to pick up - Mailing list pgsql-admin

From Rajesh Kumar
Subject Client not able to pick up
Date
Msg-id CAJk5AtY89NpL=syZTS9vSwndLF9Si2swLyZ0n6EdP08Opy76_Q@mail.gmail.com
Whole thread Raw
Responses Re: Client not able to pick up
List pgsql-admin
Hi we use patroni 3.1 , pgbouncer, openshift 4.1 , postgres 15.6

Recently we upgraded openshift platform to 4.13 and postgres server is up and running and now we are witnessing frequent restarts (I can see timeline added in patronictl history) or whenever failover happened or whenever system automatically restarted for some reason (etcd logs says "DCS communication error", postgres log says "received fast shutdown request" for the same time), those times, fron the client side they are getting error "cannot execute update in read only transaction" and is stucked in this msg.

We have a common hostname grocerydb-primary that resolved both master and standby.

Now, I want to understand two things 1. What could be the reason for frequent restarts or shutdown and startups 2. Why client is stucked with the message " cannot execute update in read only transaction" , eventhough master is up and running.


pgsql-admin by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Urgent: Segmentation Fault in PostgreSQL postmaster Process
Next
From: "Rainer Leo"
Date:
Subject: Remote access on Windows Server