Oncheck - error
Posted in 1997
Informix On line DSA V 7.10
RM 600 (OS Sinix 5.42)
we got unpleasant error message while running
oncheck -cI
...
Index xpkp01_poERROR: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