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@xxxxxxxxxxxxxx>
Sent: Wednesday, September 11, 2024 2:39 PM
To: Pecsök Ján <jan.pecsok@xxxxxxxxxxx>
Cc: Thomas Munro <thomas.munro@xxxxxxxxx>; pgsql-general@xxxxxxxxxxxxxxxxxxxx; Andres Freund <andres@xxxxxxxxxxx>
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@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx) (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)
