Re: Error:could not extend file " with FileFallocate(): No space left on device - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Error:could not extend file " with FileFallocate(): No space left on device
Date
Msg-id 202409111239.n2dybum5hcwj@alvherre.pgsql
Whole thread Raw
Responses RE: Error:could not extend file " with FileFallocate(): No space left on device
Re: Error:could not extend file " with FileFallocate(): No space left on device
List pgsql-general
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.020210514 (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)



pgsql-general by date:

Previous
From: Greg Sabino Mullane
Date:
Subject: Re: infinite loop in an update statement
Next
From: Greg Sabino Mullane
Date:
Subject: Re: Ghost data from failed FDW transactions?