Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Intermittent error 1705 on CREATE TABLE
Message
From
10/03/2014 10:01:00
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
10/03/2014 08:15:59
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01595953
Message ID:
01596018
Views:
52
>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.

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