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.