kdbfchk

iclbloom · Post by **iclbloom** » Mon Jun 25, 2001 6:17 pm

when running a query I get

006 vcreateindex2:95: Can't write 2006 bytes at 00324A3C to KDBF file /usr/tmp/T21972d: error 28: No space left on device in the funcion write_block

This seems to be because I am running out of space on /usr/tmp?

would using the -t option on kdbfchk and specify an alternative file system avoid this error or is increasing the size of /usr/tmp a better solution?

Thanks
Leon Bloom

Post by **Kai** » Mon Jun 25, 2001 9:34 pm

Since the error is happening in a Vortex script, kdbfchk is not involved; -t sets the temp dir only for running kdbfchk, not for KDBF files across the board. Increase the available space on /usr/tmp, or set the environment variable TMP to point to a filesystem with more space. (You may need to set it in your web server's config files so that it is set in the CGI environment as well, if running from the web.)

Also review the query that was running at the time; it may need an additional index to avoid creating a temp file in the first place (and run faster).