Kbase 16667: Roll Forward Errors <2329> and <612> With 2phase Commit
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/29/2002 |
|
Status: Unverified
FACT(s) (Environment):
Progress 7.x
Progress 8.x
SYMPTOM(s):
SYSTEM ERROR: Invalid block <block> for file <file-name>, max is
<max-block> <2329>
SYSTEM ERROR: Possible file truncation, <block-offset> too big for database. (612)
AI Roll Forward errors, 2329 and 612, occur with 2phase commit
These error prevent a crash recovery after a database restore is performed
CAUSE:
The errors occur because during forward processing, there are enough RL_CTEND notes generated to cause the .tl file to grow during roll forward
FIX:
Start 2 phase commit on the database before performing roll forward by
the following procedure:
restore backup
proutil dbname -C 2phase end (this removes the .tl - transaction log)
proutil dbname -C 2phase begin
proutil dbname -C 2phase new
rfutil dbname -C roll forward
ONLINE PROCEDURES OR UTILITIES:
proutil dbname -C 2phase end
proutil dbname -C 2phase begin
proutil dbname -C 2phase new
rfutil dbname -C roll forward