Re: Error:could not extend file " with FileFallocate(): No space left on device

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Pecsök Ján <jan(dot)pecsok(at)profinit(dot)eu>
Cc: Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>, Andres Freund <andres(at)anarazel(dot)de>
Subject: Re: Error:could not extend file " with FileFallocate(): No space left on device
Date: 2024-09-11 12:39:05
Message-ID: 202409111239.n2dybum5hcwj@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)ppc-hv-13(dot)build(dot)eng(dot)rdu2(dot)redhat(dot)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)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Greg Sabino Mullane 2024-09-11 12:57:17 Re: Ghost data from failed FDW transactions?
Previous Message Greg Sabino Mullane 2024-09-11 12:29:40 Re: infinite loop in an update statement