Corrupt block detected

Neil.L

New Member
M F G / P R O Release 7.4G 03 as of Jan 16 1996

Database type: PROGRESS
Database version: 7

PROGRESS Procedure Editor Version 7.3D


I am a progress database user; I fall into a big problem on database block corruption.
It makes our database ABNORMAL shutdown many times. I think it may have some progress command to recover this block corruption
Please help!! I will be deeply appreciated for your help.
Thank you.

/cct98/live > ll
total 2766112
-rw-rw-rw- 1 root sys 2097152 Sep 5 20:19 db-esl.bi
-rw-rw-rw- 1 root sys 1053147136 Sep 5 20:17 db-esl.db
-rw-rw-rw- 1 root sys 53872 Sep 5 20:18 db-esl.lg
-r--r--r-- 1 root sys 38 Sep 5 19:41 db-esl.lk

Message in log file (db-esl.lg):
19:08:29 Usr 1: SYSTEM ERROR: read wrong dbkey at offset 373748736 in file /cct98/live/db-esl.db found 0, expected 11679680, retrying. (1152)
19:08:39 Usr 1: Corrupt block detected when reading from database. (4229)
19:08:39 Usr 1: SYSTEM ERROR: wrong dbkey in block. Found 0, should be 11679680 (1124)
19:08:41 SRV 0: Begin ABNORMAL shutdown code 2 (2249)
 
Thank you for your reply...

What exactly I can do for recover this corruption?

Thanks for any suggestion
 
Thank you for your suggestion. Finally I choose dump and load all data in database to solve the problem....... I think I need to join the maintenance contract asap.

Progress support write: Without a valid maintenance contract, we cannot provide you with support.
 
Dump & Load - that's a good solution. Out DB's are too large now and that would have been a last resort.

Maintenance contracts are quite costly. But I've had very good experiences with Progress tech support. I'd say they are one of the better ones in the industry.
 
Back
Top