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

Le mer. 1 juil. 2020 à 00:11, raf <raf(at)raf(dot)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(at)gmail(dot)com <jauresfoute(at)gmail(dot)com>*,
jauresmelkiore(at)yahoo(dot)fr
Compte Skype: jauresmelkiore