| From: | "Andrus" <eetasoft(at)online(dot)ee> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Should I fix something after disk full error |
| Date: | 2005-12-06 18:03:29 |
| Message-ID: | dn4jpu$k1v$1@news.hub.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I'm using 8.1 on XP.
Server disk becomes full during running ANALYSE command.
The following lines are in log file
2005-12-06 18:29:10 ERROR: duplicate key violates unique constraint
"pg_statistic_relid_att_index"
2005-12-06 18:30:23 LOG: autovacuum: processing database "postgres"
2005-12-06 18:31:18 ERROR: could not extend relation 1663/74856/2696: No
space left on device
2005-12-06 18:31:18 HINT: Check free disk space.
2005-12-06 18:31:29 WARNING: corrupted pgstat.stat file
2005-12-06 18:32:37 LOG: autovacuum: processing database "template1"
2005-12-06 18:32:39 LOG: could not close temporary statistics file
"global/pgstat.tmp": No space left on device
2005-12-06 18:32:40 LOG: could not close temporary statistics file
"global/pgstat.tmp": No space left on device
2005-12-06 18:33:42 LOG: autovacuum: processing database "template1"
2005-12-06 18:34:42 LOG: autovacuum: processing database "foo"
2005-12-06 18:35:53 LOG: autovacuum: processing database "bar"
2005-12-06 18:37:12 LOG: autovacuum: processing database "postgres"
2005-12-06 18:38:13 LOG: autovacuum: processing database "template1"
etc.
Should I fix something or can I continue to use this cluster normally ?
Andrus.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-12-06 18:15:41 | Re: Should I fix something after disk full error |
| Previous Message | Scott Marlowe | 2005-12-06 17:48:08 | Re: Memory Leakage Problem |