-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 The error is being generated by Postgres and means exactly what it says - - your disks are full.
As Postgres is well-designed and generally well-behaved software, it will be deleting all temporary files before exiting and reporting the error message. Therefore even though the error message refers to full disk problems when using temporary files, you don't see the filesystem being full if you check it after seeing the message. However, if you periodically monitor your filesystem whilst the SQL commands are still running, you'll probably see it filling up. The only way to resolve this is to allocate more disk space to the filesystem that Postgres is using for its temporary files. Your sysadmins will be able to help you, or the manual for your version of Postgres will also tell you how to fix it. cheers, Richard Alessandra Bilardi wrote: > Hi everyone, > I use PostgreSQL 8.1.9, Chado, CVS bioperl, BioMart 0.5 and > Debian 4.0 "etch" Linux kernel 2.6.18 (debian precompiled). > > I install Chado and insert test sgdlite database without problems. > I use bin/martbuilder.sh and create schema of sgdlite db and dataset > with only feature table. I save xml schema and sql script following > BioMart 0.5 Documentation. > > When I insert sql script with shell command: > psql -d sgdlite < sgdlite_mart.sql > sgdlite_mart.log 2> sgdlite_mart.err > in file error I see 3 error sort: > ERROR: could not extend relation 1663/63659/85595: No space left on device > ERROR: could not write block 21 of temporary file: No space left on device > ERROR: could not write to hash-join temporary file: No space left on device > > I test all in two server machines: > 1) AMD Opteron(tm) Processor 244, 1790.535MHz, 1024MB > 2) AMD Opteron(tm) Bi Processor 244, 1804.153MHz, 8192MB > > First errors begining when sql script inserts: > 1) relation about TEMP__100 > 2) relation about TEMP__227 > > In any case there are space in device: > 1) > Filesystem Dim Used Free Used Mount > /dev/md0 953M 254M 699M 27% / > tmpfs 503M 0 503M 0% /lib/init/rw > udev 10M 88K 10M 1% /dev > /dev/md1 5,6G 2,4G 3,2G 43% /var > /dev/md2 5,6G 3,5G 2,2G 62% /usr > /dev/md3 953M 340K 952M 1% /tmp > 2) > Filesystem Dim Used Free Used Mount > /dev/md0 953M 217M 737M 23% / > tmpfs 3,9G 0 3,9G 0% /lib/init/rw > udev 10M 88K 10M 1% /dev > /dev/md4 133G 67G 66G 51% /era > /dev/md3 953M 384K 952M 1% /tmp > /dev/md2 5,6G 3,0G 2,7G 54% /usr > /dev/md1 5,6G 915M 4,7G 17% /var > > Can someone help me? > Thanks very much for the help in advance. > > Alessandra Bilardi > =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= > CRIBI, University of Padova, Italy | http://www.linkedin.com/in/bilardi > Via Ugo Bassi, 58/B - 35121 Padova | http://tosearch.cjb.net/ > Tel 0498276165 -- Fax 0498276159 | [EMAIL PROTECTED] > =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= > -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2.2 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFGrwQy4C5LeMEKA/QRAgOHAKCQoDnDjYHs2ToyfLhnlAjUY0RqfQCeKksh nKd1zEXU+KBxBPdKeLUYbZM= =4XLi -----END PGP SIGNATURE-----
