public inbox for [email protected]
help / color / mirror / Atom feedFrom: Pecsök Ján <[email protected]>
To: Alvaro Herrera <[email protected]>
Cc: Thomas Munro <[email protected]>
Cc: [email protected] <[email protected]>
Cc: Andres Freund <[email protected]>
Subject: RE: Error:could not extend file " with FileFallocate(): No space left on device
Date: Wed, 11 Sep 2024 13:31:45 +0000
Message-ID: <AS1PR05MB91053B88C4C610FC8EB60E139F9B2@AS1PR05MB9105.eurprd05.prod.outlook.com> (raw)
In-Reply-To: <[email protected]>
References: <AS1PR05MB9105F5A24271EEC357DA5D919F9B2@AS1PR05MB9105.eurprd05.prod.outlook.com>
<[email protected]>
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 <[email protected]>
Sent: Wednesday, September 11, 2024 2:39 PM
To: Pecsök Ján <[email protected]>
Cc: Thomas Munro <[email protected]>; [email protected]; Andres Freund <[email protected]>
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
> ([email protected]) (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)
view thread (6+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected], [email protected]
Subject: RE: Error:could not extend file " with FileFallocate(): No space left on device
In-Reply-To: <AS1PR05MB91053B88C4C610FC8EB60E139F9B2@AS1PR05MB9105.eurprd05.prod.outlook.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox