Kbase P104686: The Before Image (BI) file hits the 2 GB limit on version 8 database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Unverified
FACT(s) (Environment):
Progress 8.x
SYMPTOM(s):
The Before Image (BI) file hits the 2 GB limit on version 8 database
database crashes on startup
bkioWrite:Insufficient disk space during write, fd <file descriptor>, len 16384, offset 2147475456, file <file-name>. (6091)
CAUSE:
In version 8 there is a 2 GB limit on the BI file. This includes the total size of all the BI extents if this is a multivolume database.
The reason that the bi file grows at startup is that bi notes are written to the BI file during the redo phase and during the roll back of all non committed (interrupted ) transactions.
FIX:
The best option is to restore the database from backup.
If this is not an option you can force truncate the BI file. This can cause database corruption. Please read Progress solution P24330, "Consequences of using the -F startup option"