Complex Deadlock With Latches And Not Able To Connect

(Doc ID 1921531.1)

Last updated on FEBRUARY 27, 2016

Applies to:

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

Symptoms

Not able to make new connection. 

Here are the warnings in ttmesg log:

2014-06-30 18:45:26.70 Warn:    : 14589: 14594/0x14140250: ConnId=2 (Rollback) waiting for latch "User"(18446697709266828320), Holder=9 (java) PID 2296, now 147020 secs
2014-06-30 18:45:27.30 Warn:    : 14589: 3063/0x16cc02b0: ConnId=13 (java) waiting for latch "User"(18446697709243759648), Holder=9 (java) PID 2296, now 190170 secs
2014-06-30 18:45:27.33 Warn:    : 14589: 2252/0x1a6d62b0: ConnId=1 (java) waiting for latch "User"(18446697709243759648), Holder=9 (java) PID 2296, now 190360 secs
2014-06-30 18:45:27.60 Warn:    : 14589: 14594/0x142319f0: ConnId=888 (Deadlock Detector) waiting for latch "User"(18446697709266828320), Holder=9 (java) PID 2296, now 190000 secs
2014-06-30 18:45:28.11 Warn:    : 14589: 14594/0x143d9870: ConnId=883 (HistGC) waiting for latch "User"(18446697709266828320), Holder=9 (java) PID 2296, now 180860 secs
2014-06-30 18:45:28.16 Warn:    : 14589: 3068/0x581c2b0: ConnId=17 (java) waiting for latch "User"(18446697709243759648), Holder=9 (java) PID 2296, now 190350 secs
2014-06-30 18:45:28.98 Warn:    : 14589: 30618/0x14522b0: ConnId=14 (java) waiting for latch "User"(18446697709243759648), Holder=9 (java) PID 2296, now 190540 secs

 

pstack of holder pid 2296:

Thread 1 (Thread 0x2b3be7c0b7a0 (LWP 2296)):
#0  0x0000003d5840d4c4 in __lll_lock_wait () from /lib64/libpthread.so.0
#1  0x0000003d58408e1a in _L_lock_1034 () from /lib64/libpthread.so.0
#2  0x0000003d58408cdc in pthread_mutex_lock () from /lib64/libpthread.so.0
#3  0x00002aaaaadcd81d in sbSendReqToDaemonLen () from /app/TimesTen/ttpsrevent1/lib/libtten.so
#4  0x00002aaaaadcd73d in sbDaemonLog () from /app/TimesTen/ttpsrevent1/lib/libtten.so
#5  0x00002aaaab2534ca in sbSpinLatchGetAs () from /app/TimesTen/ttpsrevent1/lib/libtten.so
#6  0x00002b3be8c5fba9 in ttLatchGet () from /app/TimesTen/ttpsrevent1/lib/libttco.so
#7  0x00002b3bea01288f in kghalo () from /app/TimesTen/ttpsrevent1/lib/libttco.so
#8  0x00002b3bea0de665 in kghxal () from /app/TimesTen/ttpsrevent1/lib/libttco.so
#9  0x00002b3be8c5dd06 in kgttucac () from /app/TimesTen/ttpsrevent1/lib/libttco.so
#10 0x00002b3be8c145e2 in ttsClean () from /app/TimesTen/ttpsrevent1/lib/libttco.so
#11 0x00002b3be80021b5 in ttc_ttsClean () from /app/TimesTen/ttpsrevent1/lib/libttco.so
#12 0x00002aaaab2561f0 in stmtExecute () from /app/TimesTen/ttpsrevent1/lib/libtten.so
#13 0x00002aaaab2da28b in SQLExecute () from /app/TimesTen/ttpsrevent1/lib/libtten.so
#14 0x0000000000410f32 in SQLExecute ()
#15 0x000000000042c017 in CSrvOdbcRecSet::ExecSqlStmt(int) ()
#16 0x000000000042b3b3 in CSrvOdbcRecSet::doTask() ()
#17 0x000000000042cebe in CSrvOdbcRecSet::DoBld(CMessage**) ()
#18 0x000000000041bf6a in CSrvOdbcDb::Run(unsigned char*, unsigned int) ()
#19 0x00000000004351fd in COSTcp::HandleConnect() ()
#20 0x000000000042e978 in HandoffConnect(CSrvCtx*, SHARETCP*, int) ()
#21 0x000000000040d5e4 in main ()

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