Datastore Got Invalidate during rollback

(Doc ID 1916164.1)

Last updated on SEPTEMBER 07, 2017

Applies to:

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

Symptoms

ttSize was taking a long time, looks like the customer killed it. And then it lead to db invalidation.

ttmesg log:

10:24:09.30 Info:    :  1612: 31671 doRollbackWork: Calling sbOLUndoByConn for connid 2 (ttSizeCmd)
10:24:09.30 Warn:    :  1608: 1612/0x41db8250: sbOLUndoByConn: oplog stack for connid 2 (ttSizeCmd) pid 31671: <none>
10:24:12.55 Info:    :  1608: 1612/(nil): 1612 sbXactRollbackXcb started for connid 2 (ttSizeCmd)
10:24:12.57 Err :    :  1608: 1612/0x41db8250: Data store marked invalid [xact.c:/main/200:sbXactRollbackXcb:4947] PID 1612 (timestensubd) CONN 2 (ttSizeCmd) Context 0x41db8250
10:24:13.20 Err :    :  1608: 1612/0x1cb9010: IndexGC could not start a transaction
10:24:13.20 Err :    :  1608: 1612/(nil): 1612 sbXactRollbackXcb failed for connid 2
10:24:13.20 Info:    :  1612: 31671 doRollbackWork: sbOLUndoByConn for connid 2 (ttSizeCmd) returned 1
10:24:13.20 Err :    :  1612: 31671 doRollbackWork: sbOLUndoByConn failed for connid 2 (ttSizeCmd)
10:24:13.20 Err :    :  1612: TT14000: TimesTen daemon internal error: subd: Undo failed.

 

portion of the thread stack from .inval file:

Thread 11 (Thread 0x41de6940 (LWP 1931)):
#0  0x000000361ec62c2d in _IO_proc_close@@GLIBC_2.2.5 () from /lib64/libc.so.6
#1  0x000000361ec6ca02 in _IO_new_file_close_it () from /lib64/libc.so.6
#2  0x000000361ec60db8 in fclose@@GLIBC_2.2.5 () from /lib64/libc.so.6
#3  0x00007f7dc088ec49 in sbUtStackTrace () from /app/oracle/product/fmw/../TimesTen/tt1122/lib/libtten.so
#4  0x00007f7dc087aa2e in sbDbInvalidSet () from /app/oracle/product/fmw/../TimesTen/tt1122/lib/libtten.so
#5  0x00007f7dc087aba8 in sbBailOutFn () from /app/oracle/product/fmw/../TimesTen/tt1122/lib/libtten.so
#6  0x00007f7dc0806207 in sbXactRollbackXcb () from /app/oracle/product/fmw/../TimesTen/tt1122/lib/libtten.so
#7  0x00007f7dbfe22dd7 in sbOLUndoByConn () from /app/oracle/product/fmw/../TimesTen/tt1122/lib/libtten.so
#8  0x000000000040c5c4 in doRollbackWork ()
#9  0x000000000040b9f2 in do_rollback ()
#10 0x0000000000407c0d in daHandler ()
#11 0x0000000000414f96 in handlerThread ()
#12 0x000000361f80673d in start_thread () from /lib64/libpthread.so.0
#13 0x000000361ecd3d1d in clone () from /lib64/libc.so.6

  

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