Error:could not extend file " with FileFallocate(): No space left on device

From: Pecsök Ján <jan(dot)pecsok(at)profinit(dot)eu>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Error:could not extend file " with FileFallocate(): No space left on device
Date: 2024-09-10 13:11:16
Message-ID: AS1PR05MB91059AC8B525910A5FCD6E699F9A2@AS1PR05MB9105.eurprd05.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dear community,

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2024-09-10 14:57:40 Re: infinite loop in an update statement
Previous Message Shaheed Haque 2024-09-10 12:08:03 Re: Database schema for "custom fields"