^ [TABLE="class: detailList"]
[TR]
[TD="class: labelCol first last"]Environment[/TD]
[TD="class: data2Col first last"]File ulimit is set to unlimitedAll Supported Operating SystemsProgress 8.xProgress 9.x[/TD]
[/TR]
[/TABLE]
[TABLE="class: detailList"]
[TR]
[TD="class: labelCol first last"]Question/Problem Description[/TD]
[TD="class: data2Col first last"] [TABLE="class: htmlDetailElementTable"]
[TR]
[TD] Idxbuild fails with 290 error when Sort file hits 2GB
SYSTEM ERROR: I/O error <n> in <program>, ret <n>, file <n>, addr <n>. (290)
SYSTEM ERROR: I/O error 0 in writeto, ret 2047, file <srt>, addr 2147481600. (290)
Temporary sort file at: <Directory Path> will use up to <Size of Disk Space> KB of disk space. (5289)
proutil -C idxbuild session end. (334)[/TD]
[/TR]
[/TABLE]
[/TD]
[/TR]
[/TABLE]
[TABLE="class: detailList"]
[TR]
[TD="class: labelCol first last"]Clarifying Information[/TD]
[TD="class: data2Col first last"] [TABLE="class: htmlDetailElementTable"]
[TR]
[TD][/TD]
[/TR]
[/TABLE]
[/TD]
[/TR]
[/TABLE]
[TABLE="class: detailList"]
[TR]
[TD="class: labelCol first last"]Error Message[/TD]
[TD="class: data2Col first last"][/TD]
[/TR]
[/TABLE]
[TABLE="class: detailList"]
[TR]
[TD="class: labelCol first last"]Defect Number[/TD]
[TD="class: data2Col first last"][/TD]
[/TR]
[/TABLE]
[TABLE="class: detailList"]
[TR]
[TD="class: labelCol first last"]Cause[/TD]
[TD="class: data2Col first last"] [TABLE="class: htmlDetailElementTable"]
[TR]
[TD] The 2GB limit has been hit on one of the sort files.
An Invalid path is set in the Multi volume .srt file which is pointing to the wrong file system that does not have adequate space for the sort operation.[/TD]
[/TR]
[/TABLE]
[/TD]
[/TR]
[/TABLE]
[TABLE="class: detailList"]
[TR]
[TD="class: labelCol first last"]Resolution[/TD]
[TD="class: data2Col first last"] [TABLE="class: htmlDetailElementTable"]
[TR]
[TD] Progress message 5289 will immediately show if the correct filesystem and notation has been used in the .srt file: Correct: Temporary sort file at: /tmp1/ will use up to 1899984K of disk space. (5289) sort file saaXXXX will be created under /tmp1/ Incorrect: Temporary sort file at: /tmp2 will use up to 1899984K of disk space. (5289)
Note the trailing "/" for Unix or "\" for Windows is missing and in this case, /tmp2 does not have this amount of space available for the duration of the idxbuild operation
Modify the .srt file to point the correct filesystems that contain the amount of space specified in the srt file definition. Please refer to Solution
P55740 for more information on the structure.
1. Add more entries within the <dbname>.srt with a filesize of less than 2GB for each entry.
Or
2. Run idxbuild for less indexes.[/TD]
[/TR]
[/TABLE]
[/TD]
[/TR]
[/TABLE]
[TABLE="class: detailList"]
[TR]
[TD="class: labelCol first last"]Notes[/TD]
[TD="class: data2Col first last"] [TABLE="class: htmlDetailElementTable"]
[TR]
[TD] The space for sorting can be large when many indexes are used on char field(s). This is because strings are not compacted in phase 1 of "idxbuild".
References to Written Documentation:
Progress Documentation:
Version 8.3 System Administration Guide, Section 14.9.2
Version 9 Database Administration Guide and Reference, Section 12.9.3 - Chapter 14: "Overcoming SRT Size Limitations" and "Rebuilding Indexes"
Progress Solutions:
P55740, "How to scope and define a multi-volume srt file for idxbuild"[/TD]
[/TR]
[/TABLE]
[/TD]
[/TR]
[/TABLE]
[TABLE="class: detailList"]
[TR]
[TD="class: labelCol first last"]Attachment[/TD]
[TD="class: data2Col first last"][/TD]
[/TR]
[/TABLE]
[TABLE="class: detailList"]
[TR]
[TD="class: labelCol first last"]Disclaimer[/TD]
[TD="class: data2Col first last"]The origins of the information on this site may be internal or external to Progress Software Corporation (“Progress”). Progress Software Corporation makes all reasonable efforts to verify this information. However, the information provided is for your information only. Progress Software Corporation makes no explicit or implied claims to the validity of this information.
Any sample code provided on this site is not supported under any Progress support program or service. The sample code is provided on an "AS IS" basis. Progress makes no warranties, express or implied, and disclaims all implied warranties including, without limitation, the implied warranties of merchantability or of fitness for a particular purpose. The entire risk arising out of the use or performance of the sample code is borne by the user. In no event shall Progress, its employees, or anyone else involved in the creation, production, or delivery of the code be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the sample code, even if Progress has been advised of the possibility of such damages.[/TD]
[/TR]
[/TABLE]
