From: Holger Jakobs <holger@jakobs.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Error in getNextException No space left on device Call getNextException to see other errors in the batch. (java.sql.BatchUpdateException)
Date: Thu, 17 Dec 2020 14:00:44 +0100
Message-ID: <9e3fa742-26df-8b72-9054-df26a087c89a@jakobs.com> (raw)
In-Reply-To: <CAEz7P_sjhZTU+zUCSKwEfT_fdqx9kouSn_PHe6ShdXKvfYdJsw@mail.gmail.com>
References: <CAEz7P_sjhZTU+zUCSKwEfT_fdqx9kouSn_PHe6ShdXKvfYdJsw@mail.gmail.com>
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.
Am 17.12.20 um 13:30 schrieb dbatoCloud Solution:
> 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
Attachments:
OpenPGP_signature (application/pgp-signature, 202B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: holger@jakobs.com, pgsql-admin@lists.postgresql.org
Subject: Re: Error in getNextException No space left on device Call getNextException to see other errors in the batch. (java.sql.BatchUpdateException)
In-Reply-To: <9e3fa742-26df-8b72-9054-df26a087c89a@jakobs.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox