Re: Oncheck - error
Katarina,
Bugs 40209 and 42264 could be likely possibilities.
On bug 42264 - If a table has multiple extents in the same physical chunk,
Informix can't build a vaild index. This was on rev 7.10.UC3. It was
fixed in 7.10.UC4 and 7.11.UD1. Create Index and Oncheck -cI (which
builds a new copy of the index for comparison to the original) could not
build valid indexes. If you want to build indexes you can not have
multiple extents of the table in the same physical chunk.
Upgrading to 7.23 (latest available) or 7.24 sounds reasonable. There are
certainly alot fewer bugs.
Steve Berg
spb@nb.com
On Wed, 8 Oct 1997, Katarina Hamzova wrote:
} Informix On line DSA V 7.10
} RM 600 (OS Sinix 5.42)
}
} we got unpleasant error message while running
} oncheck -cI
} ...
} Index xpkp01_po
} ERROR:Rowid mismatch between data row and btree item
} Rowid 0x9a005 contains key value:
} Key: "11 ":1:2:
} Btree item contains rowid 0xc2b01, key value:
} Key: "11 ":1:3:
} Index xif380p11_zaisteni
}
} ERROR:Rowid mismatch between data row and btree item
} Rowid 0x9b0d contains key value:
} Key: "11 ":"bol ":
} Btree item contains rowid 0x9b0e, key value:
} Key: "11 ":"bol ":
} Index xif506p11_zaisteni
} ...
} indexes were unrepairable so we have decided to recreate the whole
} database (using : unload,drop,create,load ....)
} System was runing without any problems for a week and today it has appeared
} again on different indexes. We do not use fragmented or detached
} indexes .
}
} I would appreciate any hints or ideas
}
} katarina
}
} PS: I have heard that 7.10 release is full of index bugs
} and upgrade to 7.23 was recommended. It makes me confused because
} 7.10 is running with the same amount of data
} aprox. 10 months without any problems with indexes
} --
} Katarina Hamzova Voice : +42 7 5384324
} SWH s.r.o Bratislava
} Slovakia
} Internet : Katarina.Hamzova@swh.sk
}
}