Обсуждение: ERROR:cannot read block 9053 of mots
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.
On Fri, Feb 02, 2001 at 03:44:04PM +0100, David D wrote: > hi,i'm sorry but > i don't speak english...but i have a problem: > > ERROR:cannot read block 9053 of mots We got simular errors from our database because of a disk-error. To verify, you can either: * Read the mots file directly, e.g. with "cat mots > /dev/null" (in database data-directory) * Read all files directly, e.g. with "cat * > /dev/null" (in database data-directory) * Check the whole partition with the /sbin/badblocks program -- Ragnar Kjørstad Zet.no