Failed to write in CSV file, even though there is enough space is available
Reported by Psycopg website | August 16th, 2013 @ 05:10 AM
Submitted by: Saravanakumar Karunanithi
psycopg2.InternalError: bfz_nothing_write_ex write failed with (errno 28) No space left on device (compress_nothing.c:48) (seg1 slice1 db6:40001 pid=18228) (cdbdisp.c:1489)
I am using Greenplum with postgresql.
My version is 2.0.8.
I am trying to export some data into CSV file.
but there is enough space. (the data not in GB, hardly ~500MB).
here is my output of df -h
/dev/mapper/vg0-root 50G 38G 9.7G 80% / tmpfs 6.0G 0 6.0G 0%
varrun 6.0G 164K 6.0G 1% /var/run
varlock 6.0G 0 6.0G 0% /var/lock
udev 6.0G 156K 6.0G 1% /dev
tmpfs 6.0G 60K 6.0G 1% /dev/shm
/dev/sda1 487M 25M 437M 6% /boot /dev/mapper/vg0-tmp 497G 304G 168G 65% /var /dev/mapper/vg0-home 50G 33G 15G 69% /home
I am running it from home directory of the current user.
We cannot upgrade to latest version.
Comments and changes to this ticket
Create your profile
Help contribute to this project by taking a few moments to create your personal profile. Create your profile »
Psycopg is the most used PostgreSQL adapter for the Python programming language. At the core it fully implements the Python DB API 2.0 specifications. Several extensions allow access to many of the features offered by PostgreSQL.