Re: BUG #12856: No space left on device, but there is space!

Hi Adam,

You might check whether you've exhausted the inodes on that filesystem with
"df -i". That will also return ENOSPC.

On Thu, Mar 12, 2015 at 10:43:09AM +0000, agroszer(at)gmail(dot)com wrote:
> The following bug has been logged on the website:
>
> Bug reference: 12856
> Logged by: Adam Groszer
> Email address: agroszer(at)gmail(dot)com
> PostgreSQL version: 9.4.1
> Operating system: ubuntu 14.04
> Description:
>
> After our tests create a lot of DBs, around 50-100, I get this exception:
>
> psycopg2.OperationalError: could not create file "base/24468164/24468205":
> No space left on device
>
> Weird is that 'df' shows over 60G free space on the mount and the tests
> definitely won't use that much space.
>
> After removing most of the DBs everything is back to normal, till DBs start
> to pile up again.
>
> What to check to help debugging this?
>
> thanks,
> Adam
>
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs

--
-- Skylar Thompson (skylar2(at)u(dot)washington(dot)edu)
-- Genome Sciences Department, System Administrator
-- Foege Building S046, (206)-685-7354
-- University of Washington School of Medicine