Re: HINT: Perhaps out of disk space?

From: John Koller <johnckoller(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: HINT: Perhaps out of disk space?
Date: 2005-12-24 23:26:11
Message-ID: pan.2005.12.24.23.26.05.404436@yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, 23 Dec 2005 13:42:13 -0500, Michael Adler wrote:

> On Fri, Dec 23, 2005 at 11:36:54AM -0500, Tom Lane wrote:
>> Michael Adler <adler(at)pobox(dot)com> writes:
>> > I'm investigating a problem that happened last night and I would
>> > appreciate any recommendations. The logs indicate that the disks were
>> > full, but I truly doubt that since we only use about 14GB out of the
>> > available 65GB.
>>
>> > I found entries like this in the logs:
>>
>> > ERROR: could not write block 2354 of temporary file: No space left on device
>> > HINT: Perhaps out of disk space?
>> > ....
>> > ERROR: could not extend relation "parent_table": No space left on device
>> > HINT: Check free disk space.
>> > ....
>> > LOG: could not close temporary statistics file "/var/lib/postgres/data/global/pgstat.tmp.1464": No space left on device
>>
>> > According to the logs, the problem went away after a reboot. I wonder
>> > if the kernel or the RAID device got confused and postgres was simply
>> > echoing what it was told. We run a couple hundred postgres servers and
>> > we have not seen this before (except when the disks truly were full).
> I really appreciate any guidance you could offer.
>

Are there any errors about running out of shared memory? I have seen the
"No space left on device" error for that on FreeBSD before.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andy Astor 2005-12-25 04:29:08 Happy Holidays
Previous Message fvalenzuelaf 2005-12-24 23:20:16 Re: [webmaster] database