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