cannot vacuum a database !
От | Ange Michel POZZO |
---|---|
Тема | cannot vacuum a database ! |
Дата | |
Msg-id | 00082910370001.03011@ange.alpinfo.fr обсуждение исходный текст |
Ответы |
Re: [GENERAL] cannot vacuum a database !
|
Список | pgsql-bugs |
hi all, i use [PostgreSQL 6.5.2 on i686-pc-linux-gnu, compiled by gcc 2.95.2] on a linux mandrake 7.0 after i have drop some tables and index i don't use, i c'ant do a vacuum on the database. here is the error : [me@www me]$ psql mydb -u Username: postgres Password: Welcome to the POSTGRESQL interactive sql monitor: Please read the file COPYRIGHT for copyright terms of POSTGRESQL [PostgreSQL 6.5.2 on i686-pc-linux-gnu, compiled by gcc 2.95.2] type \? for help on slash commands type \q to quit type \g or terminate with semicolon to execute query You are currently connected to the database: mydb mydb=> vacuum ; NOTICE: Index pg_proc_prosrc_index: NUMBER OF INDEX' TUPLES (1021) IS NOT THE SAME AS HEAP' (1022) 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. [me@www me]$ ... mydb=> \d pg_proc_prosrc_index Table = pg_proc_prosrc_index +----------------------------------+----------------------------------+-------+ | Field | Type | Length| +----------------------------------+----------------------------------+-------+ | prosrc | text | var | +----------------------------------+----------------------------------+-------+ mydb=> what should i do now ? is my database corrupt ? any idea ? thanks for any help ! ANGE -- ****************************************************************************** POZZO Ange Michel mail : ange@alpinfo.fr Administrateur - D�veloppeur ALPINFO 617 Rue Denis Papin 73290 La Motte Servolex Savoie - France tel : 04 79 26 06 28 fax : 04 79 25 68 36 Zonecommerce, l'annuaire fran�ais du commerce �lectronique - Plusieurs centaines de magasins r�f�renc�s pour tous vos achats sur internet, tous avec paiements s�curis�s en ligne - Des promotions propos�es par les boutiques - Vente aux ench�res, forum de discussion - Des actualit�s, sports et loisirs, cin�ma, horoscope ... - Les idd�es d'olivia, le site du mois, l'interview - Des liens, des conseils ... http://www.zonecommerce.com/ ******************************************************************************
В списке pgsql-bugs по дате отправления: