Exalytics: TimesTen 11.2.2.6.5 Database Crash By Invalidation Caused By A 'SPINLATCH Assertion' (Doc ID 1671872.1)

Last updated on MAY 19, 2014

Applies to:

Oracle Exalytics Software - Version 1.0.0.4.0 and later
Oracle TimesTen In-Memory Database - Version 11.2.2.6.5 to 11.2.2.6.5 [Release 11.2]
Information in this document applies to any platform.

Symptoms

TimesTen database crashed due to which the datastore encountered an invalidation caused by a SPINLATCH assertion. 

Error message from ttmesg log:

2014-04-08 00:18:52.193
Invalidating data store: /u02/app/oracle/oradata/TimesTen/pvh_qas_tt_data_store/pvh_qas_tt_data_store
Reason: Assertion failed: lp->lhdr.ltype == SbSpinLatch [latchMgr.c:/main/69:sbSpinLatchGet:1987] PID 8997 (ttIsqlCmd) CONN 2 (pvh_qas_tt_data_store) 2014-04-08 00:18:52.138

At the time of the crash, below 2 processes were running:


Also the index advisor was running on a different set of tables than that were loaded by the ttLoadFromOracle process.


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