pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Lim Swee Nyin <snlim@taylori.com>
To: pgsql-admin@postgresql.org
Subject: No Space Left On Device
Date: Thu, 16 Jun 2005 20:03:32 +0800
Message-ID: <057c01c5726b$6ae16270$5800a8c0@taylori.com> (raw)

hi There,

When I was fine tuning my already running application, all of the sudden, I couldn't perform any save/edit operation on my database, with the error such as:

ERROR: could not extend relation 4273000/17231/926549: No space left on device SQL = update call set personal=1 where rowid=8735 

I tried to update/insert several other tables but the more or less the same message appear. 

I should have more than enough disk space on my system:

$ dfspace
/                   : Disk space: 15775.57 MB of 21868.99 MB available (72.14%)
/stand              : Disk space:    34.51 MB of    39.99 MB available (86.28%)
/home               : Disk space: 13258.27 MB of 15000.00 MB available (88.39%)
/tmp                : Disk space:  1023.92 MB of  1024.00 MB available (99.99%)
/var/tmp            : Disk space:  1023.92 MB of  1024.00 MB available (99.99%)

where my postgres DB is on "/". and the strange thing is, the databas have been running fine for about 4 months.

can any one help please?

Thanks a lot.

Lim

view thread (9+ messages)  latest in thread

Message-ID: <057c01c5726b$6ae16270$5800a8c0@taylori.com>
Permalink:  ../057c01c5726b$6ae16270$5800a8c0@taylori.com/
Also on:    postgresql.org/message-id/057c01c5726b$6ae16270$5800a8c0@taylori.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: snlim@taylori.com
  Subject: Re: No Space Left On Device
  In-Reply-To: <057c01c5726b$6ae16270$5800a8c0@taylori.com>
  References: <057c01c5726b$6ae16270$5800a8c0@taylori.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox