index xyz is not a btree

Поиск
Список
Период
Сортировка
От David Parker
Тема index xyz is not a btree
Дата
Msg-id 07FDEE0ED7455A48AC42AC2070EDFF7C746FD5@corpsrv2.tazznetworks.com
обсуждение исходный текст
Ответы Re: index xyz is not a btree  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
We are getting the "index xyz is not a btree" error pretty frequently in our build system (in which we build several databases). This is with 8.0.1 on Solaris 9/intel. During a database build we create the database, import metadata, import some application data, then finally run a vacuum on it.
 
The error only happens intermittently, but every occurrence is consistent:
 
    1) always the same index - "attribute_pkey" on our "attirbute" table - one created implicitly by a primary key constraint
    2) the error happens during a vacuum command
 
From what I have found in the archives the consensus is that this error comes from a bad disk or a bad build of postgres, but I don't know what exactly I would have to screw up in configure to get a "bad build" of postgres (everything seems to be working fine with it, otherwise).
 
When this occurs we can generally just re-run the build, and it finishes fine, so maybe it is some kind of disk weirdness, but I have not seen this with any of our 7.4.5 builds (which may or may not mean anything....)
 
Any suggestions about where to look in the source code for clues or specific debugging I can turn on would be appreciated. Thanks!

- DAP
----------------------------------------------------------------------------------
David Parker    Tazz Networks    (401) 709-5130
 

 

В списке pgsql-general по дате отправления:

Предыдущее
От: Russ Brown
Дата:
Сообщение: Re: Version Control?
Следующее
От: Tino Wildenhain
Дата:
Сообщение: Re: Wrong select results after transaction (HELP PLS)