public inbox for [email protected]
help / color / mirror / Atom feedFrom: Pecsök Ján <[email protected]>
To: Thomas Munro <[email protected]>
To: Alvaro Herrera <[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 10:48:43 +0000
Message-ID: <AS1PR05MB9105F5A24271EEC357DA5D919F9B2@AS1PR05MB9105.eurprd05.prod.outlook.com> (raw)
In-Reply-To: <CA+hUKGJ_QZMc25uRyjVty3sr9GpFDwy=diUFjpCuX2quezW=Cw@mail.gmail.com>
References: <AS1PR05MB91059AC8B525910A5FCD6E699F9A2@AS1PR05MB9105.eurprd05.prod.outlook.com>
<[email protected]>
<CA+hUKGJ_QZMc25uRyjVty3sr9GpFDwy=diUFjpCuX2quezW=Cw@mail.gmail.com>
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
-----Original Message-----
From: Thomas Munro <[email protected]>
Sent: Wednesday, September 11, 2024 12:45 PM
To: Alvaro Herrera <[email protected]>
Cc: Pecsök Ján <[email protected]>; [email protected]; Andres Freund <[email protected]>
Subject: Re: Error:could not extend file " with FileFallocate(): No space left on device
On Wed, Sep 11, 2024 at 9:56 PM Alvaro Herrera <[email protected]> wrote:
> On 2024-Sep-10, Pecsök Ján wrote:
> > After upgrade of Posgres from version 13.5 to 16.2 we experience following error:
> > could not extend file
> > "pg_tblspc/16401/PG_16_202307071/17820/3968302971" with
> > FileFallocate(): No space left on device
> >
> > We cannot easily replicate problem. It happens at randomly every 1-2 weeks of intensive query computation.
> > Was there some changes in space allocation from Posgres 13.5 to Posgres 16.2?
> >
> > Database has size 91TB and has 27TB more space available.
>
> Yes, there were some changes in that area. I have a report from
> somebody running EPAS 16 which has a problem that looks pretty much
> the same as yours -- and the code is essentially identical. I gave
> them the attached patch, hoping that it would shed some light ... but
> so far, we've been unable to capture any useful intel.
What kernel version and file system are these running on (both cases)?
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: <AS1PR05MB9105F5A24271EEC357DA5D919F9B2@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