From: | Alex Hunsaker <badalex(at)gmail(dot)com> |
---|---|
To: | ibarg(at)noao(dot)edu |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: postgresql-server-8.4.4-1PGDG.el5 - ERROR: could not write block 503414 of temporary file: No space le,ft on device |
Date: | 2010-07-26 23:09:38 |
Message-ID: | AANLkTinH9+s1WFAu2k3NnbYpd3Zh=DdyTb5ZduTsxZh-@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Mon, Jul 26, 2010 at 16:01, Irene Barg <ibarg(at)noao(dot)edu> wrote:
>> 2010-07-26 11:33:33 MST system_admin metadataERROR: could not write block
>> 503414 of temporary file: No space le
>> ft on device
>> 2010-07-26 11:33:33 MST system_admin metadataHINT: Perhaps out of disk
>> space?
>> -bash-3.2$ df -h
>> Filesystem Size Used Avail Use% Mounted on
>> /dev/sda3 16G 13G 1.7G 89% /
>> /dev/sda8 635G 979M 601G 1% /data0
>> /dev/sda7 2.0G 241M 1.7G 13% /home
>> /dev/sda5 7.8G 1.5G 5.9G 20% /u1
>> /dev/sda2 16G 184M 15G 2% /var/log
>> /dev/sda1 487M 22M 440M 5% /boot
>> tmpfs 12G 0 12G 0% /dev/shm
>> /dev/md0 2.7T 202M 2.6T 1% /data1
>
>
> The pg_stat_tmp is hardly growing::
>
>> -bash-3.2$ date
>> Mon Jul 26 14:37:38 MST 2010
>> -bash-3.2$ pwd
>> /var/lib/pgsql/data
Ok so it looks like this is on your / (sda3) partition that only has
1.7G free. Its entirely possible that you have some query that needs
to write more than that in tmp files.
>> -bash-3.2$ du -ks pg_stat_tmp/*
No surprise that is not growing, thats not for temp files, its for the
stats collector.
I would try turning on log_temp_files, that might help pin point the
problem query.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2010-07-27 01:33:52 | Re: postgresql-server-8.4.4-1PGDG.el5 - ERROR: could not write block 503414 of temporary file: No space le, ft on device |
Previous Message | Irene Barg | 2010-07-26 22:01:44 | postgresql-server-8.4.4-1PGDG.el5 - ERROR: could not write block 503414 of temporary file: No space le,ft on device |