Re: Indexes getting corrupted. - Mailing list pgsql-admin

From Bruno G. Albuquerque
Subject Re: Indexes getting corrupted.
Date
Msg-id 42B17C9C.5030506@dba.com.br
Whole thread Raw
In response to Re: Indexes getting corrupted.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tom Lane wrote:
>>I'm suspicious of a more subtle intermittent error.
>
> Yeah, I am too, but so far none of the reporters have been cooperative
> about providing more information :-(

Well, at least from me, I can tell you I gave all information I came up
with. One thing that I pointed out is this (Windows 2000):

When you shutdown the machine just after you run my customized
installation procedure and you check the log after rebooting, you will
notice that only the first message (saying that a fast shutdown request
was received) will be in the log. The other messages that mention the
shutdown process completed succesfully do not appear. If I check the
database, the indexes *WILL* be corrupt.

I solved it by automatically stopping the server after the installation
precedure concludes. This solves this problem and, even after rebooting,
the indexes seems to be ok.

> I think the proposed patch is a waste of time.  What I am hoping to get
> from people is a dump of the whole first page of the corrupted index
> (via pg_filedump, or even good ol' od).  That might give us some idea of
> what we are dealing with --- localized corruption in a basically good
> metapage, or wholesale replacement of the page with some other page (and
> if so what), or maybe it is a hardware fault after all.  You can't draw
> those sorts of conclusions from one or two words, but with a whole page
> to look at you have a shot at telling the difference.

I can try to revert my changes to get the problem to happen again. Just
tell me what exactly you need me to do. Also, this problem happened on
*SEVERAL* machines with different configurations. Actually, it happened
with all machines I tried and the "fix" I implemented (as mentioned
above) worked on all of them too.

-Bruno

**********************************************************************
Informação transmitida destina-se apenas à pessoa a quem foi endereçada e pode conter informação confidencial,
legalmenteprotegida 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
recebidapor 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
confidentialand/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any
actionin reliance upon this information, by person or entity other than the intended recipient is prohibited. If you
receivedthis in error, please contact the sender and delete the material from any computer. 
**********************************************************************

pgsql-admin by date:

Previous
From: Din Adrian
Date:
Subject: Re: [SQL] PostgreSQL and Delphi 6
Next
From: grupos
Date:
Subject: Re: [SQL] PostgreSQL and Delphi 6