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

2024-09-12 Thread Thomas Munro
On Thu, Sep 12, 2024 at 8:54 PM Pecsök Ján wrote: > In link you provided there is mention, that in PostgreSQL 16 data is not being > compressed for PostgreSQL 16 server. Does it mean, that PosgreSQL 16 use much > more space while computing queries? > If that is the case, it can be our problem, be

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

2024-09-12 Thread Pecsök Ján
Freund Subject: Re: Error:could not extend file " with FileFallocate(): No space left on device On Thu, Sep 12, 2024 at 12:39 AM Alvaro Herrera wrote: >> On 2024-Sep-11, Pecsök Ján wrote: > > In our case: > > Kernel: Linux version 4.18.0-513.18.1.el8_9.ppc64le &

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

2024-09-11 Thread Thomas Munro
I don't understand what ENOSPC has to do with the file descriptor limits, but this person reported: # touch test touch: cannot touch ‘test’: No space left on device https://serverfault.com/questions/746032/rsync-and-scp-failing-with-no-space-left-on-xfs-device ... with plenty of free space, and

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

2024-09-11 Thread Thomas Munro
On Thu, Sep 12, 2024 at 12:39 AM Alvaro Herrera wrote: >> On 2024-Sep-11, Pecsök Ján wrote: > > In our case: > > Kernel: Linux version 4.18.0-513.18.1.el8_9.ppc64le > > (mockbu...@ppc-hv-13.build.eng.rdu2.redhat.com) (gcc version 8.5.0 20210514 > > (Red Hat 8.5.0-20) (GCC)) #1 SMP Thu Feb 1 02:5

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

2024-09-11 Thread Pecsök Ján
Ján Cc: Thomas Munro ; pgsql-general@lists.postgresql.org; Andres Freund Subject: Re: Error:could not extend file " with FileFallocate(): No space left on device On 2024-Sep-11, Pecsök Ján wrote: > In our case: > Kernel: Linux version 4.18.0-513.18.1.el8_9.ppc64le > (mockb

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

2024-09-11 Thread Pecsök Ján
, September 11, 2024 12:45 PM To: Alvaro Herrera Cc: Pecsök Ján ; pgsql-general@lists.postgresql.org; Andres Freund 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 wrote: > On 2024-Sep-10, Pecsök J

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

2024-09-11 Thread Alvaro Herrera
On 2024-Sep-11, Pecsök Ján wrote: > In our case: > Kernel: Linux version 4.18.0-513.18.1.el8_9.ppc64le > (mockbu...@ppc-hv-13.build.eng.rdu2.redhat.com) (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 Can you please share the out

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

2024-09-11 Thread Thomas Munro
On Wed, Sep 11, 2024 at 9:56 PM Alvaro Herrera 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

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

2024-09-11 Thread Alvaro Herrera
Hello Ján, 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.

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

2024-09-11 Thread Pecsök Ján
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