My Oracle Support Banner

Create bitmap index can cause Assert Failure and stop fast recovery from completing (Doc ID 1070867.1)

Last updated on FEBRUARY 27, 2019

Applies to:

Oracle TimesTen In-Memory Database - Version 11.2.1 to 11.2.1.4.1 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 05-Mar-2012***


Symptoms

This is the type of Assertion Failure seen. It does not occur in the session doing the Create Bitmap Index but rather when the TimesTen subdaemon initiates a checkpoint:

 

10:48:23.13 Err : : 17063: 17068/0x1d630850: Assertion failed: ((((sbBlkHdr_p)(bpNext))->sane == ((sbBlkSane_t)0xCAFE)) && (((sbBlkTail_p)(((sbBlkTail_p) ((sbBlkHdr_p) (((sb_binary_t*)((sbBlkHdr_p)bpNext)) + ((((sbBlkHdr_p)bpNext)->sz -((sbBlkSz_t) ((((sb_uintp)(sizeof(sbBlkTail_t))) + ((((sb_uintp)8)-1))) &(~(((sb [db.c:/main/198:sbDbFileDataWriteFuzzy:24955] PID 17068 (timestensubd) CONN 2037 (Checkpoint) 2010-03-02 10:48:22.828



Fast recovery afterwards will hang when trying to recreate the index e.g



10:12:02.62 Info: : 25583: 25587/0x605b570: Recovery: rebuilding indexes 
10:12:02.62 Info: : 25583: 25587/0x605b570: sbDbIxRebuild: Spawning 1 recovery thread (1 requested) to recover 2 indexes 
10:12:02.62 Info: : 25583: 25587/0x401a9f90: sbDoIxRebuild[0]: Rebuilding index SYS.INDEXES.TBLID.IXNAME (1313728) Rows: 97 
10:12:02.62 Info: : 25583: 25587/0x401a9f90: sbDoIxRebuild[0]: Done rebuilding index SYS.INDEXES.TBLID.IXNAME 
10:12:02.62 Info: : 25583: 25587/0x401a9f90: sbDoIxRebuild[0]: Rebuilding index MY.MADEUPINDEX(1315232) Rows: 29610000 
10:12:02.84 Info: : 25583: 25587/0x401a9f90: sbIxLoadInRecovery: Index MY.MADEUPINDEX rows inserted: 1000000 

... 

10:12:06.42 Info: : 25583: 25587/0x401a9f90: sbIxLoadInRecovery: Index MY.MADEUPINDEX rows inserted: 16000000



no further rows inserted after this. 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
  
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.