Kbase P92167: Temporary files can cause database shutdown with error 8897 when there is insufficient space on syst
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/24/2009 |
|
Status: Verified
SYMPTOM(s):
Database shuts down abnormally due to insufficient disk space
SYSTEM ERROR: Unable to extend database within area <areaName>. (8897)
bkxtn: write error, file <file-name> errno: <number>. (3646)
Operating System error logs show disk space shortage errors during database crash time period.
After clients shutdown there is no shortage of space on system
FACT(s) (Environment):
Program using temp-tables requires large amounts of disk space to be used in the DBI files
All Supported Operating Systems
Progress/OpenEdge Product Family
CAUSE:
Programs running in the background were using temp-tables and due to the amount of records contained in the temp-tables the Progress client couldn't hold all records in memory.
The Progress client is programmed to use the DBI file as an overflow point if the client can not hold all records of a temp-table in memory.
FIX:
If a Progress Client runs a program which makes use of temp-tables and there is insufficient memory made available by the startup parameter -Bt to hold all of the temp-table records in memory, then disk space will be used in the DBI files. The temporary files are visible on Windows and invisible on Unix unless the -t startup parameter is used.
Have the Progress client sessions use the -T to direct the temporary files to places other than where the database files live.