Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Intermittent error 1705 on CREATE TABLE
Message
De
10/03/2014 13:31:41
 
 
À
10/03/2014 10:01:00
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01595953
Message ID:
01596032
Vues:
65
>>Definitely not file name collision because there's a strict naming convention for these files that includes a primary key value as part of the file name. And there's now code that ensures that if a file of the same name exists, we close it and delete it before creating.
>
>Just thinking... if there's a previously existing file, its deletion is actually passed to the OS, which may execute it in a separate thread. I've seen (long ago, on a slower machine) situations when the previous file would still exist at the time the new one was created - and when debugging it was impossible to re-create,simply because debugging give the other thread the time to complete its task.
>
>To check this, check in the logs if deletion is related to the error. I seem to remember that in such a case I wrote a loop where I'd try to fcreate() the file, and sleep a dozen milliseconds until it succeeded. Then I'd just fclose() the handle and go on.
>
>Note that "seem to remember" does not guarantee that my context is the same as yours.

Interesting theory. Easy enough to implement, if none of the other possilbities pans out.

Tamar
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform