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

The answer is obvious: The disk is full.

Try df -h on Linux to show how full your disks are. At least one of them should show 99% full or similar.

So it's a problem beyond PostgreSQL.

Hi All,

I am looking for somebody help to find out the below issue which I am getting on postgresql 9.6 database .

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)

 

Regards

Ashok

-- 
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012

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