Re: And the error comes from ...

From: David Garnier <david(dot)garnier(at)etudier-online(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: And the error comes from ...
Date: 2002-07-30 21:17:37
Message-ID: 20020730231737.3d0b794b.david.garnier@etudier-online.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

I've already seen this error. At first I though that this was some other problem than disk space because the server had something like 500M of free space. Finally, I monitored the diskspace with df during the execution of the query, and my query did actually filled the whole 500M.

Best regards,
David Garnier

On Tue, 30 Jul 2002 14:51:56 -0400
"Mihai Gheorghiu" <tanethq(at)earthlink(dot)net> wrote:

> PG7.1.3 on RH7.1; Tomcat4.0.3, jdk1.4.0 on RH7.2 on another box.
> When I run a particular query, catalina.out lists the following exception:
> java.sql.SQLException: ERROR: ltsWriteBlock: failed to write block 40984 of
> temporary file
> Perhaps out of disk space?
> Does this error reflect the problem on the web server computer, or on the
> backend (PG computer)?
> Thank you all.
> Mihai Gheorghiu
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Mihai Gheorghiu 2002-07-30 21:31:44 Re: And the error comes from ...
Previous Message Dave Cramer 2002-07-30 20:14:08 Re: And the error comes from ...