Product Documentation

FairCom DB V12 Release Notes

Previous Topic

Next Topic

Rare missing index keys after Create or Rebuild fixed

In certain specific circumstances (see below), one or more index members had fewer keys than expected after an index rebuild or creation. The creation/rebuild returned successfully, which sometimes led to other unexpected behavior.

The circumstances for this problem to be encountered required both of the following: a configuration with SORT_MEMORY 6GB or larger and the logical index being rebuilt large enough to be swapped to disk.

The logic has been modified to eliminate this.

In addition, logic was implemented to validate the number of keys added for sorting is the same as the number of keys returned. A discrepancy returns new error ISORT_ERR (1135).

This update will not fix an existing index with missing keys. The index will need to be rebuilt after the update or as a workaround it can be rebuilt in older versions with SORT_MEMORY set to less than 6GB.

TOCIndex