From: | Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com> |
---|---|
To: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Client not able to pick up |
Date: | 2024-07-02 05:57:39 |
Message-ID: | CAJk5AtY89NpL=syZTS9vSwndLF9Si2swLyZ0n6EdP08Opy76_Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Rainer Leo | 2024-07-02 06:46:24 | Remote access on Windows Server |
Previous Message | Laurenz Albe | 2024-07-01 12:40:50 | Re: Urgent: Segmentation Fault in PostgreSQL postmaster Process |