public inbox for [email protected]  

help / color / mirror / Atom feed

From: Thomas Munro <[email protected]>
To: Alvaro Herrera <[email protected]>
Cc: Pecsök Ján <[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 22:44:52 +1200
Message-ID: <CA+hUKGJ_QZMc25uRyjVty3sr9GpFDwy=diUFjpCuX2quezW=Cw@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <AS1PR05MB91059AC8B525910A5FCD6E699F9A2@AS1PR05MB9105.eurprd05.prod.outlook.com>
	<[email protected]>

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

view thread (3+ messages)

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: <CA+hUKGJ_QZMc25uRyjVty3sr9GpFDwy=diUFjpCuX2quezW=Cw@mail.gmail.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