From: Grega Bremec <gregab@p0f.net>
To: Lim Swee Nyin <snlim@taylori.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: No Space Left On Device
Date: Tue, 21 Jun 2005 12:13:44 +0200
Message-ID: <42B7E858.4000802@p0f.net> (raw)
In-Reply-To: <057c01c5726b$6ae16270$5800a8c0@taylori.com>
References: <057c01c5726b$6ae16270$5800a8c0@taylori.com>
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Lim Swee Nyin wrote:
| 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.
Hello, Lim.
You're not telling much, apart from the amount of disk space dfspace
reports. What we'd need to know to be able to (start to) help you is at
least the following things:
~ - What operating system is that (i *assume* SCO OpenServer)?
~ - What filesystem?
~ - Does the filesystem support any kinds of special features that could
~ make it possible for a situation like that to take place?
| I should have more than enough disk space on my system:
|
| $ dfspace
| / : Disk space: 15775.57 MB of 21868.99 MB available (72.14%)
The first thought that occurred to me was the percentage of disk space
that is considered by the system to be reserved for the super-user, and
given that this is your root filesystem, it _may_ well have been
predominantly allocated to the super-user, as you have /home, /tmp and
/var/tmp mounted on other filesystems.
Also, I don't know how quota reports excess to user processes on
OpenServer, if that's the case you're running. Might even look like
running out of space.
But then again, it may be something completely different. :)
Hope this helps.
Kind regards,
- --
Grega Bremec
gregab at p0f dot net
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)
iD8DBQFCt+hYfu4IwuB3+XoRAveFAJ4mBHPHjFeTq2Nj1A0aHhG38VhBMgCfU+RW
OgFvrUlf7TLpnN2lHWFSRQQ=
=tbul
-----END PGP SIGNATURE-----
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: gregab@p0f.net, snlim@taylori.com
Subject: Re: No Space Left On Device
In-Reply-To: <42B7E858.4000802@p0f.net>
References: <057c01c5726b$6ae16270$5800a8c0@taylori.com> <42B7E858.4000802@p0f.net>
* 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