Re: HINT: Perhaps out of disk space? - Mailing list pgsql-general

From John Koller
Subject Re: HINT: Perhaps out of disk space?
Date
Msg-id pan.2005.12.24.23.26.05.404436@yahoo.com
Whole thread Raw
In response to HINT: Perhaps out of disk space?  (Michael Adler <adler@pobox.com>)
List 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@pobox.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.

pgsql-general by date:

Previous
From: "Qingqing Zhou"
Date:
Subject: Re: pg_reload_conf() does not unset archive_command
Next
From: "Qingqing Zhou"
Date:
Subject: SET SESSION TRANSACTION command