Which file system (specifically, which directory)? Is it data/base/pgsql_tmp? There's 96GB free, which is 74% of the volume.
On 12/10/2018 04:50 PM, Rene Romero Benavides wrote:
Maybe the temp space got released right after the failure?
do you have space usage charts for that partition? doesn't it show a spike during that time?
There's certainly a problem with the application, but the error is in the pg_log, not the application log.
On 12/10/2018 03:21 PM, Rene Romero Benavides wrote:
What if this error message pertains to something happening on the application side?
Hi,
v9.6.6
2018-12-07 06:21:55.504 EST 10.140.181.89(35868) CDS CDSLBXW 13748 SELECT
PostgreSQL JDBC Driver 53100 ERROR: could not write to tuplestore temporary
file: No space left on device
I see this in the pg_log file, but #1 can't figure out what "tuplestore" is
(Google doesn't help), and #2 there's lots of space on all my file systems.
data/base, where pgsql_tmp lives, has 96GB free.)
Thanks
--
Angular momentum makes the world go 'round.
