Kbase P24196: Change on the schema causes the BI file to reach 2GB
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
02/07/2003 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
FACT(s) (Environment):
Progress 9.1C
SYMPTOM(s):
BI file reached 2GB
Large file support not enabled for the database
bkioWrite:Insufficient disk space during write, fd <file descriptor>, len <bytes>, offset <bytes>, file <file-name>. (9450)
Insufficient disk space to extend the before-image file.(854)
There is no time to perform a long crash recovery.
A change to the DB schema was applied to a large table.
CAUSE:
The DB crashed because it reached 2 GB and there is no large file support for the DB.
FIX:
Even though it is possible to add more BI extents to go on with the crash recovery process it is also necessary to consider the amount of time that the transaction took to overflow the BI.
The time a crash recovery takes to perform is at least the same time it took before crashing.
Going to backups can be faster than going through crash recovery.