Multiple users can lock an object #34

Closed
hisystems opened this Issue Mar 13, 2012 · 0 comments

Projects

None yet

1 participant

@hisystems
Owner

Multiple users can incorrectly lock the same object. Instead any attempts by another user to perform a lock on an already locked object should fail.

@hisystems hisystems was assigned Mar 13, 2012
@hisystems hisystems added a commit that closed this issue Mar 21, 2012
@hisystems Corrected multiple users locking the same object. Closes #34.
The locking is achieved by attempt to insert into the lock table which contains a unique index. It the insert fails then the record is already locked because the insert breaks the database table's key constraint. However, the UserID was incorrectly included in the unique index / key which meant that attempts by multiple users to insert into the table would not fail.
6493d44
@hisystems hisystems closed this in 6493d44 Mar 21, 2012
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment