My Oracle Support Banner

Resolve TimesTen Error "sbDictTblsRebuild failed on table" where subdaemon gets segv during datastore recovery on Exalytics (Doc ID 1566989.1)

Last updated on FEBRUARY 19, 2019

Applies to:

Oracle TimesTen In-Memory Database - Version 11.2.2.5.0 to 11.2.2.5.1 [Release 11.2]
Information in this document applies to any platform.

Goal

This customer ran into a segv in SBCDREFCNTOP during data dictionary rebuild in recovery.
It is believed this bug will be encountered if a batch inserting to a table with many compressed
columns is killed, and the datastore needs to go through recovery thereafter.

Here are the salient lines in the subsequent recovery failure:

21:49:09.24 Info:    :  8642: 8646/0x403e6200: sbDoBadDictTblRebuild[0]:
Rebuilding dictionaries on table MY.MADEUPNAME (1732496) Rows: 1888005
...
21:49:09.44 Warn:    :  8642: child process 8646 terminated with signal 11
(core dump)

From a gdb on core.8646 (attached) we see:

Core was generated by
`/u01/app/oracle/product/TimesTen/tt1122/bin/timestensubd -verbose -userlog
tter'.

Program terminated with signal 11, Segmentation fault.

#0  0x00007f6f78692dcf in sbCDRefCntOp () from
/u01/app/oracle/product/TimesTen/tt1122/lib/libtten.so

Thread 1 (Thread 17186):

#0  0x00007f6f78692dcf in sbCDRefCntOp () from
/u01/app/oracle/product/TimesTen/tt1122/lib/libtten.so
#1  0x00007f6f78692b46 in sbDictTblsRebuild () from
/u01/app/oracle/product/TimesTen/tt1122/lib/libtten.so
#2  0x00007f6f785b9e63 in sbDoBadDictTblRebuild () from
/u01/app/oracle/product/TimesTen/tt1122/lib/libtten.so
#3  0x0000003dd6e0673d in start_thread () from /lib64/libpthread.so.0
#4  0x0000003dd62d3d1d in clone () from /lib64/libc.so.6

 

 

 


 

Solution

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
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.