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

Output of xfs_info:
[]# xfs_info /data/aisgamp1/pgdata_system
meta-data=/dev/mapper/dataamp1vg-lv_aisgamp1_pgsys isize=512 agcount=118, agsize=134217720 blks
= sectsz=512 attr=2, projid32bit=1
= crc=1 finobt=1, sparse=1, rmapbt=0
= reflink=1 bigtime=0 inobtcount=0
data = bsize=8192 blocks=15703474176, imaxpct=1
= sunit=8 swidth=32 blks
naming =version 2 bsize=8192 ascii-ci=0, ftype=1
log =internal log bsize=8192 blocks=260864, version=2
= sectsz=512 sunit=8 blks, lazy-count=1
realtime =none extsz=8192 blocks=0, rtextents=0

It is also interesting, that there are over 1 milion files in ll /data/aisgamp1/pgdata_system/aisgamp1/PG_16_202307071/17820/

# ll /data/aisgamp1/pgdata_system/aisgamp1/PG_16_202307071/17820/ | wc -l
1129340

df -h /data/aisgamp1/pgdata_system/aisgamp1/PG_16_202307071/17820 /data/aisgamp1/pgdata_system/temp/PG_16_202307071/17820
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/dataamp1vg-lv_aisgamp1_pgsys 117T 91T 27T 78% /data/aisgamp1/pgdata_system
/dev/mapper/dataamp1vg-lv_aisgamp1_pgsys 117T 91T 27T 78% /data/aisgamp1/pgdata_system

-----Original Message-----
From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
Sent: Wednesday, September 11, 2024 2:39 PM
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; Andres Freund <andres(at)anarazel(dot)de>
Subject: Re: Error:could not extend file " with FileFallocate(): No space left on device

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)