Kbase P18443: Database crashes with 9451, 9450, 9445, 290, 9446, 3645 errors
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/12/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
Windows NT 32 Intel/Windows 2000
SYMPTOM(s):
Database crashes with 9451, 9450, 9445, 290, 9446, 3645 errors
<function>:Unknown O/S error during <system call>, errno <error number>, fd <file descriptor>, len <bytes>, offset <bytes>, file <file-name>. (9451)
<function>:Insufficient disk space during read, fd <file descriptor>, len <bytes>, offset <bytes>, file <file-name>. (9450)
SYSTEM ERROR: read wrong dbkey at offset <offset> in file <file> found <dbkey>, expected <dbkey>, retrying. (9445)
SYSTEM ERROR: I/O error <n> in <program>, ret <n>, file <n>, addr <n>. (290)
SYSTEM ERROR: <function>: Bad file descriptor was used during <system call>, fd <file descriptor>, len <bytes>, offset <bytes>, file <file-name>. (9446)
bkwrite: write to disk failed errno <num>. (3645)
Using 3rd party backup utility on the machine
CAUSE:
Veritas Backup Exec backup utility was used on the database files while the database was running. This caused a number of Windows system errnos to appear in the Progress error messages that seemed to suggest that the database or the file system was corrupt, e.g.
2L ERROR_FILE_NOT_FOUND The system cannot find the file specified.
9L ERROR_INVALID_BLOCK The storage control block address is invalid.
13L ERROR_INVALID_DATA The data is invalid.
The files mentioned in the error messages also varied - sometimes a data extent, sometimes a temp file, sometimes a bi extent.
Checking the application log for the backup utility showed that messages referring to Progress files occurred at the same time as the error messages in the database logfile.
FIX:
1. Restart the database. It should restart ok and go through crash recovery.
2. Do not use an operating system utility to backup the database files when the database is in use. probkup online is the only online backup that Progress supports.
3. There should be an option in the 3rd party utility for excluding files from the backup. Add the database files to the exclusion listing.