Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tVMev-007dkL-UA for pgsql-bugs@arkaria.postgresql.org; Wed, 08 Jan 2025 03:23:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tVMet-00BmHI-0D for pgsql-bugs@arkaria.postgresql.org; Wed, 08 Jan 2025 03:23:02 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tVMes-00BmGI-9Z for pgsql-bugs@lists.postgresql.org; Wed, 08 Jan 2025 03:23:02 +0000 Received: from fhigh-b3-smtp.messagingengine.com ([202.12.124.154]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tVMen-000STk-2x for pgsql-bugs@lists.postgresql.org; Wed, 08 Jan 2025 03:23:01 +0000 Received: from phl-compute-03.internal (phl-compute-03.phl.internal [10.202.2.43]) by mailfhigh.stl.internal (Postfix) with ESMTP id 76370254017D; Tue, 7 Jan 2025 22:22:56 -0500 (EST) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-03.internal (MEProxy); Tue, 07 Jan 2025 22:22:56 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:subject :subject:to:to; s=fm2; t=1736306576; x=1736392976; bh=AqvUjIjehQ QaFzfydee8lOvlMGZdVVBupvJfO9l7O8w=; b=hwLAAnU8P6wNB+U9C2TwjSS6kk 4TkitnpE/E3r9haTZDle6CDk9UVd5rS6eRfuQeZEXCizDcLv0jP/UT3Nc/D1JL+7 dOis6TjlmwjiQdwiBzCbAua5BBnF5ONgIRf4usDcVk5FLHaPQUn69WZVHlwkqatm j2gMVOXtlZJNaa81kMgrVQX2K1y3t1iGexrhhmyteGCPqfjwvRQ9XB1wNZngbqBR dmdrIVhqRQNMTA/RdTPNA53uiy5F1WBvPebVK1DKaiFUqeCMDd9Jjq2XCNq9iN2w Vci/LTshFGCDYvPc6H85NQ7606D375bwb2Me8XtfxpvUIgKLIeTYGI69aL9A== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:subject:subject:to :to:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm2; t= 1736306576; x=1736392976; bh=AqvUjIjehQQaFzfydee8lOvlMGZdVVBupvJ fO9l7O8w=; b=BOyFtrl3/C3rtrmrEkjAqkCSSrp4G2BX27o+4HdCnojsR00PyQo 0nSjaNZwqR4Xkz2QDLPzmAsW7LqPY8ls7Jy6GVifFrysaD8QuRDIUMxPXGV55hAy d4TlvSeBrM2G23/BWy1yDDZEqwuvSYEYOVbzCbjoNRN8PH1FtDhFRFOJZCSNhvl2 dGuF1pGPHVrJdZG0z27NDV+GBbbbGU3Vgpakw1qTbDE8BB/m3yRHsNj9byf0NKDT wOnhxsv7SQIXu20TqltUxNBh/VDtUfXADtcOW08ws3lL3noG1njgzGn8JEW5O2gz 7UZTi8pqpjJFqC8ihOm0e0QTYkeJacm4MHw== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefuddrudegfedgheeiucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdggtfgfnhhsuhgsshgtrhhisggvpdfu rfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnh htshculddquddttddmnegfrhhlucfvnfffucdlfeehmdenucfjughrpeffhffvvefukfhf gggtuggjsehgtderredttddvnecuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruc eomhhitghhrggvlhesphgrqhhuihgvrhdrgiihiieqnecuggftrfgrthhtvghrnhepueeg hfffieekudeuueegteetudfhhfdtgfeiffffveehleelveejveefledujedvnecuffhomh grihhnpehpohhsthhgrhgvshhqlhdrohhrghdpphhgshhqlhdrsghuihhlugenucevlhhu shhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpehmihgthhgrvghlse hprghquhhivghrrdighiiipdhnsggprhgtphhtthhopeekpdhmohguvgepshhmthhpohhu thdprhgtphhtthhopehthhhomhgrshdrmhhunhhrohesghhmrghilhdrtghomhdprhgtph htthhopehrohgsvghrthhmhhgrrghssehgmhgrihhlrdgtohhmpdhrtghpthhtohephhhl ihhnnhgrkhgrsehikhhirdhfihdprhgtphhtthhopegvgigtlhhushhiohhnsehgmhgrih hlrdgtohhmpdhrtghpthhtohepthhglhesshhsshdrphhghhdrphgrrdhushdprhgtphht thhopehlrghurhgvnhiirdgrlhgsvgestgihsggvrhhtvggtrdgrthdprhgtphhtthhope hrohhothgtrghushgvtddttdesghhmrghilhdrtghomhdprhgtphhtthhopehpghhsqhhl qdgsuhhgsheslhhishhtshdrphhoshhtghhrvghsqhhlrdhorhhg X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Tue, 7 Jan 2025 22:22:52 -0500 (EST) Date: Wed, 8 Jan 2025 12:22:41 +0900 From: Michael Paquier To: Thomas Munro Cc: Robert Haas , Heikki Linnakangas , Alexander Lakhin , Tom Lane , Laurenz Albe , rootcause000@gmail.com, pgsql-bugs@lists.postgresql.org Subject: Re: BUG #18146: Rows reappearing in Tables after Auto-Vacuum Failure in PostgreSQL on Windows Message-ID: References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="S65rbqUkoaK3Qqok" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --S65rbqUkoaK3Qqok Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Wed, Jan 08, 2025 at 08:50:33AM +0900, Michael Paquier wrote: > Sounds good to me. Thanks for the commit! Actually not that good, and wrasse is reporting a failure: https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=3Dwrasse&dt=3D2025-= 01-07%2022%3A26%3A00 "/export/home/nm/farm/studio64v12_6/REL_15_STABLE/pgsql.build/../pgsql/src/= backend/storage/smgr/smgr.c", line 634: void function cannot return value It seems to me that you meant to do the following in the back branches: --- a/src/backend/storage/smgr/smgr.c +++ b/src/backend/storage/smgr/smgr.c @@ -706,7 +706,7 @@ smgrtruncate(SMgrRelation reln, ForkNumber *forknum, in= t nforks, for (int i =3D 0; i < nforks; ++i) old_nblocks[i] =3D smgrnblocks(reln, forknum[i]); =20 - return smgrtruncate2(reln, forknum, nforks, old_nblocks, nblocks); + smgrtruncate2(reln, forknum, nforks, old_nblocks, nblocks); } -- Michael --S65rbqUkoaK3Qqok Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmd974EACgkQnvQgOdby QH3yjhAAmH0CY8i9smWtM0+Nt16STlzZOe8io8ZDSW9JbHOM41EJRK/C5Nfk6ac4 n2YVj+P3rluZ5mcYIh2U2SZ96a5OZOG5UXaIwpiRzJLyNiXhLHAx1wNacRkWRpIs D+5HtGvEQb/T7XxbpklIRn8bFq6DlgwbqMrWwMW48Sy4RDI1uZ2BYozvackGPfZM Z+Zt0xarsT2/IMMMkmN5frf+UanbZQj44K9y3fX4A7/XWQOS/hfq2zjpSj6Gd2g0 asKfpwwE3c6L4RZ5KroBd9rauDco2j2skrdYxctcJhLaO1KDXXLLCepi8/NaPsH3 hRKSfXSFwLhQPZGCQIqYDzokiZqMJkr40eYCJWdKNGxp2im8Pnjlo9iiLdtYW2Y1 EJbFpM8r0fCYVxGvSuUlef4sUydssX9OLPC+2wYUHS1n2BTfI/HTTct/cP0AN5rf bQIp/cYCpF73cKh7cpMH2XJRwTsXxyh6/UVlmnuUAVCJv6Y3p+Q0we7XFaxE6Kdz svcC6Seg6dWM3+XGAkciwgRpQBJEkIuQGrSWJ8x+2XqfyYI4nvcBKmTOD/StReI1 9bj1HFK8szxxe8nAelF+v08rnwybQBrGtAmFqfVujefiKZ83ELv51Akbq/DeFQXv FmZ6tEofCxix5sgQ4+BhbV0jbFegArJF+HA8kjI1NzVEP5c5aaE= =aWkG -----END PGP SIGNATURE----- --S65rbqUkoaK3Qqok--