Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] cannot vacuum a database !

From: The Hermit Hacker <scrappy(at)hub(dot)org>
To: Ange Michel POZZO <poange(at)technologist(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, pgsql-bugs(at)postgresql(dot)org
Subject: Re: [GENERAL] cannot vacuum a database !
Date: 2000-08-29 12:05:25
Message-ID: Pine.BSF.4.21.0008290904320.564-100000@thelab.hub.org (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-general
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 


In response to

Responses

pgsql-bugs by date

Next:From: Ange Michel POZZODate: 2000-08-29 16:11:24
Subject: Re: Re: [GENERAL] cannot vacuum a database !
Previous:From: pgsql-bugsDate: 2000-08-29 08:44:10
Subject: JDBC: allow update of Date-Columns with NULL

pgsql-general by date

Next:From: Matthew KennedyDate: 2000-08-29 14:15:07
Subject: Ignore when using COPY FROM
Previous:From: Fabrice ScemamaDate: 2000-08-29 11:05:29
Subject: Re: Microsoft Access

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group