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.
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 |