Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Deadly Embrace, is it a problem?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00182606
Message ID:
00182616
Views:
9
Yes, it's a potential problem. The server will clear the lock eventually after one of the applications has been shut down forcibly. The best solutions is not to use SET REPROC TO -1. It's generally a bad idea unless you know that this situation will never happen. It's better to try your lock for some amount of time, then unlock everything and inform the user that the operation couldn't be completed.

>I am seeking information on the possibility of a deadly-embrace situation occuring with SET REPORTESS TO -1.
>
>For example, user 1 locks files A then B. User 2 attempts to lock B then A at the same instant. The first lock executed by each user succeeds and flock() returns. When trying to lock the second file, the lock does not succeed because A and B are both locked.
>
>Is this a problem with VFP? If not, why not? Does the lock manager on the server account for this possibility, or is it just a very high statistical improbability? If it is a problem, what are some solutuions?
>
>Thanks, Dennis Hevener
Previous
Reply
Map
View

Click here to load this message in the networking platform