Salesforce

Index rebuild process does not exit after reported as completed on Windows 64-bit

« Go Back

Information

 
TitleIndex rebuild process does not exit after reported as completed on Windows 64-bit
URL Name000040259
Article Number000162673
EnvironmentProduct: OpenEdge 64-bit
Version: 10.2B, 11.1x, 11.2x
OS: Windows 64-bit
Question/Problem Description
Command prompt does not come back after Index rebuild complete message has been displayed on the screen and printed in the database.lg file
All the indexes have been rebuilt.
_dbutil.exe still listed as a process with allocated memory.
Steps to Reproduce
Clarifying Information
It takes several hours for _dbutil.exe IDXBUILD to release all the memory and return to command prompt.
Issue only seen on Windows 64-bit
Error Message
Defect NumberEnhancement PSC00256208 / OE00234569,
Enhancement Number
Cause
Win64 memory management issue with releasing the memory in a different order than it was obtained. _dbutil (idxbuild) merge threads in "-TF pool" are released in a different order than created, hence the issue.
Resolution
Upgrade to OpenEdge 10.2B08, 11.3 or later.
 
A new IDXBUILD parameter: -freeTF for merge buffer memory management.
 
0 -- Do not explicitly free merge buffer memory.  The default for Windows 64-bit.
1 -- Explicitly free merge buffer memory. The default for all Unix platforms and Windows 32-bit.

The value is determined and set automatically by _dbutil.
 
-freeTF 0 will avoid freeing merge buffers on exit if the OS is Windows64 and will let OS to free them instead.
For other Operating Systems, _dbutil will continue to free the memory explicitly, eg -freeTF 1.
Again, this is determined automatically by the idxbuild process itself but can be changed if required.
 
Workaround
Apart from letting _dbutil to finish or running it on 32-bit system there is no other workaround available.
Notes
The issue is reproducible outside OpenEdge by allocating for example 10000 chunks of 32K of memory and then releasing them in a different order than it was obtained. 
Keyword Phrase
Last Modified Date9/24/2015 3:38 PM

Powered by