Corrupt block detected

[Neil.L]

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)

 

[dkellgren]

Check this link:

http://www.progress.com/services/su...y.p?kbid=19609&keywords=1152&wintype=kbwindow

It has your errors exactly.

 

[Neil.L]

Thank you for your reply...

What exactly I can do for recover this corruption?

Thanks for any suggestion

 

[dkellgren]

I would call Progress Tech Support on that one.

 

[Neil.L]

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.

 

[dkellgren]

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.