EPrints Technical Mailing List Archive

See the EPrints wiki for instructions on how to join this mailing list and related information.

Message: #00064

< Previous (by date) | Next (by date) > | < Previous (in thread) | Next (in thread) > | Messages - Most Recent First | Threads - Most Recent First

[EP-tech] Re: Query about record locking in EPrints?

Record locking was introduced in 3.2 if I recall correctly. It's done at the eprint level by the application not down at the MySQL level.  You should be able to see this in action by editing a record and then viewing the item control page with another account. There will a statement about it being locked at the top of the page.

Cheers
Mark

________________________________________
From: eprints-tech-bounces@ecs.soton.ac.uk [eprints-tech-bounces@ecs.soton.ac.uk] On Behalf Of Alex Birchall [A.Birchall@mdx.ac.uk]
Sent: Friday, 2 March 2012 6:07 AM
To: eprints-tech@ecs.soton.ac.uk
Subject: [EP-tech]  Query about record locking in EPrints?

Hi,

I'm not sure why, but the staff who work on our Eprints repository have suddenly become concerned that if two or more of them happen to be working on the same record at once, they have no way of locking a record to ensure that their edits are not overwritten by someone else's.

As far as I know, there is no facility within Eprints for locking a record while you are editing it.  I am sure that a database product such as MySQL would cater for multiple users working on the same record, at least so that the system would not freeze or crash, and I told the staff this, but they are not satisfied with that reply.

So, my query to the list is -- how does Eprints handle record-locking (presumably the same way MySQL does)?

Best regards,

AlexAlexander J Birchall
Library Systems Manager
The Sheppard Library
Middlesex University
The Burroughs
Hendon
London NW4 4BT

+44 (0) 208 411 5235

*** Options: http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
*** Archive: http://www.eprints.org/tech.php/
*** EPrints community wiki: http://wiki.eprints.org/