Re: [GENERAL] cannot vacuum a database !

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(at)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(at)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(at)alpinfo(dot)fr
> Administrateur - Dveloppeur
> 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 franais du commerce lectronique
>
> - Plusieurs centaines de magasins rfrencs pour tous vos achats
> sur internet, tous avec paiements scuriss en ligne
> - Des promotions proposes par les boutiques
> - Vente aux enchres, forum de discussion
> - Des actualits, sports et loisirs, cinma, horoscope ...
> - Les iddes 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(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org