Re: And the error comes from ...

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)
>