X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C5A195292A for ; Tue, 21 Jun 2005 07:15:08 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 22535-01 for ; Tue, 21 Jun 2005 10:14:57 +0000 (GMT) Received: from p0f.net (p0f.net [193.77.154.190]) by svr1.postgresql.org (Postfix) with ESMTP id E6D2F52914 for ; Tue, 21 Jun 2005 07:14:55 -0300 (ADT) Received: from [10.10.105.30] ([193.77.165.58]) (authenticated bits=0) by p0f.net (8.13.3/8.13.3) with ESMTP id j5LA3lUZ031203 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Tue, 21 Jun 2005 12:03:50 +0200 Message-ID: <42B7E858.4000802@p0f.net> Date: Tue, 21 Jun 2005 12:13:44 +0200 From: Grega Bremec Organization: P0F User-Agent: Mozilla Thunderbird 1.0.2 (X11/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Lim Swee Nyin Cc: pgsql-admin@postgresql.org Subject: Re: No Space Left On Device References: <057c01c5726b$6ae16270$5800a8c0@taylori.com> In-Reply-To: <057c01c5726b$6ae16270$5800a8c0@taylori.com> X-Enigmail-Version: 0.91.0.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.406 tagged_above=0 required=5 tests=AWL, RCVD_IN_NJABL_DUL X-Spam-Level: * X-Archive-Number: 200506/156 X-Sequence-Number: 17911 -----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-----