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(at)clickspace(dot)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(at)clickspace(dot)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
>