Thread: Can someone please explain this error
Hi I have just recevived this error could not write to hash-join temporary file: No space left on device Can someone please explain how I can stop this occuring. Whereis the hash-join temporary file? How can I make it big? etc. The query question runs fine in Oracle, MySQL and Postgres normally, but I have seen this error twise recently. I have used df -k to check the filesystems and none are full, and a Google search has revealed nothing. Simon -- Simon Windsor Email: simon.windsor@cornfield.org.uk Tel: 01454 617689 Mob: 07960 321599
Simon Windsor <simon.windsor@cornfield.org.uk> wrote: > Hi > > I have just recevived this error > > could not write to hash-join temporary file: No space left on device > > Can someone please explain how I can stop this occuring. Whereis the hash-join > temporary file? How can I make it big? etc. > > The query question runs fine in Oracle, MySQL and Postgres normally, but I > have seen this error twise recently. I have used df -k to check the > filesystems and none are full, and a Google search has revealed nothing. How close to full are they? Is it possible that during load they occasionally fill up for a short period of time, and then other activity cleans up some files and frees space? -- Bill Moran Potential Technologies http://www.potentialtech.com