Re: PostgreSQL 12 - ERROR: could not rename file "pg_logical/snapshots/1A-7C00D890.snap.13594.tmp" to "pg_logical/snapshots/1A-7C00D890.snap": No space left on device - Mailing list pgsql-general

From FOUTE K. Jaurès
Subject Re: PostgreSQL 12 - ERROR: could not rename file "pg_logical/snapshots/1A-7C00D890.snap.13594.tmp" to "pg_logical/snapshots/1A-7C00D890.snap": No space left on device
Date
Msg-id CAHQ1jfc5CLT6sMG1XNv4coMq=bUZLoKj+HpzfhL37sYDmPo9SA@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL 12 - ERROR: could not rename file "pg_logical/snapshots/1A-7C00D890.snap.13594.tmp" to "pg_logical/snapshots/1A-7C00D890.snap": No space left on device  (raf <raf@raf.org>)
Responses Re: PostgreSQL 12 - ERROR: could not rename file "pg_logical/snapshots/1A-7C00D890.snap.13594.tmp" to "pg_logical/snapshots/1A-7C00D890.snap": No space left on device
List pgsql-general


Le mer. 1 juil. 2020 à 00:11, raf <raf@raf.org> a écrit :
FOUTE K. Jaurčs wrote:

> Hi everyone,
>
> I am use a native logical replication in PostgreSQL 12 on Ubuntu 16.04 and
> all is working fine until i faced this error below.
>
> ERROR:  could not rename file
> "pg_logical/snapshots/1A-7C00D890.snap.13594.tmp" to
> "pg_logical/snapshots/1A-7C00D890.snap": No space left on device
>
> Is there someone who faced this problem?
> Any idea how I can solve it ?
>
> BTW: I don't have any problem with space.
>
> Best Regard
>
> --
> Jaurčs FOUTE

If you really haven't run out of space,
you might have run out of inodes.
The -i option of df should show you.
100,000 empty files could cause that.
I wouldn't think that renaming would
require a new inode, but I also wouldn't
think that renaming would require any
more space on a file system.

The result of df -i

Sys. de fichiers   Inœuds IUtil.   ILibre IUti% Monté sur
udev              3065149    433  3064716    1% /dev
tmpfs             3072780    665  3072115    1% /run
/dev/sdb2        59973632 356029 59617603    1% /
tmpfs             3072780      7  3072773    1% /dev/shm
tmpfs             3072780     10  3072770    1% /run/lock
tmpfs             3072780     17  3072763    1% /sys/fs/cgroup
/dev/sdb1               0      0        0     - /boot/efi
tmpfs             3072780     19  3072761    1% /run/user/108
tmpfs             3072780      5  3072775    1% /run/user/1001
tmpfs             3072780      5  3072775    1% /run/user/1000 
 

cheers,
raf





--
Jaurès FOUTE 
Technology Consultant
ISNOV SARL - Business Technology Consulting
Tel: +237 79395671 / +237 96248793
Email: jauresfoute@gmail.com
          jauresmelkiore@yahoo.fr
Compte Skype: jauresmelkiore

pgsql-general by date:

Previous
From: FOUTE K. Jaurès
Date:
Subject: Re: PostgreSQL 12 - ERROR: could not rename file "pg_logical/snapshots/1A-7C00D890.snap.13594.tmp" to "pg_logical/snapshots/1A-7C00D890.snap": No space left on device
Next
From: Emrah Tema
Date:
Subject: BDR node status stays as C, not ready