At 05:46 PM 5/28/2002 -0700, William Mason wrote:
We have begun to encounter REPEATED index corruptions, resulting in a
scenario in which rows seem to both exist and not exist at the same time.
William,
Remember, things just don't happen automatically nor do rows
disappear without a possible cause.
There are thousands of installations out there running their mission
critical operations, 24x7x365 using R:BASE.
When was the last time that database maintenance such as RELOAD
or PACK INDEX were performed on your database?
I would also suggest, to spare some of your precious time to narrow
down the possible cause, that you compare data as well as monitor
data input.
For complete details on "Finding and Fixing Broken Pointers/Indexes",
check out the technical document at:
From The Edge: http://www.razzak.com/fte
Choose "General Topics" from the drop-down list and then select
"Finding and Fixing Broken Indexes".
The PDF version of this document includes the following:
A. Definitions
B. How R:BASE Finds the Data
C. Common Causes for Broken Pointers/Indexes
D. Diagnosis (Signs and Symptoms)
E. Warning and Common Messages
F. Steps to Repair
G. Suggestions
Good Luck!
Very Best Regards,
Razzak.
