MIME-Version: 1.0
References: <AS1PR05MB91059AC8B525910A5FCD6E699F9A2@AS1PR05MB9105.eurprd05.prod.outlook.com>
 <202409110955.6njbwzm4ocus@alvherre.pgsql>
In-Reply-To: <202409110955.6njbwzm4ocus@alvherre.pgsql>
From: Thomas Munro <thomas.munro@gmail.com>
Date: Wed, 11 Sep 2024 22:44:52 +1200
Message-ID: <CA+hUKGJ_QZMc25uRyjVty3sr9GpFDwy=diUFjpCuX2quezW=Cw@mail.gmail.com>
Subject: Re: Error:could not extend file " with FileFallocate(): No space left
 on device
To: Alvaro Herrera <alvherre@alvh.no-ip.org>
Cc: =?UTF-8?B?UGVjc8O2ayBKw6Fu?= <jan.pecsok@profinit.eu>, 
	"pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>, Andres Freund <andres@anarazel.de>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/CA%2BhUKGJ_QZMc25uRyjVty3sr9GpFDwy%3DdiUFjpCuX2quezW%3DCw%40mail.gmail.com>
Precedence: bulk

On Wed, Sep 11, 2024 at 9:56=E2=80=AFPM Alvaro Herrera <alvherre@alvh.no-ip=
.org> wrote:
> On 2024-Sep-10, Pecs=C3=B6k J=C3=A1n wrote:
> > After upgrade of Posgres from version 13.5 to 16.2 we experience follow=
ing 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 we=
eks of intensive query computation.
> > Was there some changes in space allocation from Posgres 13.5  to Posgre=
s  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)?