[RDD] Log Locking

Wayne Merricks merricks.wayne at googlemail.com
Mon Jun 26 07:55:16 EDT 2017

Just to weigh in on the technical side as someone who has both programmed
software that does this and also someone on the help desk that dealt with
other software.

Nothing is perfect.

Things that can break a software lock:

* Computer crash or shutdown as already noted.
* User starts working and goes to lunch/a meeting/whatever
* Database server restarted/crashed (most clients can end up in a weird
state at this point).

Things that seem like a good idea:

* Implement a 30minute time out.
* Allow IT to override the lock outs.
* Allow "more important" staff to override the locks.

Why they're not:
* User goes to lunch etc and lock times out/overridden and then all their
work is lost.  Bonus points if the work lost was by some of the more
awkward/higher ranking staff members.
* You get to watch the arguments for the third one which can be amusing.

Having said all of this, having a lock option of any sort and understanding
the problems it may cause is probably a good choice to have for some sites.



On 26 Jun 2017 12:31, "Rob Landry" <41001140 at interpring.com> wrote:

> I went through similar issues with my music scheduling programs. In the
> end, it turned out to be easier for the users to solve this problem by
> communicating among themselves than to craft a technical solution.
> Technical solutions to this sort of problem tend to be messy (e.g. user
> shuts down computer without properly logging out, so log stays locked
> forever).
> Rob
> On Thu, 22 Jun 2017, Patrick wrote:
> Today someone was voice tracking and another person went into the log
>> editor accessing the same
>> log. I believe the way the log editor works is the entire log is loaded
>> in and then written back when
>> done, causing any voice tracks recorded during that time to be
>> overwritten.
>> If this is true, would it be a good idea to place some kind of lock on
>> the database when someone
>> is voice tracking that prevents the log editor from opening the same log,
>> at least without some kind
>> of warning message?
>> Patrick
>> _______________________________________________
> Rivendell-dev mailing list
> Rivendell-dev at lists.rivendellaudio.org
> http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://caspian.paravelsystems.com/pipermail/rivendell-dev/attachments/20170626/b75e1e8a/attachment.html>

More information about the Rivendell-dev mailing list