fp file locking behavior

John Esak john at valar.com
Wed May 23 05:20:05 PDT 2007


Bob,
I don't think the provisionary locking actually works that way. I mean, I
don't think it could cause any kind of deadlock or lockout condition.  I
could be wrong, of course, but I just don't think this situation could
happen.

What might be happening is a case where filePro is locking record zero
(which it does for various reasons... Maybe Ken can illucidate on this a
bit. It might bear some fruit for you.

John


> -----Original Message-----
> From: Bob Haussmann [mailto:haussma at nextdimension.net]
> Sent: Wednesday, May 23, 2007 7:36 AM
> To: john at valar.com; 'Filepro-List at Lists. Celestial. Com'
> Subject: RE: fp file locking behavior
>
>
>
> > It was JP Radley who first brought it to my attention that
> > automatic index
> > file stamps get changed just by someone entering into a file
> > in clerk. Yes,
> > it was long ago, but not more than 23 years or so... I found
> > a reference to
> > his notation about this back in some CompuServe stuff in
> > 1985.... and I
> > actually remember when he brought this up, thinking that it
> > was odd that the
> > stamps should change when no actual modification was made to
> > the file(s).
> > This behavior has never caused me a bit of hassle in all those years,
> > though.
>
> John--nice memory.  Now that you bring it up, I do remember that
> exchange.  I think it was after a major version update.  The question
> remains, why would fP need to issue a lock for writing the
> index when one is only browsing?  Interestingly, if PFREADONLY is
> set, the timestamp is not updated, so this behavior is likely by
> design.  Still, in very active files, wouldn't this cause
> deadlock/contention issues?  I think that is what we are seeing, and
> why it is so hard to track down.  It has to be two sessions hitting
> the same index at the exact same time, and one of those sessions
> encountering an index locked for writing.
>
> Bob Haussmann
> Tabor Children's Services, Inc.



More information about the Filepro-list mailing list