Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nDAWq-0003O2-FH for pgsql-hackers@arkaria.postgresql.org; Thu, 27 Jan 2022 19:33:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nDAWp-00037C-CJ for pgsql-hackers@arkaria.postgresql.org; Thu, 27 Jan 2022 19:33:55 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nDAWo-000370-Om for pgsql-hackers@lists.postgresql.org; Thu, 27 Jan 2022 19:33:55 +0000 Received: from mail-ed1-x52f.google.com ([2a00:1450:4864:20::52f]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nDAWk-0003AA-Iz for pgsql-hackers@lists.postgresql.org; Thu, 27 Jan 2022 19:33:54 +0000 Received: by mail-ed1-x52f.google.com with SMTP id u24so5033441eds.11 for ; Thu, 27 Jan 2022 11:33:50 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; h=message-id:date:mime-version:user-agent:subject:content-language:to :cc:references:from:in-reply-to:content-transfer-encoding; bh=pioFTsSiSIXbSiA1I7v4GouxL5f7PAPJU+dJQ1Mgtyo=; b=CFjx5uqyj5ACKLPHKWvLnNmSNwPU3MphmKNWakJVjbeBjhe77ZOtkntCAnXgPJu0NZ ZZ7ieTo0ycPdYnJV19LxGuyDsV2w1om8nykpPLVxUIP9Y7lqUroGOpLrztwHipJnM1mk Vfr/6A3BtmDa/KNXQ2JzjPFLlyY5qvXveJIY7xBb+R//k3AIYbxYtYzeplOOiS5dNPjE hg7QSgXgEqpagqrScGqQY1oXRQG8VFeR6WfMK5bZfyMnG1pB+XH0xRCYqw8eiyH8raMp 859+fdwkX3tSCtKe3Pi1JRL2Jg7oSFn3u2c1OTSTKHjtVk7jicH3VMpVI5zIFP3xh/DJ zrJA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:message-id:date:mime-version:user-agent:subject :content-language:to:cc:references:from:in-reply-to :content-transfer-encoding; bh=pioFTsSiSIXbSiA1I7v4GouxL5f7PAPJU+dJQ1Mgtyo=; b=qT5rwQzHoxtkJ+oNvkfX0ANTaUB98e9k2TogoVYbKfzdnBiLr+AIKO6q8kpKbuOYpq J62yfk8IEDNLzRgJVld7/fs2998iVQg8s9n2GBAaV8hcGoImoOpCwmVN629xyQZ+QM9w mLrBuTJg3fCa7Qa7q06fkbe3uJt/apPCZIeciWYkeTNu/sQqgy+PRgoQ/x9zR6Bi+pmH hzoZXVPRtQLJBHl2WmfrRCkDafR1Ov2YJYX/sQwMirdaGIkYB2X1rXMDOVU4xMHoC6vD UfY/qEoBJEFeVm3xDt4Xv01w+vjSM3oaQ25ZaeaiW3JfdAo4k61hobyKf7cSKo9s96/D mAUA== X-Gm-Message-State: AOAM5323mEeJxY0jWS5GamlHA4ZDN1YPfuruazc9J2LYNsoKIs9htmlw OUnA4bo0RQWPL5n/emjj1CBldXdndMbm2spPGxpRy503+cDeLyDc0CljkyTtEluEEkb7r7Tj9Qe bZogSOa01dTC+lmd2/mheFHW3BpvYxNtbYJedCWE1tELto4YDl1BAJvvxbVJuTr4DqUOgLZkpcq fZzDwo6lpDFf7/S0pJNt66Y3yi43wC6fjw23JCACDypLqVoBgBLKWICrVsS0sG X-Google-Smtp-Source: ABdhPJz53TzQgWd4ngsbXig+koehb+UTL4jtZ1ucJR5EMNV8UyRzczewmNU4bXnILvTMJ600O9xY8w== X-Received: by 2002:a05:6402:50c8:: with SMTP id h8mr5104223edb.144.1643312028640; Thu, 27 Jan 2022 11:33:48 -0800 (PST) Received: from [10.137.0.18] (static-84-42-175-93.net.upcbroadband.cz. [84.42.175.93]) by smtp.gmail.com with ESMTPSA id s19sm7565731ejn.6.2022.01.27.11.33.47 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 27 Jan 2022 11:33:47 -0800 (PST) Message-ID: <1b8b2841-a99c-75ca-10fb-73f2ed883013@enterprisedb.com> Date: Thu, 27 Jan 2022 20:33:46 +0100 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101 Thunderbird/91.3.0 Subject: Re: Bug in ProcArrayApplyRecoveryInfo for snapshots crossing 4B, breaking replicas Content-Language: en-US To: Michael Paquier Cc: "Bossart, Nathan" , PostgreSQL Hackers References: <36b8a501-5d73-277c-4972-f58a4dce088a@enterprisedb.com> <35291484-f007-52c5-18a6-80c345f5c2ed@enterprisedb.com> <90de4d28-f3a3-c71c-c458-a8deef6af410@enterprisedb.com> From: Tomas Vondra In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-CLOUD-SEC-AV-Info: enterprisedb,google_mail,monitor X-CLOUD-SEC-AV-Sent: true X-Gm-Spam: 0 X-Gm-Phishy: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 1/26/22 23:54, Michael Paquier wrote: > On Wed, Jan 26, 2022 at 07:31:00PM +0100, Tomas Vondra wrote: >> I actually tried doing that, but I was not very happy with the result. The >> test has to call pg_resetwal, but then it also has to fake pg_xact data and >> so on, which seemed a bit ugly so did not include the test in the patch. > > Indeed, the dependency to /dev/zero is not good either. The patch > logic looks good to me. OK, I've pushed the patch. We may consider adding a TAP test later, if we find a reasonably clean approach. regards -- Tomas Vondra EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company