From: Tom Arthurs <tarthurs@jobflash.com>
To: Bruno G. Albuquerque <balbuquerque@dba.com.br>
Cc: pgsql-admin@postgresql.org
Subject: Re: Indexes getting corrupted.
Date: Wed, 08 Jun 2005 11:58:31 -0700
Message-ID: <42A73FD7.40705@jobflash.com> (raw)
In-Reply-To: <42A73B60.7010909@dba.com.br>
References: <42A73B60.7010909@dba.com.br>
Reindexdb in contrib should help with rebuilding indexes.
Bruno G. Albuquerque wrote:
>
> I am having a weird problem here. I have the automated process to
> install PostgreSQL (8.0.1) on Windows 2000 machines. Besides installing
> the database server itself, my process does the following:
>
> 1 - Runs initdb to created the database I will be using.
> 2 - Runs a SQL script that creates the entire database and populates
> some of the tables.
> 3 - Runs another script that populates other tables (using COPY).
>
> What happens is that, sometimes, after the entire process run, I end up
> with a database with virtually all indexes corrupt! Try to use the
> indexes for anything results in "index is not a btree" error. This
> happens randomly and I can get it fixed sometimes by simply erasin
> everything and starting over.
>
> It happened in more thna one machine, if that matters. Also, changing
> the database from one partition to another almost all the time solves it
> (all machines have 2 partitions).
>
> Any ideas about what can be causing this? Manually doing "reindex index"
> gets the indexes sorted. Is there a way to automatically reindex all
> indexes in one go? that would at least help me a bit.
>
> Thanks in advance.
>
> -Bruno
>
> **********************************************************************
> Informação transmitida destina-se apenas à pessoa a quem foi endereçada
> e pode conter informação confidencial, legalmente protegida e para
> conhecimento exclusivo do destinatário. Se o leitor desta advertência
> não for o seu destinatário, fica ciente de que sua leitura, divulgação
> ou cópia é estritamente proibida. Caso a mensagem tenha sido recebida
> por engano, favor comunicar ao remetente e apagar o texto de qualquer
> computador.
>
>
> The information transmitted is intended only for the person or entity to
> which it is addressed and may contain confidential and/or privileged
> material. Any review, retransmission, dissemination or other use of, or
> taking of any action in reliance upon this information, by person or
> entity other than the intended recipient is prohibited. If you received
> this in error, please contact the sender and delete the material from
> any computer.
> **********************************************************************
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: tarthurs@jobflash.com, balbuquerque@dba.com.br
Subject: Re: Indexes getting corrupted.
In-Reply-To: <42A73FD7.40705@jobflash.com>
References: <42A73B60.7010909@dba.com.br> <42A73FD7.40705@jobflash.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox