Re: Weird error updating table

Hi Tom,

We actually have plenty of storage free. Our database server is
connected to an Xserve RAID.

Filesystem      Size   Used  Avail Capacity  Mounted on
/dev/disk1s3    745G    21G   725G     3%    /Volumes/nitro1.1
/dev/disk2s3    745G   4.1G   741G     1%    /Volumes/nitro1.2

We store the database on nitro1.1 and the pg_xlog on nitro1.2

So there's plenty of room.

We're on Mac OS X Tiger Server 10.4.6.

Thanks,


____________________________________________________________________
Brendan Duddridge | CTO | 403-277-5591 x24 |  brendan@clickspace.com

ClickSpace Interactive Inc.
Suite L100, 239 - 10th Ave. SE
Calgary, AB  T2G 0V9

http://www.clickspace.com

On Apr 18, 2006, at 1:21 PM, Tom Lane wrote:

> Brendan Duddridge <brendan@clickspace.com> writes:
>>      Next exception:SQL State:XX000 -- error code: 0 -- msg: ERROR:
>> could not read from hash-join temporary file: Unknown error: 0
>
>> Any one know what that could mean?
>
> It seems to imply unexpected end-of-file while reading from a temp
> file
> ... unless the kernel forgot to set errno during some other failure.
> What platform is this on, exactly?
>
> Looking at the code, it looks like BufFileClose is sloppy about
> checking
> for errors (such as out-of-disk-space) while flushing out the very
> last
> block of a temp file.  Is it possible that your query just barely ran
> the machine out of disk space?
>
>             regards, tom lane
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: explain analyze is your friend
>