Re: Error in getNextException No space left on device Call getNextException to see other errors in the batch. (java.sql.BatchUpdateException)

dbatoCloud Solution <dbatocloud17@gmail.com> writes:
> ERROR: could not write to hash-join temporary file: No space left on device
> Call getNextException to see other errors in the batch.
> (java.sql.BatchUpdateException)

If there's a reasonable amount of free disk space when the problem
query isn't running, this is likely telling you that you have a
query logic error.  That is, you're commanding the DB to form some
unreasonably large join product, perhaps as a result of a missing
WHERE constraint.

            regards, tom lane