Table Locks On Compressed Columns Preventing Concurrent INSERT, UPDATE, And/Or DELETE Operations Resulting In eErors, TT6003: Lock request denied because of time-out. (Doc ID 1573220.1)

Last updated on NOVEMBER 04, 2016

Applies to:

Oracle TimesTen In-Memory Database - Version 11.2.2.2.0 to 11.2.2.5.0 [Release 11.2]
Oracle Exalytics Software - Version 1.0.0.0.0 to 1.0.0.3.0 [Release 1.0]
Information in this document applies to any platform.

Symptoms

Exalytics User has create TimesTen database with tables that use compressed columns (compressed columns is a feature that is currently only licensed for use with Exalytics).

User would attempt to do multiple concurrent INSERT, UPDATE, and/or DELETE operations but would get:

[TimesTen][TimesTen 11.2.2.4.0 ODBC Driver][TimesTen]TT6003: Lock request denied because of time-out

Details: LockWait[60000ms] Tran 19.25313 (pid 22024) wants X lock (from Sn)
on table TTEXA.MYCOMPRESSEDTABLE. But tran 20.10958 (pid 22128) has it
in Sn (request was Sn). Holder SQL ( ...

 

 

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