Обсуждение: No Space Left On Device

Поиск
Список
Период
Сортировка

No Space Left On Device

От
"Lim Swee Nyin"
Дата:
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

Re: No Space Left On Device

От
Grega Bremec
Дата:
-----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-----