Skip site navigation (1) Skip section navigation (2)

No space left on device.

From: "Chad Thompson" <chad(at)weblinkservices(dot)com>
To: "pgsql-novice" <pgsql-novice(at)postgresql(dot)org>
Subject: No space left on device.
Date: 2002-08-16 17:47:06
Message-ID: 032501c2454c$f1285ae0$32021aac@chad (view raw or flat)
Thread:
Lists: pgsql-novice
I have recieved a very weird error when running the following query.

select l.id, l.full_phone into "8_15_2002_NeverquitPushOneMessaging" 
from list_tz l, call_results cr 
where client_id = 8 
and ((cr.result = 'Busy') or (cr.result = 'Busy-Reorder') or (cr.result = 'Busy-Timeout') or (cr.result = 'No Signal') or (cr.result = 'No Circuit Signal') or (cr.result = 'No Answer') or (cr.result = 'No Solicitation')) 
and cr.calldate between '6/4/2002'  and '8/14/2002';

call_results is a table with just over 1 million lines, list_tz is a temp table created in another function w/ anywhere from 10 to 50 K lines.

here is the error

cannot extend 8_15_2002_NeverquitPushOneMessa: no space left on device
        check free disk space.

I have checked the archives and it gave me an indication that my sql might be wrong, but i cant figure out what.  I have also tried the query using IN (eg. and cr.result in('busy',busy-reorder....))

Here is my system info

Im running redhat 7.2
df says
Filesystem           1k-blocks      Used Available Use% Mounted on
/dev/hda1             19188368   2960536  15253092  17% /
none                    385340         0    385340   0% /dev/shm

select version();
                          version
-----------------------------------------------------------
 PostgreSQL 7.2 on i686-pc-linux-gnu, compiled by GCC 2.96
(1 row)


I have installed postgresql with just the default settings.  

Any help would be appreciated
TIA
Chad

Responses

pgsql-novice by date

Next:From: douggorleyDate: 2002-08-16 18:07:51
Subject: Re: Is my database done for?
Previous:From: Chad ThompsonDate: 2002-08-16 16:52:53
Subject: Re: BLOBs

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group