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 1m4SHV-0008IB-Hp for pgsql-bugs@arkaria.postgresql.org; Fri, 16 Jul 2021 18:09:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1m4SHT-00028K-K0 for pgsql-bugs@arkaria.postgresql.org; Fri, 16 Jul 2021 18:09:47 +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 1m4SHS-00023F-Sd for pgsql-bugs@lists.postgresql.org; Fri, 16 Jul 2021 18:09:47 +0000 Received: from out2-smtp.messagingengine.com ([66.111.4.26]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m4SHM-0005a1-6Q for pgsql-bugs@lists.postgresql.org; Fri, 16 Jul 2021 18:09:45 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id 870855C00F8; Fri, 16 Jul 2021 14:09:38 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute4.internal (MEProxy); Fri, 16 Jul 2021 14:09:38 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:subject:to :x-me-proxy:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s= fm3; bh=1ahn+jTJKxrxxNYpd0fYorg0CzzGiWDp6T7r3gEYN9k=; b=F75Ga7Q8 9KW0y1Pz4idBxubNLBTDDqK91zK+efD+WSGPgNYMpY9yLO7LDC+AfkN1iUXO1CW7 Yc/xoxvYO/01k2YLlj9nVP+N48j5u1B7go44s58MLD3ZDtY7XbxAG6XdOjIqbfi0 Hlq1xO/WJre1btDuuF33Ni6rVwRBT5bPegeTVqoK3nfOahP5yFg0vsTmYquG3UWT I9gIV+dNEv77yCilP0ReIQg6iJwvsAClq6rxoNEhua6TA7g5Sg7FWtjpf4cHfFpH qhgUlBEAfzGj/OL3VMMDxRUVci/lCqPOUvKMS7ZGyWa6mXnuNArUxW1kqTXZ+40f xeAEsdDlr79+KA== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvtddrvdefgdduudduucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucenucfjughrpeffhffvuffkgggtugfgjgesthekre dttddtjeenucfhrhhomheptehlvhgrrhhoucfjvghrrhgvrhgruceorghlvhhhvghrrhgv segrlhhvhhdrnhhoqdhiphdrohhrgheqnecuggftrfgrthhtvghrnhepudejveejffejve duudetvdekieeuiedtvdeileefkeevjedufeeguedvjefhueelnecuffhomhgrihhnpegv nhhtvghrphhrihhsvggusgdrtghomhenucevlhhushhtvghrufhiiigvpedtnecurfgrrh grmhepmhgrihhlfhhrohhmpegrlhhvhhgvrhhrvgesrghlvhhhrdhnohdqihhprdhorhhg X-ME-Proxy: Received: by mail.messagingengine.com (Postfix) with ESMTPA; Fri, 16 Jul 2021 14:09:37 -0400 (EDT) Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id E279E2A097C; Fri, 16 Jul 2021 14:09:33 -0400 (-04) Date: Fri, 16 Jul 2021 14:09:33 -0400 From: Alvaro Herrera To: Kyotaro Horiguchi Cc: jeff.janes@gmail.com, mk@071.ovh, pgsql-bugs@lists.postgresql.org Subject: Re: BUG #17103: WAL segments are not removed after exceeding max_slot_wal_keep_size Message-ID: <202107161809.zclasccpfcg3@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <20210716.110500.137369520113769822.horikyota.ntt@gmail.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk I was running tests for another patch, and this one failed once: Testing REL_14_BETA2-168-g1cb94c3c4c started: vie jul 16 14:02:11 -04 2021 # Failed test 'check that the warning is logged' # at t/019_replslot_limit.pl line 187. # Failed test 'check that the slot became inactive and the state "lost" persists' # at t/019_replslot_limit.pl line 198. # got: 'rep1|t|t|lost|' # expected: 'rep1|f|t|lost|' # Failed test 'check that segments have been removed' # at t/019_replslot_limit.pl line 213. # got: '000000010000000000000014' # expected: '00000001000000000000001C' # Looks like you failed 3 tests of 19. make[2]: *** [Makefile:23: check] Error 1 The buildfarm has remained green so far, but clearly this is something we need to fix. Maybe it's as simple as adding the loop we use below, starting at line 219. -- Álvaro Herrera 39°49'30"S 73°17'W — https://www.EnterpriseDB.com/