Skip site navigation (1) Skip section navigation (2)

Re: Synchronous commit not... synchronous?

From: Peter Eisentraut <peter(at)eisentraut(dot)org>
To: Peter van Hardenberg <pvh(at)pvh(dot)ca>
Cc: "pgsql-hackers(at)postgresql(dot)org Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Synchronous commit not... synchronous?
Date: 2012-11-02 18:16:03
Message-ID: 50940DE3.5080003@eisentraut.org (view raw or flat)
Thread:
Lists: pgsql-hackers
On 10/31/12 9:39 PM, Peter van Hardenberg wrote:
> This was rather surprising - my synchronous commit was... not cancelled.
> Is this expected behaviour?
> 
> d5r5fdj6u5ieml=> begin;
> BEGIN
> d5r5fdj6u5ieml=> set synchronous_commit = 'on';
> SET
> d5r5fdj6u5ieml=> insert into data values ('baz');
> INSERT 0 1
> d5r5fdj6u5ieml=> commit;
> ^CCancel request sent
> WARNING:  canceling wait for synchronous replication due to user request
> DETAIL:  The transaction has already committed locally, but might not
> have been replicated to the standby.
> COMMIT
> d5r5fdj6u5ieml=> select * from data;
>  foo 
> -----
>  bar
>  baz
> (2 rows)

Did the inserted row also arrive at the standby?


In response to

Responses

pgsql-hackers by date

Next:From: Matthew GerberDate: 2012-11-02 18:25:33
Subject: Unresolved error 0xC0000409 on Windows Server
Previous:From: Shaun ThomasDate: 2012-11-02 17:51:21
Subject: Re: Synchronous commit not... synchronous?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group