| From: | Bryan Henderson <bryanh(at)giraffe-data(dot)com> |
|---|---|
| To: | Postgresql mailing list <pgsql-general(at)postgresql(dot)org> |
| Subject: | No space left on device log message storm |
| Date: | 2011-07-05 01:40:07 |
| Message-ID: | 96203.bryanh@giraffe-data.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
When the filesystem containing my database fills up, the server repeats
the following log message about as fast as it can log:
Jun 29 23:00:55 src(at)giraffe postgres: LOG: could not write temporary statistics file "pg_stat_tmp/pgstat.tmp": No space left on device
Is this an infinite loop or the server just trying a lot of independent
temporary statistics file updates? This server handles about 5 transactions
per minute.
If it's an infinite loop, does anyone have a feeling whether it's recursive
(the act of logging the error stimulates another attempt) or iterative (the
server just can't take no for an answer)?
--
Bryan Henderson San Jose, California
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Yan Cheng CHEOK | 2011-07-05 06:50:53 | Difference between inet and cidr |
| Previous Message | David Johnston | 2011-07-05 01:23:00 | Re: Finding latest record for a number of groups in an INSERT-only table |