cannot vacuum a database ! - Mailing list pgsql-bugs

From Ange Michel POZZO
Subject cannot vacuum a database !
Date
Msg-id 00082910370001.03011@ange.alpinfo.fr
Whole thread Raw
Responses Re: [GENERAL] cannot vacuum a database !  (The Hermit Hacker <scrappy@hub.org>)
List 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 by date:

Previous
From: pgsql-bugs@postgresql.org
Date:
Subject: JDBC: allow update of Date-Columns with NULL
Next
From: The Hermit Hacker
Date:
Subject: Re: [GENERAL] cannot vacuum a database !