Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Deadly Embrace, is it a problem?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00182606
Message ID:
00182616
Vues:
10
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform