Re: [GENERAL] cannot vacuum a database ! - Mailing list pgsql-bugs

try 'vacuum verbose;' ... if that doesn't work, try doing a pg_dump/reload
... and, above all ... upgrade to v7.x as soon as possible ...

On Tue, 29 Aug 2000, Ange Michel POZZO wrote:

> 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/
>
> ******************************************************************************
>

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org