Datastore Invalidation at ttdbkedDefDump (Doc ID 1915739.1)

Last updated on FEBRUARY 27, 2016

Applies to:

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

Symptoms

Subdaemon PID 34842 died here:

2014-05-05 04:22:02.83 Info: : 34838: 34842/0x1aa5ba0: ttdbkedDefDump: Error 600 'ORA-00600: internal error code, arguments: [17099], [], [], [], [], [], [], [], [], [], [], [] '

Details on why it died:

Subdaemon has died in kgttulcuByPidPhase1 in function kgeriv_int():

2014-05-05 04:22:02.81 Info: : 34842: 27306 doRollbackWork: sbOLUndoByConn for connid 74 (extprocPLSExtProc) returned 0
2014-05-05 04:22:02.82 Info: : 34838: 34842/0x1aa5ba0: subd: ttProcessDeathCleanupByPidPhase1 pid 27306
2014-05-05 04:22:02.82 Info: : 34838: 34842/0x1aa5ba0: ttHeapRecoverByPid(27306) entered
2014-05-05 04:22:02.82 Info: : 34838: 34842/0x1aa5ba0: ttHeapRecoverByPid: conn 74
2014-05-05 04:22:02.82 Info: : 34838: 34842/0x1aa5ba0: ttHeapRecoverByPid(27306): exits
2014-05-05 04:22:02.82 Info: : 34838: 34842/0x1aa5ba0: kgttulcuByPidPhase1(27306) starts

2014-05-05 04:22:02.83 Info: : 34838: 34842/0x1aa5ba0: ttdbkedDefDump: Error 600 'ORA-00600: internal error code, arguments: [17099], [], [], [], [], [], [], [], [], [], [], [] '

stack trace

$ grep FRAME pid34842
2014-05-05 04:22:02.93 Info: : 34838: 34842/0x1aa5ba0: ========== FRAME [1] (kgdsdstsg()+48 -> kgdsdst()) ==========
2014-05-05 04:22:02.93 Info: : 34838: 34842/0x1aa5ba0: ========== FRAME [2] (kgettDumpStack()+721 -> kgdsdstsg()) ==========
2014-05-05 04:22:02.94 Info: : 34838: 34842/0x1aa5ba0: ========== FRAME [3] (ttdbkedDefDump()+682 -> kgettDumpStack()) ==========
2014-05-05 04:22:02.95 Info: : 34838: 34842/0x1aa5ba0: ========== FRAME [4] (kgttdmp()+40 -> ttdbkedDefDump()) ==========
2014-05-05 04:22:02.95 Info: : 34838: 34842/0x1aa5ba0: ========== FRAME [5] (kgeriv_int()+194 -> kgttdmp()) ==========
2014-05-05 04:22:02.95 Info: : 34838: 34842/0x1aa5ba0: ========== FRAME [6] (kgeriv()+12 -> kgeriv_int()) ==========
2014-05-05 04:22:02.96 Info: : 34838: 34842/0x1aa5ba0: ========== FRAME [7] (kgesiv()+110 -> kgeriv()) ==========
2014-05-05 04:22:02.96 Info: : 34838: 34842/0x1aa5ba0: ========== FRAME [8] (kgesic0()+132 -> kgesiv()) ==========
2014-05-05 04:22:02.96 Info: : 34838: 34842/0x1aa5ba0: ========== FRAME [9] (kgttulcuByPidPhase1()+1047 -> kgesic0()) ==========
2014-05-05 04:22:02.97 Info: : 34838: 34842/0x1aa5ba0: ========== FRAME [10] (ttProcessDeathCleanupByPidPhase1()+95 -> kgttulcuByPidPhase1()) ==========
2014-05-05 04:22:02.97 Info: : 34838: 34842/0x1aa5ba0: ========== FRAME [11] (ttc_processDeathCleanupByPidPhase1()+4 -> ttProcessDeathCleanupByPidPhase1()) ==========
2014-05-05 04:22:02.97 Info: : 34838: 34842/0x1aa5ba0: ========== FRAME [12] (do_rollback()+1667 -> ttc_processDeathCleanupByPidPhase1()) ==========
2014-05-05 04:22:02.98 Info: : 34838: 34842/0x1aa5ba0: ========== FRAME [13] (daHandler()+4078 -> do_rollback()) ==========
2014-05-05 04:22:02.99 Info: : 34838: 34842/0x1aa5ba0: ========== FRAME [14] (handlerThread()+2270 -> daHandler()) ==========
2014-05-05 04:22:03.00 Info: : 34838: 34842/0x1aa5ba0: ========== FRAME [15] (start_thread()+209 -> handlerThread()) ==========
2014-05-05 04:22:03.00 Info: : 34838: 34842/0x1aa5ba0: ========== FRAME [16] (clone()+109 -> start_thread()) ==========
2014-05-05 04:22:03.01 Info: : 34838: 34842/0x1aa5ba0: ========== FRAME [17] (0000000000000000 -> clone()) ==========

Note subdaemon 38482 was already rolling back another pid, 15828, and had also reached kgttulcuByPidPhase1 just before it started work rolling back pid 27306

2014-05-05 04:20:01.50 Info: : 34842: subd: rollback pid 15828
2014-05-05 04:20:01.50 Info: : 34842: subd: found 1 connection belonging to pid 15828
2014-05-05 04:20:01.50 Info: : 34842: 15828 doRollbackWork: Calling sbOLUndoByConn for connid 12 (extprocPLSExtProc)
2014-05-05 04:20:01.50 Warn: : 34838: 34842/0x7f9833da12a0: sbOLUndoByConn: oplog stack for connid 12 (extprocPLSExtProc) pid 15828:
2014-05-05 04:20:02.37 Info: : 34842: 15828 doRollbackWork: sbOLUndoByConn for connid 12 (extprocPLSExtProc) returned 0
2014-05-05 04:20:02.37 Info: : 34838: 34842/0x1aa5ba0: subd: ttProcessDeathCleanupByPidPhase1 pid 15828
2014-05-05 04:20:02.37 Info: : 34838: 34842/0x1aa5ba0: ttHeapRecoverByPid(15828) entered
2014-05-05 04:20:02.37 Info: : 34838: 34842/0x1aa5ba0: ttHeapRecoverByPid: conn 12
2014-05-05 04:20:02.37 Info: : 34838: 34842/0x1aa5ba0: ttHeapRecoverByPid(15828): exits
2014-05-05 04:20:02.37 Info: : 34838: 34842/0x1aa5ba0: kgttulcuByPidPhase1(15828) starts


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