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 1soMct-00Aehf-6S for pgsql-general@arkaria.postgresql.org; Wed, 11 Sep 2024 12:39:16 +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 1soMcs-00GlZZ-M9 for pgsql-general@arkaria.postgresql.org; Wed, 11 Sep 2024 12:39:14 +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 1soMcr-00GlZ0-Gc for pgsql-general@lists.postgresql.org; Wed, 11 Sep 2024 12:39:14 +0000 Received: from fout4-smtp.messagingengine.com ([103.168.172.147]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1soMcn-000e0i-DY for pgsql-general@lists.postgresql.org; Wed, 11 Sep 2024 12:39:12 +0000 Received: from phl-compute-05.internal (phl-compute-05.phl.internal [10.202.2.45]) by mailfout.phl.internal (Postfix) with ESMTP id 7092F13802F9; Wed, 11 Sep 2024 08:39:08 -0400 (EDT) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-05.internal (MEProxy); Wed, 11 Sep 2024 08:39:08 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :reply-to:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t=1726058348; x= 1726144748; bh=bKTtkqAsJ4rnRBSArNDBs2E3KkXzmUUFdcIVR9FYJwk=; b=A RzNY5Pc7x0uBRzIAQA0XQZpzxKxnEiXEtEBd1RBaNwJj4RbGT2T2O1UFO9ELOPqe 4lt9y73z1k93Po724WxMao3wyNt2QxhNi7u8ChXqsRdfFPcIQwckqi/Mven3eiv6 hqSOR6j4abKVq1UVs0b7nODQEzZiY4pNA+mPyct073NU2dr22SAhtkTyJBP7Etm7 UkXdonc1nRaOs+H73XbJTt3EwYm1XZJN3PZ7GynObZMhVZ+x5I7qBBJxNCUKJqiZ X8hoqfoSuue1UiPRQmKVcNKM7KU3mNqkDjJl1Sg/UNmDhhOFHJAacGP6HLfOpeTW sAmIJPEo94MPfLb2f+5Jw== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeftddrudejuddgheefucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdggtfgfnhhsuhgsshgtrhhisggvpdfu rfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnh htshculddquddttddmnecujfgurhepfffhvfevuffkgggtugfgjgesthekredttddtjeen ucfhrhhomheptehlvhgrrhhoucfjvghrrhgvrhgruceorghlvhhhvghrrhgvsegrlhhvhh drnhhoqdhiphdrohhrgheqnecuggftrfgrthhtvghrnhepvdektdffudfftdffffehfffh jeejhffgieeuueekjeekfffgudffhfduffffueevnecuffhomhgrihhnpegvnhhtvghrph hrihhsvggusgdrtghomhenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgr ihhlfhhrohhmpegrlhhvhhgvrhhrvgesrghlvhhhrdhnohdqihhprdhorhhgpdhnsggprh gtphhtthhopeegpdhmohguvgepshhmthhpohhuthdprhgtphhtthhopegrnhgurhgvshes rghnrghrrgiivghlrdguvgdprhgtphhtthhopehthhhomhgrshdrmhhunhhrohesghhmrg hilhdrtghomhdprhgtphhtthhopehpghhsqhhlqdhgvghnvghrrghlsehlihhsthhsrdhp ohhsthhgrhgvshhqlhdrohhrghdprhgtphhtthhopehjrghnrdhpvggtshhokhesphhroh hfihhnihhtrdgvuh X-ME-Proxy: Feedback-ID: ia2694551:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 11 Sep 2024 08:39:07 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=alvh.no-ip.org; s=schmee; t=1726058345; bh=hLbaf6Rl7sSGPu0o5hoGw5d7Wor98geq7twFGaLQ9uY=; h=Date:From:To:Cc:Subject:In-Reply-To:From; b=mGzkZE0UMtteEZobgM9Jvd7hmrRqEvMF0nFMvyIZRjdv1jfU0K4GopGBBaC0Ld9kS 9t58jCqw44IOshksC4zJX+L2LsnYFJSUckw+Quu/Z+Lz9yAFZijaf1SV9oIv5wN5in +16OdD4KDBF8HsrD02yX4Yu/mWkl1f+2RqXQvloXxGtSVkg7FaUGfEBCF+XPNQsvQM kycHhTdg4JaFKaouOQJ1oqssKjBeDNYecvrXlnxDZJbAjJQkHmy2oi4A3/cjvRJBfV jAhEWKLIN3zEknCNRHyO7RwpUWx+S/7dnVM/kqMx4QuDRumQr9CipsBU0CJ8S8q3OK htTA/oBs8c+KA== Received: by schmee.alvh.no-ip.org (Postfix, from userid 1000) id 5B238D35; Wed, 11 Sep 2024 09:39:05 -0300 (-03) Date: Wed, 11 Sep 2024 14:39:05 +0200 From: Alvaro Herrera To: =?utf-8?B?UGVjc8O2ayBKw6Fu?= Cc: Thomas Munro , "pgsql-general@lists.postgresql.org" , Andres Freund Subject: Re: Error:could not extend file " with FileFallocate(): No space left on device Message-ID: <202409111239.n2dybum5hcwj@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2024-Sep-11, Pecsök Ján wrote: > In our case: > Kernel: Linux version 4.18.0-513.18.1.el8_9.ppc64le (mockbuild@ppc-hv-13.build.eng.rdu2.redhat.com) (gcc version 8.5.0 20210514 (Red Hat 8.5.0-20) (GCC)) #1 SMP Thu Feb 1 02:52:53 EST 2024 > File systém type:xfs Can you please share the output of xfs_info for the filesystem(s) used? Apparently, it's possible for allocation groups to be suboptimally laid out in a way that leads to ENOSPC with space still available. -- Álvaro Herrera Breisgau, Deutschland — https://www.EnterpriseDB.com/ "Pensar que el espectro que vemos es ilusorio no lo despoja de espanto, sólo le suma el nuevo terror de la locura" (Perelandra, C.S. Lewis)