Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index corrupted
Message
From
09/06/2021 07:08:03
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
01681084
Message ID:
01681085
Views:
59
>I have a customer where the cdx file continues to be corrupted.... I rebuild indexes (i use for this operation an old version of Stonefield Database Toolkit) and after a few time (even 3 times in same morning) i have to rebuild it..... Table's size is 450Mb and in the cdx files i have 35 tags. We works in rdp session on a server with Windows Server 2012 R2 and 32Gb ram. (this is a phisical machine). The users are using my app are from 6 to 10 and this is the table that probably is used by all the users (both for write and read access)......... Someone has had similar problems ? Some suggests.... This customer uses my app since 2005 and we never have had this problem and the table thta now has problems was in some periods larger (near foxpro limits) and we have moved data to another table....

I almost suggested to check for SMB2 bug (upgraded to SMB3), because it's probably irrelevant whether two processes access the filesystem through network shares or by running in parallel on the same machine - it's the same filesystem. But then this bug is around for a dozen years (since the Vista? that's 2007...), so why would you have the problem now and not last year?

Soooo... I'm just mentioning this as something to check, but I don't think that's the cause. I'd rather check what was installed on the server around the time this started happening - what updates, which services are now running that weren't before, that kind of thing.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform