CDX currupt index file & Windows 2003 Server

836
pablomedok

We're experiencing almost everyday database index corruption on Windows Server 2003. I wonder if it can be somehow connected with caching or other server settings.

We are running an old application which uses DBF/CDX tables. Everything was fine for ages, but 6 months after we've installed Advantage Database Server (which allows access to some tables to our website) we started to get index corruption problems. And we don't know whom to blame. ADS returns an error: Error 7017: Corrupt .ADI, .CDX, or .IDX index. Table name: RBOOKM

We've tried to exclude all possible causes of this corruption. Now all users work in terminal mode - so no network problems can cause that, OpLocks also can't be a reason. We changed hardware, network cards, switches, reinstalled Server and even moved to new dedicated server. The only thing we can't exclude is ADS - because it should be working.

Is that possible that local read/write caching that causes that problem? E.g. one user or process uses cached data, later another user/process changes it, and later the first user changes it again without knowing about the first change. Is it possible theoretically?

Is it possible that this problem is caused by importer file server or caching settings? Is it possible that normal users use non-cached data and ADS is using cached data? Or vice versa? Is it possible that each terminal user has its own cache? Or maybe the problem is about RAID caching somehow interfering with Windows Server caching? Or maybe there are some special settings for Windows Server for working with DBF tables that are being written simultaneously by several terminal users? Maybe there is a way to turn off caching for some certain files to check it?

Sometimes we get index crash twice a day, sometimes everything is fine for 5 days in a row. But usually it crashes on daily basis. Today only one user was working in the evening with the database (usually there are 30-50 users are working simultaneously on working hours). So it's almost zero load on server. Synchronization with website is performed every 5 minutes during work hours and every 15 minutes in the evening and on weekend.

We've done file access auditing and it shows that during website synchronizations ADS server opens the table and index files for ReadEA and WriteEA though it performs only SELECT queries. ADS does UPDATE/INSERT queries but less frequently - not during regular synchronizations, but only when an order is placed by website visitor).

Please help me. We are struggling with this problem for almost a year and still can't find any pattern or any clue about this problem.

Here is my previous question about this issue on DBA: https://dba.stackexchange.com/questions/8646/foxpro-dbf-index-corruption

1
Einer meiner Kunden hat immer eine Indexbeschädigung für DBF / CDX-Tabellen erhalten. Es ist ein bekanntes Problem für den Verkäufer. Nur eine Migration zu SQL Server hat das Problem behoben. vor 12 Jahren 0
Danke, aber ich denke, dass es eine Lösung geben sollte, da wir selbst bei vielen Netzwerkbenutzern länger als 10 Jahre ohne Indexkorruption gelebt haben (okay, selten mit einmal im Monat). pablomedok vor 12 Jahren 0
Gestern habe ich nach einem weiteren Indexfehler die beschädigte Tabellendatei sowie deren Indexdatei gesichert. Und später entschied ich mich, die beschädigte Indexdatei zu überprüfen. Es stellte sich heraus, dass alles in Ordnung ist. Ich habe auch versucht, diese Datei mit der Datenbank zu verbinden, und es gelang mir auch. Ich könnte diese Datei öffnen und einen Datensatz hinzufügen. Es sieht also aus wie ein Nicht-Index-Problem, aber das Problem der Zugriffsverweigerung - unter bestimmten Umständen ist die Indexdatei aus irgendeinem Grund nicht mehr zugänglich. pablomedok vor 12 Jahren 1
Gute Fehlersuche! Teilen Sie uns mit, wenn Sie dem Problem näher kommen. vor 12 Jahren 0

0 Antworten auf die Frage