Kbase P108761: Database cannot restart after successfull idxbuild followed by immediate reboot of the machine
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
SYMPTOM(s):
proutil <db> -C idxbuild all -B 1024 -TB 31 -TM 32
idxbuild was successful as per the messages 1644 and 334 within the database log file (<db>.lg)
Index rebuild complete. <number> error(s) encountered. (1644)
Index rebuild complete. 0 error(s) encountered. (1644)
<Multi/Single> session end. (334)
proutil -C idxbuild session end. (334)
Reboot of the machine done immediately after end of idxbuild
proserve <db>
database cannot restart; no error but 3 messages within <db>.lg
Multi-user session begin. (333)
Removed shared memory with segment_id: <id>
<Multi/Single> session end. (334)
Multi-user session end. (334)
idxcheck reports error on dsmCursorCreate
proutil <db> -C idxcheck all
ERROR - dsmCursorCreate failed. -1215
CAUSE:
The reboot of the machine was done prior to all new index blocks being written to disk. There is no BI notes written during idxbuild and therefore the crash recovery phase cannot and the result is a corrupted database
FIX:
Run "proutil <db> -C truncate bi" prior to rebooting the machine