SAP Knowledge Base Article - Preview

3214060 - While deleting data, 's_blockmap::ThrowError for user locked blockmap' has been occurred and detected inconsistency on P-key (HG) -- SAP IQ

Symptom

While a delete query (0004751139) 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

SAP IQ 16.1

Keywords

RemoveDirtiable , RemoveEntryInsertHelper  , s_bufhash , "Duplicate buffer insertion" , "user locked 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.