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:
00182617
Views:
9
>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

You may SET REPROCESS TO AUTOMATIC and check for FLOCK() return value, and situation is not deadlocked at least. Also, it's really rare case when explicit FLOCK() is really needed.
Edward Pikman
Independent Consultant
Previous
Reply
Map
View

Click here to load this message in the networking platform