Invalidation Due To Assertion In SbTpgSlotActivate (Doc ID 2157887.1)

Last updated on JULY 13, 2016

Applies to:

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

Symptoms

database invalidated with assertion failed from inval file and ttmesg log and tterror log:

Invalidating data store: /home/ttdata0/TimesTen/mydsn/mydsnReason: Assertion failed: !(((((((pgp))->slotBusy))[((sbBmapIx_t) (((sbBmap_t) (((slot)))) >> ((sb_uintp) 6) ))]) & ((sbBmap_t) (((sb_uintp)(1)) << (((sbBmapIx_t) ((slot))) & ((sb_uintp)(((sb_uintp) 64)-1))))))) || SbContextP->inOpLogUndo [tupPage.c:/main/27:sbTpgSlotActivate:1085] PID 25845 (ttcserver) CONN 697 (java) 2016-02-21 19:19:41.910

Asserted SQL from inval file, ttmesg.log and tterror.log:

Assert SQL='update MYTABLE set status = ?, transactionid = ?, lastupdate = ?, lastupdateid = ? where transactionid = ? '

Tuple Page report from inval file like below follows after invalidation and asserted SQL report.

Tuple Page Report
Condition: Assertion encountered
Table: Owner.MYTABLE (1043972232) Page: 981520448, Slot: 24
Tpg 0x2abb133afeb8; id 981520448; LSN(-1.-1); xactId(697.13425); flags 0x7205; sz 4624; tbl 1043972232; tblname C3.TRADE; ptnNum 1; pgno 161; busyCnt 199; insertCnt 183; unlinkCnt 1
00002abb133afeb8 feca0572 2c4f0100 00000000 6f0d0000 [...r,O......o...]
00002abb133afec8 a8020000 00000000 0020432a 00000000 [......... C*....]
00002abb133afed8 ffffffff ffffffff ffffffff ffffffff [................]
00002abb133afee8 f50ae904 00000000 89281d00 00000000 [.........(......]
00002abb133afef8 40010800 bd2a0000 40d0803a 00000000 [@....*..@..:....]
00002abb133aff08 a0b4803a 00000000 10120000 00000000 [...:............]

 

Changes

 A table (with update on it in Asserted SQL) is altered (DDL Change with a column added or column change).

From ttschema (post invalidation), you would see someting like this in the table definition.

-- column mycolumn1 partition 1
-- column mycolumn2 partition 2
-- column mycolumn3 partition 3

 

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