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@xxxxxxxxxxxxxx
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@xxxxxxxxxxxxxx> 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
