Kbase P76075: Prostrct create fails with errors 9423 8374 when using 8KB blocksize
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/22/2010 |
|
Status: Verified
SYMPTOM(s):
Cannot create a database structure with 2GB extents when -blocksize 8192
prostrct create fails with errors 9423 8374 when using 8KB blocksize
Following messages on prostrct create when size in .st file is greater than 2097024
Warning: Extent size should be a multiple of 16. (6834)
Adjusted to 2097152 from 2097120. (6835)
Format of extent <db_extent> failed at block 262143. (9423)
Create database failed. Check your structure file. (8374)
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.0x
CAUSE:
Bug# OE00112791
CAUSE:
Limit on file size is reached. The 6834 message should read: "Warning: Extent size should be a multiple of 16 database blocks. As the current entry in the .st file being used to create the database does not meet this criterion, the utility normally rounds up the creation to the next divisor accordingly. In this case it is 2GB exactly, which in turn results in a failed operation when the 2GB limit is reached on systems that do not support largefiles and/or when using Progress versions that do not support largefiles.
FIX:
Upgrade to OpenEdge 10.1A where this error 6834 is now raised as a warning and the extent size is automatically adjusted
Example:
Warning: Extent size should be a multiple of 16 database blocks. (6834)
Adjusted to 2097024 from 2097025. (6835)
Workaround:
The maximum size of a database extent on a system where largefiles have not been enabled is 2GB - (16 x database_blocksize).
In other words, to create a 2Gb extent:
For Type I Storage Areas, with 8KB blocksize, use the value of (2GB - 128 MB) = extent size of 2097024 (in KB units) within the .st file.
For Type II Storage Areas, the value must also be larger than the clustersize, and the cluster size must be divisible. If this is not the case, the add or create will fail.