again trouble

On Fri, 2002-07-12 at 08:27, Henrik Steffen wrote:

select * from zugriffsrechte;
ERROR: find_secondary_indexes: index 14958692 not fount

vacuum verbose analyze zugriffsrechte
ERROR: IndexSupportInitialize: no pg_index entry for index 14958692

tom, could this again be due to a broken SD-RAM chip?

Yep! Sounds like the problem I had last summer with bad RAM

Cheers

Tony Grant

--
RedHat Linux on Sony Vaio C1XD/S
http://www.animaproductions.com/linux2.html
Macromedia UltraDev with PostgreSQL
http://www.animaproductions.com/ultra.html

Hi,

my experience shows, that such random errors you seem to be suffering from
in postgres are always caused by malfunctioning hardware, be it ram or
harddisk.

I'd suggest to dump the database and put it on another clean server, or if
that is not possible, to change ram and harddisk.

In my case my gdt scsi raid controller seemed to cause bit errors on the
scsi bus, leading to strange behaviour of postgres, which was not logically
explainable. Changing the hdd-subsystem and reinserting the dump was the
solution.

Greetings,
Bjoern

----- Original Message -----
From: Henrik Steffen <steffen@city-map.de>
To: pg <pgsql-general@postgresql.org>
Sent: Friday, July 12, 2002 8:27 AM
Subject: [GENERAL] again trouble

hello all,

another morning, another problem:

select * from zugriffsrechte;
ERROR: find_secondary_indexes: index 14958692 not fount

vacuum verbose analyze zugriffsrechte
ERROR: IndexSupportInitialize: no pg_index entry for index 14958692

tom, could this again be due to a broken SD-RAM chip?

Mit freundlichem Gru�

Henrik Steffen
Gesch�ftsf�hrer

top concepts Internetmarketing GmbH
Am Steinkamp 7 - D-21684 Stade - Germany
--------------------------------------------------------
http://www.topconcepts.com Tel. +49 4141 991230
mail: steffen@topconcepts.com Fax. +49 4141 991233
--------------------------------------------------------
24h-Support Hotline: +49 1908 34697 (EUR 1.86/Min,topc)
--------------------------------------------------------
System-Partner gesucht: http://www.franchise.city-map.de
--------------------------------------------------------
Handelsregister: AG Stade HRB 5811 - UstId: DE 213645563
--------------------------------------------------------

I must suggest Memtest86 (http://www.memtest86.com). It is extrememly good
at picking up dodgy RAM, even if it's a single bit error that only occurs
under certain conditions.

On Fri, Jul 12, 2002 at 08:27:55AM +0200, Henrik Steffen wrote:

hello all,

another morning, another problem:

select * from zugriffsrechte;
ERROR: find_secondary_indexes: index 14958692 not fount

vacuum verbose analyze zugriffsrechte
ERROR: IndexSupportInitialize: no pg_index entry for index 14958692

tom, could this again be due to a broken SD-RAM chip?

--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/

"Henrik Steffen" <steffen@city-map.de> writes:

vacuum verbose analyze zugriffsrechte
ERROR: IndexSupportInitialize: no pg_index entry for index 14958692

tom, could this again be due to a broken SD-RAM chip?

Perhaps. It's certainly looking more and more like you've got some
kind of hardware problem ... Postgres is just not this flaky for most
people ;-).

If you wanted to dig into it, you could pg_filedump
pg_index_indrelid_index and look to see why it doesn't have an entry for
14958692. My bet is that the entry is indeed there, but is not being
found --- either its own key is corrupted, or some nearby keys are
corrupted in a way that renders them out-of-order, causing binary search
to conclude the desired key is not present. A single-bit error in the
key field would certainly suffice to cause such a problem.

regards, tom lane