During UPDATE or DELETE SQL, TimesTen database invalidated after getting error: Reclaim failed in commit and TT0908: Key not found in table or index -- file "ttree.c", ... procedure "sbTtDelete" (Doc ID 2039280.1)

Last updated on AUGUST 26, 2015

Applies to:

Oracle TimesTen In-Memory Database - Version 11.2.2.5.0 to 11.2.2.5.8 [Release 11.2]
Oracle TimesTen In-Memory Database - Version 11.2.2.6.0 to 11.2.2.6.15 [Release 11.2]
Oracle TimesTen In-Memory Database - Version 11.2.2.7.0 to 11.2.2.7.13 [Release 11.2]
Oracle TimesTen In-Memory Database - Version 11.2.2.8.0 to 11.2.2.8.5 [Release 11.2]
Oracle TimesTen In-Memory Database - Version 7.0.0.0.0 to 7.0.6.24.0 [Release 7.0]
Generic Windows
Generic Linux
Oracle Solaris on x86-64 (64-bit)

Symptoms

TimesTen database invalidated with these errors found in ttmesg.log:

10:24:50.93 Err : : 9184: 12791/0x2b795cc0c000: Reclaim failed in commit (error 908) while processing ID = [33841664:1:18925526+1672 ,hLSN = 26035.6580224, LSN = -1.-1] Error messages follow.
10:24:50.93 Err : : 9184: 12791/0x2b795cc0c000: TT0908: Key not found in table or index -- file "ttree.c", lineno 5096, procedure "sbTtDelete"
10:24:50.97 Err : : 9184: 12791/0x2b795cc0c000: Data store marked invalid [xact.c:/st_timesten_11.2.2.5/1:sbXactCommit:7812] ...

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