Kbase P8094: Before Image (.bi) 881 error and database can't start
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/11/2008 |
|
Status: Verified
SYMPTOM(s):
** Cannot find or open file <file-name>, errno = <number>. (43)
SYSTEM ERROR: The before-image file has the wrong cluster size. (881)
OS backup in use
When starting the database Before Image (.bi) 881 error appears
Cannot start the database
FACT(s) (Environment):
UNIX
Progress/OpenEdge Product Family
CHANGE:
Introduced automated OS backup scripts
CAUSE:
This unusual sequence of events should be verified in the database log file, prior to this error appearing. The shutdown should have completed successfully, the truncate session begun and ended and no user sessions begun while the OS copy was being taken. What you should find is that the .bi file was truncated while the database was running in either single or multi-user mode or the OS copy was taking place while a user session initiated.
When the database.lk file is removed, it is possible to start a proutil truncate bi session before the database is shut down properly or alternatively, to start a database session while the truncate bi is executing.
FIX:
Check the automated scripts to make sure that if the commands are executing in the background (these commands will have an '&' at the end) that there is enough time in between each command (sleep #) for the previous commands to finish.
It is generally much safer not to run these PROGRESS processes in the background so that each command will need to complete before the next line in the script is executed.
Furthermore, user sessions should be prevented from starting while the OS backup is taking place.