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 |