Error:could not extend file " with FileFallocate(): No space left on device - Mailing list pgsql-general

From Pecsök Ján
Subject Error:could not extend file " with FileFallocate(): No space left on device
Date
Msg-id AS1PR05MB91059AC8B525910A5FCD6E699F9A2@AS1PR05MB9105.eurprd05.prod.outlook.com
Whole thread Raw
List 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.

 

pgsql-general by date:

Previous
From: Shaheed Haque
Date:
Subject: Re: Database schema for "custom fields"
Next
From: Adrian Klaver
Date:
Subject: Re: infinite loop in an update statement