Skip to Content
0
May 26, 2014 at 09:54 PM

HELP! After Restore of MAXDB 7.6.06.03 I get sql error duplicate secondary key

51 Views

HELP! After Restore of MAXDB 7.6.06.03 I get sql error duplicate secondary key and the database can't go ONLINE.

I tried to restore a complete backup with initialization. When the restore is finished and I click on Restart the error comes up.

Is there a chance to fix that error? I dont have access to an older backup right now.

EDIT: The error log says this:

2014-05-27 05:36:54 0x308 ERR 5 Catalog Catalog update failed,IFR_ERROR=250,DESCRIPTION=POS(1) Duplicate secondary key:INDEX001

2014-05-27 05:36:55 ___ Stopping GMT 2014-05-27 03:36:55 7.6.06 Build 003-123-202-135

I also tried to switch AUTO_RECREATE_BAD_INDEXES from NO to YES but no difference. Any ideas?