Re: pgsql: Efficient transaction-controlled synchronous replication. - Mailing list pgsql-committers

From Simon Riggs
Subject Re: pgsql: Efficient transaction-controlled synchronous replication.
Date
Msg-id 1299489607.1696.7933.camel@ebony
Whole thread Raw
In response to Re: pgsql: Efficient transaction-controlled synchronous replication.  (Fujii Masao <masao.fujii@gmail.com>)
List pgsql-committers
On Mon, 2011-03-07 at 17:27 +0900, Fujii Masao wrote:
> On Mon, Mar 7, 2011 at 7:51 AM, Simon Riggs <simon@2ndquadrant.com> wrote:

> And,, I found one bug ;) You seem to have wrongly removed the check
> of max_wal_senders in SyncRepWaitForLSN. This can make the
> backend wait for replication even if max_wal_senders = 0. I could produce
> this problematic situation in my machine. The attached patch fixes this problem.

There may be a bug, but that's not the fix.

I spotted that issue myself in testing. I put in a protection to stop
setting synchronous_standby_names if max_wal_senders is zero, with error
message.

Are you saying the committed version doesn't trigger that ERROR?

--
 Simon Riggs           http://www.2ndQuadrant.com/books/
 PostgreSQL Development, 24x7 Support, Training and Services



pgsql-committers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: pgsql: Document the DEFERRABLE option in SET TRANSACTION command.
Next
From: Tom Lane
Date:
Subject: pgsql: Zero out vacuum_count and related counters in pgstat_recv_tabsta