From: | "David D" <dzavizd(at)hotmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | ERROR:cannot read block 9053 of mots |
Date: | 2001-02-02 14:44:04 |
Message-ID: | F95DTM9wGmAf0Mjkatw00001ade@hotmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
hi,i'm sorry but
i don't speak english...but i have a problem:
ERROR:cannot read block 9053 of mots
i do:
$ vacuumdb -v --table 'mots' moteur
NOTICE: --Relation mots--
ERROR: cannot read block 9053 of mots
vacuumdb: database vacuum failed on moteur.
so..
moteur=> VACUUM
moteur-> ;
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
We have lost the connection to the backend, so further processing is
impossible.
Terminating.
so..
postgres stop
postgres start
moteur=> vacuum;
NOTICE: CreatePortal: portal <vacuum> already exists
ERROR: Can't create lock file. Is another vacuum cleaner running?
If not, you may remove the pg_vlock file in the
/usr/local/pgsql/data/base/moteur
directory
rm pg_vlock
moteur=> vacuum verbose mots;
NOTICE: CreatePortal: portal <vacuum> already exists
NOTICE: --Relation mots--
ERROR: cannot read block 9053 of mots
i don't know who command or util. to use for these pb
it's a hard pb ?
and if exist a french-list-site for postgres help ?????
thank you
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
From | Date | Subject | |
---|---|---|---|
Next Message | Gyula Toth | 2001-02-02 15:11:19 | "Sorry too many clients" error and vacuum command |
Previous Message | Gianluigi Roveda | 2001-02-02 12:19:11 | hello |