Reindexing corrupts my database

Steve Albin steve at steve-albin.com
Thu Feb 5 16:10:34 CST 2009


My app is using V4RB 3.52.  I have one user with a database that shows a problem on one field in the diagnose.   The error message in the diagnose report is:

PAGE (276, 275) Corrupted Header (Values Count). Corrupted Header (Values count < RecID count). At least one value counter is wrong. 
 
I've tried cloning and  dumping to XML without success.  As a last resort, I wrote my own utility that dumps all the tables out to text files and I write the database out from those while deleting  any records with invalid ids.  (Not recids - those are all recreated during the load.) 

This has met with some success.  After reloading the database and running the diagnose, no problems are reported.  But, if I then reindex the database, the original error will occur in the diagnose.  In other words, all is fine until I reindex.  After the reindex, some SQL queries report incorrect results.

I have 2 questions:

1) What does this error message in the diagnose mean?

2) Is there anything I can do to fix this data.  If I had a clue as to what the diagnose is complaining about, I could try to fix it.

No other users have had this problem, so I think it maybe something related to data this user has entered. Maybe a problem with languages? Diacritical characters?   I don't know...


Upgrading from V4RB 3.52 is not a solution for me at this time.  I need to do something immediately to fix this data and it can't wait until I upgrade my app to use V4RB 4.  

-- 
Steve Albin - Montclair, NJ
http://www.jazzdiscography.com/
http://www.steve-albin.com/


More information about the Valentina mailing list