Re: No Space Left On Device

Поиск
Список
Период
Сортировка
От Grega Bremec
Тема Re: No Space Left On Device
Дата
Msg-id 42B7E858.4000802@p0f.net
обсуждение исходный текст
Ответ на No Space Left On Device  ("Lim Swee Nyin" <snlim@taylori.com>)
Список pgsql-admin
-----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-----

В списке pgsql-admin по дате отправления:

Предыдущее
От: gayatri ganpaa
Дата:
Сообщение: varying pagesize in postgresql
Следующее
От: "sandhya"
Дата:
Сообщение: reg:postgresql library