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 1n6cX6-0007he-GK for pgsql-committers@arkaria.postgresql.org; Sun, 09 Jan 2022 18:03:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1n6cX4-0003Xk-U0 for pgsql-committers@arkaria.postgresql.org; Sun, 09 Jan 2022 18:03:06 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1n6cX4-0003WF-Ae for pgsql-committers@lists.postgresql.org; Sun, 09 Jan 2022 18:03:06 +0000 Received: from mail-pj1-x1035.google.com ([2607:f8b0:4864:20::1035]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1n6cWx-0004JO-Jr for pgsql-committers@lists.postgresql.org; Sun, 09 Jan 2022 18:03:05 +0000 Received: by mail-pj1-x1035.google.com with SMTP id y16-20020a17090a6c9000b001b13ffaa625so19733209pjj.2 for ; Sun, 09 Jan 2022 10:02:59 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20210112.gappssmtp.com; s=20210112; h=message-id:subject:from:to:cc:date:in-reply-to:references :mime-version:content-transfer-encoding; bh=pXgh1A39qyOwf9OO7SfPZWnEmhlswOrYsISXkV0zRDs=; b=W+9QGebvWmeVJ3ER3GSmOufGZMaioqT7WonwCtVNqIRZg2gbwXAV2WcdAuGzPxWHFD 2JIBg8WerUjz7qiqsHrGgoVFKwzekQsVrNhLYaQYNXsy3G5P26qtz+mYyCCzaM9EkQBz xS5DS+Jb2DloLlxAIi5J5HlJVMk7hCBHB/YzrcbtVTR8ZX7DyGctoFUPK4TEGuzFQSU/ c54cAlfCzNpj4bsdOZ4m96G9f5hncoNfrcSiQEwACBfXIXAWFDi+pdkhgDq7RvJhopVN Diuy8v4k9WHgbaeVscj6Kx40aDKYVlti/m5czKj1m+IClfZdJ/R5k1fuU+TSA9ECGgtQ 3SNQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:message-id:subject:from:to:cc:date:in-reply-to :references:mime-version:content-transfer-encoding; bh=pXgh1A39qyOwf9OO7SfPZWnEmhlswOrYsISXkV0zRDs=; b=JNFynomqz6XdLQTl9B8QVHQtuvT/4wQgQZklXWspH/RGpzbNc7HAHu8S5yvALKxoT3 5h9XQ7pg/zdHLZEocZPWZi49p9IHNbzF6cdRqfi5Qj6WHJt1OYH31rXH27uO2ykb9oSu n8g8eZTYQ4XuoTu1xc27AY9DoEBKdkyoNEEO04Tzm1jndqWDi0sOM+DyyFMAHo2PV6Kh s0voZTx8gjXA5HW5Dtw6pfnd1m2wYuqvYFa+vh0Ly6lS+3rWzeWEjiiIKXRLlGweYw4g LYjk4KxitN9fSi3pfvwT8Q2Kv04pJALN7V8iwJGIbVEGAEIB8HbIozNmkAHYCneDkrGq Tpgw== X-Gm-Message-State: AOAM530itmfq30YfbUPubHUgIhzcLBR7WghlXy3CeRl9lozn6LjaueGL w2PddWC24KVXv/ICu8QOzmDcIw== X-Google-Smtp-Source: ABdhPJwK8REEh1PKDtkMiippiCr6BjQHAJexlRC5ULjnofwFJ6fD95J4zrISixYvKm50Dm0pxjHSVA== X-Received: by 2002:a17:90b:4f82:: with SMTP id qe2mr26216710pjb.128.1641751378485; Sun, 09 Jan 2022 10:02:58 -0800 (PST) Received: from jdavis.lan (c-73-231-146-4.hsd1.ca.comcast.net. [73.231.146.4]) by smtp.gmail.com with ESMTPSA id j20sm4047148pfh.22.2022.01.09.10.02.57 (version=TLS1_2 cipher=ECDHE-ECDSA-CHACHA20-POLY1305 bits=256/256); Sun, 09 Jan 2022 10:02:57 -0800 (PST) Message-ID: Subject: Re: pgsql: Respect permissions within logical replication. From: Jeff Davis To: Amit Kapila , Michael Paquier Cc: Jeff Davis , pgsql-committers Date: Sun, 09 Jan 2022 10:02:56 -0800 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" X-Mailer: Evolution 3.28.5-0ubuntu0.18.04.2 Mime-Version: 1.0 Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sat, 2022-01-08 at 11:56 +0530, Amit Kapila wrote: > One possible reason for this failure could be that the test doesn't > wait for the initial sync to complete after CREATE SUBSCRIPTION which > can allow more than expected operations to be replicated. Also, the > reason it passes in other machines is that in those runs initial sync > could get finished before we start to publish other operations. You're right, even though the initial table is empty. I copied some code from a different test to wait for the sync, and it appears to be succeeding now. Thanks, Jeff Davis