Kbase P102159: Progress .srt file with incorrect sort file designations causes idxbuild to terminate
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/19/2009 |
|
Status: Verified
SYMPTOM(s):
Idxbuild being run against a large database terminates with errors
Error writing to temp file sequentially, current directory is , blockOffset is , errno is , instance id is . (11482)
Error writing to temp file sequentially, fd is <num>, error is 0
Error writing to temp file sequentially, current directory is <file>, blockOffset is <num>, errno is 0
Error: key insertion failed
OS posts out of disk space message
Free space available on multi-disc system
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Versions
CAUSE:
The sort file was defined as 1000000000 (1 TB) instead of 1000000 (1GB). This will cause the idxbuild to try and build the sort file to accommodate the .srt instructions, running out of file handles as well as disk space.
FIX:
To correct the problem create the .srt file with sort files with a smaller size, in KB units.
For example:
1000000 /progress/dump/
1000000 /progress/dump/
1000000/progress/dump/.....