Kbase 32430: Single Volume Database Crashes with Error 6091
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
Solution ID: P2430
FACT(s) (Environment):
Progress 8.x
SYMPTOM(s):
Database has crashed just before hitting the 2GB limit
Single volume database
<function>:Insufficient disk space during <system call>, fd <file descriptor>, len <bytes>, offset <bytes>, file <file-name>. (6091)
bkioWrite:Insufficient disk space during write, fd <file descriptor>, len <bytes>, offset <bytes>, file dbname.db. (6091)
The offset number in the 6091 message indicates the database is just short of the 2GB limit.
SYSTEM ERROR: Unable to extend the database. (111)
CAUSE:
The database is almost at the 2GB limit -- there is no more room for data.
FIX:
1) Do a probkup with the -i norecovery parameter
2) Copy the existing database to a new location as a safeguard
3) Create a new multi-volume database with a suitable structure to allow it to
grow beyond 2GB; for example: 2 fixed length extents of 1GB and a variable
extent.
4) Restore the new backup into the new database using prorest.
5) Delete the old database once the new one is running.