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 1nYEOC-0004SW-Si for pgsql-hackers@arkaria.postgresql.org; Sat, 26 Mar 2022 21:56:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nYEOB-0004vG-Ea for pgsql-hackers@arkaria.postgresql.org; Sat, 26 Mar 2022 21:56:03 +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 1nYEOB-0004v6-4v for pgsql-hackers@lists.postgresql.org; Sat, 26 Mar 2022 21:56:03 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nYEO9-0000H8-2M for pgsql-hackers@postgresql.org; Sat, 26 Mar 2022 21:56:02 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 22QLttGg173620; Sat, 26 Mar 2022 17:55:55 -0400 From: Tom Lane To: Tomas Vondra cc: Amit Kapila , Peter Eisentraut , "houzj.fnst@fujitsu.com" , Alvaro Herrera , Justin Pryzby , Rahila Syed , Peter Smith , pgsql-hackers , "shiy.fnst@fujitsu.com" Subject: Re: Column Filtering in Logical Replication In-reply-to: <7dbaf4d7-713f-26e8-13c7-b79ed2c0cb16@enterprisedb.com> References: <202201120041.p24wvsfcsope@alvherre.pgsql> <78b8d385-57cb-9a3f-cfe5-9f300f15eced@enterprisedb.com> <822a8e40-287c-59ff-0ea9-35eb759f4fe6@enterprisedb.com> <2b8471f9-3849-c91f-ef82-9181d4bca0a7@enterprisedb.com> <16e83ce3-8415-b732-37b2-c3329a2c13a1@enterprisedb.com> <9c0dd1f3-c1b9-9c10-eca6-35f22104434a@enterprisedb.com> <05a7a760-ba3a-fcff-d7d1-3afb47ea0f7d@enterprisedb.com> <16b01452-fe77-7b02-22c0-1711485e396e@enterprisedb.com> <4f832e27-20a4-96! 4a-fafd-edf39e0ae883@enterprisedb.com> <170549.1648330634@sss.pgh.pa.us> <7dbaf4d7-713f-26e8-13c7-b79ed2c0cb16@enterprisedb! .com> Comments: In-reply-to Tomas Vondra message dated "Sat, 26 Mar 2022 22:52:53 +0100" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <173618.1648331755.1@sss.pgh.pa.us> Date: Sat, 26 Mar 2022 17:55:55 -0400 Message-ID: <173619.1648331755@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Tomas Vondra writes: > On 3/26/22 22:37, Tom Lane wrote: >> This smells like an uninitialized-variable problem, but I've had >> no luck finding any problem under valgrind. Not sure how to progress >> from here. > I think I see the problem - there's a CREATE SUBSCRIPTION but the test > is not waiting for the tablesync to complete, so sometimes it finishes > in time and sometimes not. That'd explain the flaky behavior, and it's > just this one test that misses the sync AFAICS. Ah, that would also fit the symptoms. regards, tom lane