Consultor Eletrônico



Kbase P12771: proutil -C mvsch corrupted database (1124)
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   24/04/2009
Status: Verified

SYMPTOM(s):

proutil -C mvsch corrupted database

Corrupt block detected when attempting to release a buffer. (4232)

SYSTEM ERROR: wrong dbkey in block. Found 19392, should be 96 (1124)

Stack trace from _proutil reads:

dsmFatalMsgnCallBack()
bmReleaseBuffer()
upMoveSchema()

After corruption, starting the database sends error 44

** Database has the wrong version number. (db: 1024, pro: 1115). (44)

Single and multiple user sessions can be started against the database prior to mvsch

Records can be updated, deleted, added prior to mvsch

dbutils report no database corruption prior to migration

dbutils report no database corruption post migration

FACT(s) (Environment):

Progress 9.1D

CHANGE:

Converted Progress 7 database into multi-volume database, then converted into version 9 with conv78 and conv89 and before 'proutil -C mvsch'

CAUSE:

BUG# 20020807-027

CAUSE:

When the new block in the new area was allocated at block 3, the dbkey of the old area overwrote the dbkey of the new area causing the buffer free to fail. The schema mover was updated to check if the schema area being moved contains more than one sequence block and move it appropriately.

FIX:

This issue was addressed in Progress SP 9.1D05 and Progress 9.1E

Alternatively:
Use the dump/load migration strategy to make use of Storage Areas and thereby minimise the Schema Area size by following the migration strategy outlined in Progress Solution P13253