Cannot delete value from index

foosh101 · Post by **foosh101** » Thu May 01, 2003 9:29 am

I get the following sometimes when I try to either remove a record from a table or drop the entire table:












The records seem to be deleted fine, I just get these messages occasionally. What do they mean?

Post by **John** » Thu May 01, 2003 9:46 am

They indicate that Texis could not find the key in the index when it tried to delete the pointer to the record from the index. You may want to rebuild the index in question to make sure it accurately reflects the table.

james120 · Post by **james120** » Tue Sep 14, 2004 11:25 am

Just wanted to mention that I just got the same error, and this was an absolutely brand-new index, and the data had not been changed afterwards at all. If John's explanation is correct, it worries me a little that the index is missing random entries for some reason. Is there anything that can be done to double-check this sort of thing?

Post by **John** » Wed Sep 15, 2004 11:07 am

Yes, you can run

monitor -c dbverify -d DATABASE -i INDEXNAME -v

to check an index, which will double check that every value in the index is in the table, and vice versa.