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 1nYE6B-0003Zl-4t for pgsql-hackers@arkaria.postgresql.org; Sat, 26 Mar 2022 21:37:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nYE69-0006C7-Ss for pgsql-hackers@arkaria.postgresql.org; Sat, 26 Mar 2022 21:37:25 +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 1nYE69-0006By-JU for pgsql-hackers@lists.postgresql.org; Sat, 26 Mar 2022 21:37:25 +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 1nYE67-00004w-9G for pgsql-hackers@postgresql.org; Sat, 26 Mar 2022 21:37:24 +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 22QLbEeK170550; Sat, 26 Mar 2022 17:37:15 -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: <4f832e27-20a4-964a-fafd-edf39e0ae883@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> Comments: In-reply-to Tomas Vondra message dated "Sat, 26 Mar 2022 01:18:08 +0100" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <170548.1648330634.1@sss.pgh.pa.us> Content-Transfer-Encoding: quoted-printable Date: Sat, 26 Mar 2022 17:37:14 -0400 Message-ID: <170549.1648330634@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Tomas Vondra writes: > I went over the patch again, polished the commit message a bit, and > pushed. May the buildfarm be merciful! Initial results aren't that great. komodoensis[1], petalura[2], and snapper[3] have all shown variants of # Failed test 'partitions with different replica identities not replicat= ed correctly' # at t/031_column_list.pl line 734. # got: '2|4| # 4|9|' # expected: '1||5 # 2|4| # 3||8 # 4|9|' # Looks like you failed 1 test of 34. [18:19:36] t/031_column_list.pl ............... = Dubious, test returned 1 (wstat 256, 0x100) Failed 1/34 subtests = snapper reported different actual output than the other two: # got: '1||5 # 3||8' The failure seems intermittent, as both komodoensis and petalura have also passed cleanly since the commit (snapper's only run once). 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. regards, tom lane [1] https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=3Dkomodoensis&= dt=3D2022-03-26%2015%3A54%3A04 [2] https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=3Dpetalura&dt=3D= 2022-03-26%2004%3A20%3A04 [3] https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=3Dsnapper&dt=3D= 2022-03-26%2018%3A46%3A28