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@alvh.no-ip.org> 
Sent: Wednesday, September 11, 2024 2:39 PM
To: Pecsök Ján <jan.pecsok@profinit.eu>
Cc: Thomas Munro <thomas.munro@gmail.com>; pgsql-general@lists.postgresql.org; Andres Freund <andres@anarazel.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@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
stillavailable.
 

-- 
Á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)