BUG #5947: Error while running query

Started by Raman Sharmaabout 15 years ago2 messagesbugs
Jump to latest
#1Raman Sharma
rsharma@10kinfo.com

The following bug has been logged online:

Bug reference: 5947
Logged by: Raman Sharma
Email address: rsharma@10kinfo.com
PostgreSQL version: 7.4
Operating system: Ubnato
Description: Error while running query
Details:

ERROR: could not extend relation "test_table": No space left on device
HINT: Check free disk space.

But i have 27 GB space in my disk where it loaded and running query

#2Bruce Momjian
bruce@momjian.us
In reply to: Raman Sharma (#1)
Re: BUG #5947: Error while running query

On Fri, Mar 25, 2011 at 9:47 AM, Raman Sharma <rsharma@10kinfo.com> wrote:

ERROR:  could not extend relation "test_table": No space left on device
HINT:  Check free disk space.

But i have 27 GB space in my disk where it loaded and running query

Have you checked df -i ?

Also, this may seem like a silly question but years of experience
motivate it.... are you sure your data is on the filesystem you're
checking?

Also, 7.4 is *ancient*. You really really want to be using something
more recent. I doubt it's relevant to why you're running out of space
though.

--
greg