Kbase P98240: Command truncate bi is ignored on a specific DB
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
FACT(s) (Environment):
Windows 32 Intel
Progress 8.x
SYMPTOM(s):
proutil <dbN> -C truncate bi
Truncate of the Before Image (BI) file has not been done
Database log file <dbN>.lg shows a 1rst problem, error 2249
Begin ABNORMAL shutdown code (2249)
Begin ABNORMAL shutdown code 2 (2249)
Database log file <dbN>.lg shows messages 459 and 6092 on crash recovery for following database (DB) restart attempt
** Any incomplete transactions are being backed out. (459)
<function>:Unknown O/S error during <system call>, errno <error number>, fd <file descriptor>, len <bytes>, offset <bytes>, file <file-name>. (6092)
<function>:Unknown O/S error during <system call>, errno 33, fd <file descriptor>, len <bytes>, offset <bytes>, file <dbN>.bi (6092)
CAUSE:
As per the errno value within message 6092, the problem is due to
33L ERROR_LOCK_VIOLATION The process cannot access the file because another process has locked a portion of the file.
FIX:
Reboot the Win32 machine to clear the ERROR_LOCK_VIOLATION on the Before Image (BI) file for this database