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
> So that's not it. It would take ~60 million > files to fill up your / inode table. I can't > think of another explanation for that error > message if df without -i also shows free space.
I'm going to take a shot in the dark and ask if the root file system is XFS. It doesn't take too much googling to find out that XFS has a reputation for reporting ENOSPC when there seems to be more than enough room left. Apparently, it can do so as a result of fragmentation problems even though the disk as a whole has lots of space --- for one cautionary example see this thread:
typo-ishly titled "ENSOPC on a 10% used disk". It looks like the XFS crew installed a fix for the underlying bug ... but that thread is from 2018 and you're running a 2015 Ubuntu release.
Or, to cut to the chase: maybe updating to a less hoary kernel would help. If you are stuck with this Ubuntu release for some reason, consider using a less bleeding-edge-at-the-time file system.