cannot vacuum a database !

From: Ange Michel POZZO <poange(at)technologist(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: cannot vacuum a database !
Date: 2000-08-29 08:23:55
Message-ID: 00082910370001.03011@ange.alpinfo.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-general

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/

******************************************************************************

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message pgsql-bugs 2000-08-29 08:44:10 JDBC: allow update of Date-Columns with NULL
Previous Message Tom Lane 2000-08-28 20:39:02 Re: foreign_key regression test fails on Solaris 2.6

Browse pgsql-general by date

  From Date Subject
Next Message Fabrice Scemama 2000-08-29 11:05:29 Re: Microsoft Access
Previous Message Nils Zonneveld 2000-08-29 06:21:46 Re: PG 7.0.2 Install