St?phane Konstantaropoulos wrote: >It'd be nice if it noticed by itself that the db is corrupted. > Unfortunately that's something of an AI problem :( There is some code in the server that can compare the results of an indexed vs an unindexed execution of the same query (used in the past to debug query optimizations). Someone could develop that into a kind of index inconsistency tool. All out corruption (someone writes random c**p over the database pages _will_ be detected). It sounds like you had some inconsistency between the primary and secondary indices. I'm not sure how that could have happened (it shouldn't). >I also tried to >delete all the indexes and then re-create them, which it did but that made no >difference. > >
