Kbase P61140: No data seen after binary load run in multi-user mode
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
SYMPTOM(s):
No data seen after binary load run in multi-user mode
Binary Dump/Load just done
Binary Load run after a DB broker had been started
Having loaded data with "proutil <db> -C load <file>" and then run "proutil <db> -C idxbuild all"
DB broker started with -Mf 25
Emergency shutdown executed ("proshut <db> -F -by") immediately after last binary load finished
CAUSE:
As the writes to the BI were delayed up to 25 seconds (-Mf 25), the last transaction(s) will not be written to the BI. If the beginning of a transaction was written to the BI but the"Commit Transaction" note was missing, then there will be an UNDO during crash recovery for that transaction .
FIX:
Do not issue an emergency shutdown, run
. "proshut <db> -by" without the option "-F"
or, wait 25 seconds after the last binary load finished prior to issuing an emergency shutdown
. "sleep 25; proshut <db> -by -F"