In OAS Cluster System, Obis Crashes Frequently in CacheEntryStorage<BasicCompression>::PurgingHeaderFromBV (Doc ID 3046446.1)

Last updated on OCTOBER 18, 2024

Applies to:

Symptoms

After upgrading lower version OAS Cluster System to OAS 2023, Obis crashes frequenly in CacheEntryStorage<BasicCompression>::PurgingHeaderFromBV.

obis1-diagnostic.log shows:
------------------------------
[2024-08-07T10:17:30.348+09:00] [OBIS] [NOTIFICATION:1] [] [] [ecid: 0067kqgAZDkFk33_vlT4iX0000ys0000F9,0] [sik: ssi] [tid: 489f700] [nQSError: 58012]
[<TS>] [OBIS] [NOTIFICATION:1] [] [] [ecid: <ecid>] [sik: bootstrap] [tid: <tid>] [nQSError: 58012] After 10 trials, still can not lock file <global cache folder>/NQS_obis2_739107_36384_8.TBL. [[
[nQSError: 52041] Can not access file, <global cache folder>/NQS_obis2_739107_36384_8.TBL, at global storage.

strack trace for obis shows:

------------------------------

$1 = Crashing thread
#0 CopyFromDataBlob<unsigned short> (srcPtr=0x7f3d69cca002 , value=<optimized out>)
at server/Utility/Generic/PrivateInclude/SUGUtilTemplates.h:42
#1 DataBlobUtil::GetUInt16 (dataPtr=dataPtr@entry=0x7f3d69cca000 ) at server/Utility/Generic/Src/SUGMarshal.cpp:274
#2 0x00007f3e0fd73aa0 in DataBlobUtil::GetString (dataPtr=0x7f3d69cca000 , dataPtr@entry=0x7f3d69c2b10a 1,
bHasSizeLimit=bHasSizeLimit@entry=true, endPtr=endPtr@entry=0x0) at server/Utility/Generic/Src/SUGMarshal.cpp:363
#3 0x00007f3e0fd73c8f in DataBlobUtil::FromByteVector (start=0x7f3d69c2b10a 1, value=...,
bHasSizeLimit=bHasSizeLimit@entry=true, endPtr=endPtr@entry=0x0) at server/Utility/Generic/Src/SUGMarshal.cpp:738
#4 0x00007f3e1a407c6d in CacheEntryStorage<BasicCompression>::PurgingHeaderFromBV (this=this@entry=0x7f3df766e630,
pLoc=<optimized out>, pLoc@entry=0x7f3d69c2b02a \025)
at server/Query/Execution/CacheStorage/PrivateInclude/SQCSCachePhysicalEntryStorage.h:459
#5 0x00007f3e1a407fc6 in CacheEntryStorage<BasicCompression>::ConstructHeader (this=this@entry=0x7f3df766e630)
at server/Query/Execution/CacheStorage/PrivateInclude/SQCSCachePhysicalEntryStorage.h:640
#6 0x00007f3e1a406277 in CachePhysicalEntryFactory::Make (fileName=..., pStats=0x7f3d65715cd8)
at server/Query/Execution/CacheStorage/Src/SQCSCachePhysicalEntryImpl.cpp:62
#7 0x00007f3e19d77ea2 in CACPollMgr::RetrieveAll (this=this@entry=0x7f3df7b8b790)
at server/Query/Optimizer/Cache/Src/SQOCCACPollMgr.cpp:516
#8 0x00007f3e19d7a086 in CACPollMgr::Poll (this=0x7f3df7b8b790)
at server/Query/Optimizer/Cache/Src/SQOCCACPollMgr.cpp:450
#9 0x00007f3e19d7a231 in pollthread_impl::SimpleWorkerAdapter<CACPollMgr>::execute2WorkerFunction (
pHints=<optimized out>, function=<optimized out>, p=<optimized out>)
at server/include/Utility/Generic/SUGPollThread.h:282
#10 PollThread<CACPollMgr, pollthread_impl::SimpleWorkerAdapter<CACPollMgr> >::execute (this=<optimized out>,
pHints=<optimized out>) at server/include/Utility/Generic/SUGPollThread.h:572
#11 0x00007f3e0fdc3579 in PeriodicTasksExecutor::PeriodicTaskBaseAndInfo::run (this=0x7f3d6573e9a8)
at server/Utility/Generic/Src/PeriodicTasksExecutor.cpp:230
#12 0x00007f3e0fd7010b in NQExecutionState::ExecuteSystemMain (this=this@entry=0x7f3d6770d188)
at server/Utility/Generic/NQThreads/SUGExecutionState.cpp:93
#13 0x00007f3e0fdb1321 in NQThreadJobBase::ExecuteSystemMain (this=0x7f3d6770d188)
at server/Utility/Generic/NQThreads/SUGThreadJob.cpp:179
#14 0x00007f3e0fdb26f6 in ManagedJobFunctor::operator() (this=0x7f3e1ab6a168)
at server/include/Utility/Generic/SUGThreadJob.h:197
#15 PoolThread::ExecuteUserMain (this=0x7f3e1ab69d88) at server/Utility/Generic/NQThreads/SUGThreadServerPool.cpp:564
#16 0x00007f3e0fd7010b in NQExecutionState::ExecuteSystemMain (this=this@entry=0x7f3e1ab69d88)
at server/Utility/Generic/NQThreads/SUGExecutionState.cpp:93
#17 0x00007f3e0fdb0b6b in NQThread::ExecuteSystemMain (this=0x7f3e1ab69d88)
at server/Utility/Generic/NQThreads/SUGThread.cpp:311
#18 0x00007f3e0fdaff3f in NQThread::ThreadMainEntry (pNQThread=0x7f3e1ab69d88)
at server/Utility/Generic/NQThreads/SUGThread.cpp:275
#19 0x00007f3e0e01b1da in start_thread () from /lib64/libpthread.so.0
#20 0x00007f3e0d357e73 in clone () from /lib64/libc.so.6
$2 = Backtrace of all threads

Changes

Enabling cluster aware cache

Cause

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