Should I fix something after disk full error

Started by Andrusover 20 years ago2 messagesgeneral
Jump to latest
#1Andrus
eetasoft@online.ee

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.

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Andrus (#1)
Re: Should I fix something after disk full error

"Andrus" <eetasoft@online.ee> writes:

I'm using 8.1 on XP.
Server disk becomes full during running ANALYSE command.
...
Should I fix something or can I continue to use this cluster normally ?

Everything should be OK once you clean off some disk space.
Let us know if you see any evidence that it's not.

regards, tom lane