Sanity check

[Fairlight]

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.

https://www.cs.usfca.edu/~galles/visualization/BPlusTree.html

m->


On Tue, Jun 02, 2020 at 11:43:49AM -0400, William J. McEachran via Filepro-list thus spoke:
> Linux, filepro 5.8.00.03D6
> 
> I've got a routine which once every 4 or 5 years generates this:
> <<<
> Sanity check failure! split() len < 0
> tptr = tptr=(3,14,12339,1,0)
> file='bpretro at groupby' index=B
> which=1, nodesize=1024, entries[which]=11568
> count=12339, bound=6296, entries[1]=11568
> Write this information down, save a copy of the above
> index, and press Enter to generate a core dump to
> send to fpsupport, along with the index.
> >>>
> 
>  I can't 'make it happen' so it's hard to prevent it in the future.
> 
> The solution is to delete and recreate the index. (Rebuilding the index
> alone does not solve the problem).
> 
> Any insight into how this index (and perhaps others) gets corrupted would
> be appreciated.
> 
> Thanks.
> --
> Bill McEachran
> bill.mceachran at gmail.com     289-356-4406
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20200602/64fb5722/attachment.html>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
> 

-- 
Audio panton, cogito singularis.