Symptom
While a delete query was running on a table with P-key, first error appeared and stack trace like below. After that, 's_blockmap::ThrowError for user locked blockmap' appeared.
*.iqmsg >>
... Collation UTF8, Case Respect, ...
...
.. RemoveDirtiable sbuf:0x7fced7f9a4f0 txn:408934892|408749049
.. ** Informational stack trace from Duplicate buffer insertion detected, exiting buf: 0x7fced7f9a4f0
.. ** at slib/s_bufhash.cxx:381 on thread 140528009553664 (TID 1086)
.. **
..
.. StackTraceForThisThread ..
.. s_bufhash::RemoveEntryInsertHelper ..
.. s_bufhash::FindHelper ..
.. s_bufhash::Find ..
.. s_bufpartition::FindInHT ..
.. s_bufpartition::FindForPrefetchCommonPreIO ..
.. s_bufpartition::FindForSubmitPrefetch ..
.. s_blockmap::SubmitPrefetch ..
.. s_aioPrefetchMgr::AddRequest ..
.. s_prefetch::FindInMemoryOrPrefetch ..
.. s_btlvlcursor<s_btdiskblock, s_btitem>::DoPrefetch ..
..
.. BUFHASH_FIND_ERROR2:: tid:140528400094976 hashKey:1905 primaryKey:175070504 blockNumber:82877 modnum:14/15 firstPhysBlock:1078229442 rolloverToggle:0
.. Warning: s_blockmap is throwing while user locked. bmp:0x7fcfd25e4238 lockRefCount:1 created from:slib/s_ohcidx.cxx:7173 locked from:slib/s_blockmap.cxx:1341
..
.. ** Informational stack trace from Diagnostic Stacktrace in s_blockmap::ThrowError for user locked blockmap
.. ** at slib/s_blockmap.cxx:13534 on thread 140528400094976 (TID 715)
Read more...
Environment
SAP IQ16.1 SP04 PL09
Product
Keywords
RemoveDirtiable , RemoveEntryInsertHelper , s_bufhash , "Duplicate buffer insertion" , "user locked blockmap","locked blockmap", s_blockmap , , KBA , BC-SYB-IQ , Sybase IQ , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview