Symptom
Secondary server may fail with following fatal stack trace frames and diagnostic messages in .iqmsg.
---
s_bufman::PrivateFlush
s_bufman::FlushToDisk
st_txncb::FlushCoalesce
st_txncb::FlushForCommit
st_txnMgr::FlushForCommit
st_command::DoCmdThroughResourceGate
st_iqtxn::FlushForCommit
UIQTxn_FlushForCommit
st_SAIQInterfaceInfo::callFunction
st_SAIQInterface::RunIQFunc
st_SAIQInterface::Execute
saint_iqthresholdtxn::FlushForCommit
ri_commit
Connection::commit_work
_ri_auto_commit
iq_alter_mpxversionlist
dbi_iq_alter_mpxserver
DoExecuteStmt
db__execute_str
Connection::ExecMpxRPC
sp_iqmpxddlrunas2_internal
RunInternalProcedure
process_ext_int_remote_call
---
blockmap userlocked during flush; _blockmap @ 0x7ffb441b8b88
Blockmap Member Variables for 0x7ffb441b8b88
From dblib/db_table.cxx:3052
_nextPartitionForHelperFlush = 0
IsEBufNoWait = 0
IsProxyFreelist = 0
_OrigRootBlock = 811132169
_Bio = 0x7ffbec15fe48
_tempSpace = 0
_Bufman = 0x7ffbec041808 main Bufman
_allocFromLastLink = 1
_isMeta = 1
_m_dbspaceID = 16387
_dbspaceID = 16387
_rangePIDmap = 0
_useGlobalLBNs = 0
_isDistributedOwner = 0
_LBNOffset = 1
_LBNBase = 1
_nextGlobalLBN = 1
_RWAccess = 1
_gotIdentity = 0
_gotIdentityWithNoEntries = 0
_allocationPrivilege = 0
_pageInfo = 0x7ffb440addc8
_perConnStats = 0x7ffb441ba3d8
_tmp_rangePIDmap = 0
_nPhysicalWrites = 0
_nPhysicalReads = 0
_LockRefCount = 1
_PrefetchRefCount = 0
_ScanModeRefCount = 0
_DirtyList = 0x7ffb46290b88
#DirtyReferences = 0
#DirtyLinks = 0
_pnext = 0x7ffb441d09f8
_pprev = 0x7ffb440efb08
_cacheSize = 0
_cache = 0
_nBlks = 0
_leaderCxtCursor = 0
_allowToFree = 0
_psuAll = 0
[s_blockmap_identity]
_UniqueId: 223906773
_RootBlockId: 811132169
_NEntries: 4
_LastWriterTxnId: 329626921
_LastWriterSavePoint: 1
_FanOutAndFlags2: 0x8
_Flags: 0xcd
_Version: 1
_NLinks: 1
_EntriesPerLink: 19959
_FirstAvailLink: 0
_MaxLink: 1
_ModNum: 4
_RootModNum: 3
[end s_blockmap_identity]
**************************************************
*** SAP IQ Abort:
*** From: slib/s_bufman.cxx:5506
*** PID: 26564
*** Message: blockmap userlocked during flush
*** Thread: 140715162830592 (TID: 56)
**************************************************
Read more...
Environment
IQ 16 sp11 pl11+
Product
Keywords
slib/s_bufman.cxx:5506 , blockmap userlocked , s_blockmap_identity , s_bufman::PrivateFlush , s_bufman::FlushToDisk , st_txncb::FlushCoalesce , iq_alter_mpxversionlist , dbi_iq_alter_mpxserver , Connection::ExecMpxRPC , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed
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