pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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
> 
> 
> 



view thread (9+ messages)  latest in thread

Message-ID: <42A73FD7.40705@jobflash.com>
Permalink:  ../42A73FD7.40705@jobflash.com/
Also on:    postgresql.org/message-id/42A73FD7.40705@jobflash.com

 · 

reply

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