Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 7EA551337999 for ; Mon, 7 Mar 2011 05:28:33 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 53138-06 for ; Mon, 7 Mar 2011 09:28:26 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-iw0-f174.google.com (mail-iw0-f174.google.com [209.85.214.174]) by mail.postgresql.org (Postfix) with ESMTP id E32A0133616B for ; Mon, 7 Mar 2011 05:28:25 -0400 (AST) Received: by iwn34 with SMTP id 34so3759766iwn.19 for ; Mon, 07 Mar 2011 01:28:25 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:in-reply-to:references:date :message-id:subject:from:to:cc:content-type; bh=lvk731Fwpc6kR88+Ef+BamzS5mPR9Jz7aLZ0ifY4AbU=; b=lDFNRTDAGu3u9aqrdF3R0oQZFxo/qf9Du4Xg10++nBGNblOYNaa2NrZPrPooBqtAkM jkNnHSq2HuaM4UJU3aSIIM7xf3+Q0qd0ZcxEA/KLsx9Rha7pisQT/A2U2jWnwjAKa7PQ v9H7La0NEdbD2zT4SFF8iG3xcGKE0HMhSDwtM= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; b=ff6dcNy3mtAod9l2VPcqgvIfKwu/HLp1n9T0HwaADWUWpQ3KJpOnMn8HNFm/u9AfJe 4hv9AHFZhrY60hsVbmSzOgp2KJ1Zh4d+6kzGRxF9Q6/zGiFafaaRhxraTC9qsARd5o6+ 99vn/HzB2oLkHs52bq8lTUL4zF9oNBWXkE14o= MIME-Version: 1.0 Received: by 10.42.117.194 with SMTP id u2mr4413867icq.465.1299490105733; Mon, 07 Mar 2011 01:28:25 -0800 (PST) Received: by 10.42.175.137 with HTTP; Mon, 7 Mar 2011 01:28:25 -0800 (PST) In-Reply-To: <1299489607.1696.7933.camel@ebony> References: <1299489607.1696.7933.camel@ebony> Date: Mon, 7 Mar 2011 18:28:25 +0900 Message-ID: Subject: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. From: Fujii Masao To: Simon Riggs Cc: PostgreSQL-development Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.72 tagged_above=-5 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, FS_REPLICA=3.599, RCVD_IN_DNSWL_LOW=-0.7, SARE_SPEC_REPLICA=0.72 X-Spam-Level: * X-Archive-Number: 201103/445 X-Sequence-Number: 183695 On Mon, Mar 7, 2011 at 6:20 PM, Simon Riggs wrote: > On Mon, 2011-03-07 at 17:27 +0900, Fujii Masao wrote: >> On Mon, Mar 7, 2011 at 7:51 AM, Simon Riggs 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? I changed synchronous_standby_names after startup and reloaded the configuration file. So I didn't encounter such an error message. Regards, -- Fujii Masao NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center