<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<tt>William,<br>
<br>
Are you deleting records you are sitting on?<br>
<br>
How are you identifying the records to delete?<br>
<br>
If you are doing a lookup using an index and delete the record you
are pointing at, you can not use that index as a way to getnext or
getprev, you have to start back at the original lookup and
re-establish your place in the index.<br>
<br>
You can not issue WRITE in Automatic tables - that will crash
indexes.<br>
<br>
Other than that, it sounds like you are proceeding properly. LOCK
record, delete and write.<br>
<br>
Usually I find that index crashes are related to DELETE or users
able to exit with bad manners. Automated processes are usually
not susceptible to the user issue once you have them working
properly. But they are able to trash indexes that might affect
your automated process. I often rebuild indexes prior to
automated processes to make sure everything is solid.<br>
<br>
That deleted key not found error message does not close after XX
seconds, like I was told it should years ago. It will cause the
processes to hang indefinitely. <br>
<br>
But you knew all this, maybe I triggered a good memory that will
help you fix it.<br>
<br>
Nancy<br>
</tt><br>
<div class="moz-cite-prefix">On 6/2/2020 3:58 PM, William J.
McEachran via Filepro-list wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAHYvgQvU00kQ2Prrbz9h7BXi917UPdm-g9pqb0-EmDVpb2mNWg@mail.gmail.com">
<pre class="moz-quote-pre" wrap="">On Tue, 2 Jun 2020 at 12:10, Fairlight via Filepro-list <
<a class="moz-txt-link-abbreviated" href="mailto:filepro-list@lists.celestial.com">filepro-list@lists.celestial.com</a>> wrote:
</pre>
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">It's the result of bad BTree+ code.
If you go through this demo, you'll see when data needs to be split.
Something about it is incorrectly handled in fP, resulting in bad
indexes.
<a class="moz-txt-link-freetext" href="https://www.cs.usfca.edu/~galles/visualization/BPlusTree.html">https://www.cs.usfca.edu/~galles/visualization/BPlusTree.html</a>
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">I got lucky and found that the nightly tar archive had the troubled data.
I was able to play around with it on a test system and found I could get a
DKNF (deleted key not found) error on the data in addition to the sanity
check
The data is part of a simple routine that is created and used in a single
process ... so it easily traceable.
All lookups involved in record operations (creating, deleting, modifying)
are protected (-p flag) lookups.
Each record operations concludes with a write - 'write [lookupname''.
Create a record; write that record. Delete a record; write that record.
etc.
The routine concludes with a 'sync'.
So I can't think of anything that I've missed to cause invalid key/index
issues.
Did I miss something?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <a class="moz-txt-link-rfc2396E" href="http://mailman.celestial.com/pipermail/filepro-list/attachments/20200602/7d8f4995/attachment.html"><http://mailman.celestial.com/pipermail/filepro-list/attachments/20200602/7d8f4995/attachment.html></a>
_______________________________________________
Filepro-list mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a>
Subscribe/Unsubscribe/Subscription Changes
<a class="moz-txt-link-freetext" href="http://mailman.celestial.com/mailman/listinfo/filepro-list">http://mailman.celestial.com/mailman/listinfo/filepro-list</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Nancy Palmquist MOS & filePro Training Available
Virtual Software Systems Web Based Training and Consulting
PHONE: (412) 835-9417 Web site: <a class="moz-txt-link-freetext" href="http://www.vss3.com">http://www.vss3.com</a>
</pre>
</body>
</html>