be
wrote:
> On Wed, 2023-02-01 at 14:52 +0800, qihua wu wrote:
> > When run a cluster with sync replication, if DML is done on primary, but
> primary is
> > isolated from all slave, then the DML will hang, if cancel it DML, it
> will say:
> > WARNING: canceling wait
On Wed, 2023-02-01 at 14:52 +0800, qihua wu wrote:
> When run a cluster with sync replication, if DML is done on primary, but
> primary is
> isolated from all slave, then the DML will hang, if cancel it DML, it will
> say:
> WARNING: canceling wait for synchronous replicat
ote:
>
>> Hi,
>>
>> On Wed, Feb 01, 2023 at 02:52:49PM +0800, qihua wu wrote:
>> > When run a cluster with sync replication, if DML is done on primary, but
>> > primary is isolated from all slave, then the DML will hang, if cancel it
>> > DML, it will
On Wednesday, February 1, 2023, Julien Rouhaud wrote:
> Hi,
>
> On Wed, Feb 01, 2023 at 02:52:49PM +0800, qihua wu wrote:
> > When run a cluster with sync replication, if DML is done on primary, but
> > primary is isolated from all slave, then the DML will hang, if cancel it
Hi,
On Wed, Feb 01, 2023 at 02:52:49PM +0800, qihua wu wrote:
> When run a cluster with sync replication, if DML is done on primary, but
> primary is isolated from all slave, then the DML will hang, if cancel it
> DML, it will say:
> WARNING: canceling wait for synchronous replic
When run a cluster with sync replication, if DML is done on primary, but
primary is isolated from all slave, then the DML will hang, if cancel it
DML, it will say:
WARNING: canceling wait for synchronous replication due to user request
DETAIL: The transaction has already committed locally, but
e';
-[ RECORD 1 ]+--
wait_event_type | IPC
wait_event | SyncRep
state| active
On Tue, Jan 31, 2023 at 3:35 PM qihua wu wrote:
> We are using sync replication, if a session runs an insert, and then
> commit, the client is actually waiting for commit to compl
We are using sync replication, if a session runs an insert, and then
commit, the client is actually waiting for commit to complete, but looks
like this wait doesn't show in pg_stat_activity.
In one session I inserted a row (auto commit), it hangs there.
example=# insert into test_timteout s
Greetings Michael,
* Michael Paquier (michael.paqu...@gmail.com) wrote:
> On Thu, Jan 25, 2018 at 08:21:43PM -0500, Stephen Frost wrote:
> > That's correct, which is why it's encouraged to have multiple replicas
> > configured when using synchronous replication. In v10, it's possible to
> > speci
On Thu, Jan 25, 2018 at 08:21:43PM -0500, Stephen Frost wrote:
> That's correct, which is why it's encouraged to have multiple replicas
> configured when using synchronous replication. In v10, it's possible to
> specify how many synchronous replicas are required to have acknowledged
> a given tran
Greetings,
On our mailing lists, we prefer that replies be in-line and ask that
users not top-post. Please see my response, in-line, below.
* Azimuddin Mohammed (azim...@gmail.com) wrote:
> So untill my slave comes up master does not commit any transaction which
> means technically my db is non
correct.
-Original Message-
From: Azimuddin Mohammed
To: Rakesh Kumar
Cc: pgsql-admin ; pgsql-general
Sent: Thu, Jan 25, 2018 8:06 pm
Subject: Re: Sync replication
So untill my slave comes up master does not commit any transaction which means
technically my db is non operative
So untill my slave comes up master does not commit any transaction which
means technically my db is non operative?
On Jan 25, 2018 12:23 PM, "Rakesh Kumar" wrote:
>
> >I have a question regarding synchronus replication.
> >If i have a master and standby server will syn
>I have a question regarding synchronus replication.
>If i have a master and standby server will sync replication setup..when my
>slave dies and master is still active. Will the transaction completes, or
>>master will wait for slave to commit the transaction and then commits
I have a question regarding synchronus replication.
If i have a master and standby server will sync replication setup..when my
slave dies and master is still active. Will the transaction completes, or
master will wait for slave to commit the transaction and then commits its. ?
15 matches
Mail list logo
