Kbase P88477: System Error 210 when adding two 8GB extents to an area already at 245GB.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
06/01/2009 |
|
Status: Verified
SYMPTOM(s):
System Error 210 when adding two 8GB extents to an area already at 245GB.
SYSTEM ERROR: Attempt to read block <number> which does not exist. (210)
SYSTEM ERROR: Attempt to read block 128 which does not exist. (210)
Block 128 is an object block.
** Save file named core for analysis by Progress Software Corporation.(439)
Stack trace from _dbutil reads:
bmLockBuffer
bkExtentCreate
dsmExtentCreate
dbAdd
mv_strucutil
Area size prior to attempted adding of extents was 245GB
Records per block for the area is 64
Database has 8K blocksize
FACT(s) (Environment):
Progress 9.x
OpenEdge Category: Database
All Supported Operating Systems
CHANGE:
Adding extents
CAUSE:
There is a 256GB limit on this data area. The attempt to add the second 8GB extent reached the limit of the data area.
FIX:
There is no way to exceed this limiting value at this time.
The size of the table must be reduced.
Split the table and place each part in its own area as appropriate.
If splitting the table at this time is not possible use one of the following as a temporary work around:
1. Add smaller fixed extents and a variable extent keeping below the limit.
2. Delete records where possible
3. Create a new area with fewer records per block and move the table into the
new area.