DB Cannot Recovery, Due To Error Unique Constraint Violation On The Index (Doc ID 1921526.1)

Last updated on FEBRUARY 27, 2016

Applies to:

Oracle TimesTen In-Memory Database - Version 11.2.2.6.3 and later
Information in this document applies to any platform.

Symptoms

Customer switched from cache group to regular tables, after running for a while, They would run into unique constraint error. The same unique constraint error is preventing the recovery to complete.

 

recovery unique error:

20:40:48.15 Info:    : 32510: 14629/0x90143b0: Recovery: rebuilding indexes
20:40:48.15 Info:    : 32510: 14629/0x90143b0: sbDbIxRebuild: Spawning 1 recovery thread (1 requested) to recover 17 indexes
20:40:48.15 Info:    : 32510: 14629/0x4055c170: sbDoIxRebuild[0]: Rebuilding index  owner.table (2641800) Rows: 72288
20:40:48.26 Info:    : 32510: 14629/0x4055c170: sbDoIxRebuild[0]: Done rebuilding index owner.table
20:40:48.26 Info:    : 32510: 14629/0x4055c170: sbDoIxRebuild[0]: Rebuilding index owner.index(2641880) Rows: 72288
20:40:48.31 Info:    : 32510: 14629/0x4055c170: sbDoIxRebuild[0]: sbIxRebuild failed on index 2641880 (owner.index); errors follow.
20:40:48.31 Err :    : 32510: 14629/0x4055c170: TT0907: Unique constraint (index on owner.table) violated at Rowid <BMUFVUAAACiEAAAHjX> -- file "hindex.c", lineno 2658, procedure "sbHixPushDupErr"
20:40:48.31 Info:    : 32510: 14629/0x4055c170: sbDoIxRebuild[0]: failXit
20:40:48.32 Info:    : 32510: 14629/0x90143b0: sbDbIxRebuild: 1 recovery thread completed, 1 index required rebuild
20:40:48.32 Err :    : 32510: 14629/0x90143b0: recovery failed in rebuild phase at step 9

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms