Symptom
SAP IQ secondary node aborts with 'blockmap userlocked during flush' message from ev_begintxn event session.
--.iqmsg & stacktrace
Collation 936ZHO, Case Respect, Blank Padding On, Comparisons are Conditioned
Txn 321054019 0 321054134
Connect: SA connHandle: 1004754404 SA connID: 9 IQ connID: 0007794776 User: dbo
ev_begintxn started
...
TxnWt 321054147 0 321054157
blockmap userlocked during flush; _blockmap @ 0x4449a3b8
Blockmap Member Variables for 0x4449a3b8
From dblib/db_table.cxx:3154
_nextPartitionForHelperFlush = 0
IsEBufNoWait = 0
IsProxyFreelist = 0
_OrigRootBlock = 1514635339
_Bio = 0x1ee2d88
_tempSpace = 0
_Bufman = 0x2aa5008 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 = 0x4c600a08
_perConnStats = 0x4ad58828
_tmp_rangePIDmap = 0
_nPhysicalWrites = 0
_nPhysicalReads = 8
_LockRefCount = 1
_PrefetchRefCount = 0
_ScanModeRefCount = 0
_DirtyList = 0x1707ac48
#DirtyReferences = 0
#DirtyLinks = 0
_pnext = 0x4a781558
_pprev = 0x5d03e618
_cacheSize = 0
_cache = 0
_nBlks = 0
_leaderCxtCursor = 0
_allowToFree = 0
_psuAll = 0
[s_blockmap_identity]
_UniqueId: 604409
_RootBlockId: 1514635339
_NEntries: 18
_LastWriterTxnId: 321054147
_LastWriterSavePoint: 3
_FanOutAndFlags2: 0x8
_Flags: 0xcd
_Version: 1
_NLinks: 1
_EntriesPerLink: 19959
_FirstAvailLink: 0
_MaxLink: 1
_ModNum: 4080
_RootModNum: 4079
[end s_blockmap_identity]
**************************************************
*** SAP IQ Abort:
*** From: slib/s_bufman.cxx:5764
*** PID: 22151
*** Message: blockmap userlocked during flush
*** Thread: 139922170234624 (TID: 30)
**************************************************
** Error from IQ connection: SA connHandle: 1004754404 SA connID: 9 IQ connID: 0007794776 User: dbo
** Time of error: 2018-11-21 22:10:40
** IQ Version: SAP IQ/16.0.110/10940/P/sp11.19
** OS info: IQ built on: Enterprise Linux64 - x86_64 - 2.6.18-194.el5, Executed on: Linux/HOSTNAME/2.6.32-696.3.1.el6.x86_64/#1 SMP Thu Apr 20 11:30:02 EDT 2017/x86_64
** Command status when error occured: COMMAND ACTIVE
** Command text:
Statement text unavailable
Dump all thread stacks at slib/s_bufman.cxx:5764 for PID: 22151
===== Thread Number 139922170234624 (IQ connID: 0007794776) =====
pcstkwalk
ucstkgentrace
DumpAllThreads
hos_ABORT
s_bufman::PrivateFlush
s_bufman::FlushToDisk
st_txncb::FlushCoalesce
st_txncb::FlushForCommit
st_txnMgr::FlushForCommit
st_command::DoCmdThroughResourceGate
st_iqtxn::FlushForCommit
UIQTxn_FlushForCommit+0x15
st_SAIQInterfaceInfo::callFunction
st_SAIQInterface::RunIQFunc
st_SAIQInterface::Execute
saint_iqthresholdtxn::FlushForCommit
ri_commit
Connection::commit_work
_ri_auto_commit
drop_table_or_view
DoExecuteStmt
exec_procedure_stmt
run_procedure
call_procedure
dbi_stmt_batch
DoExecuteStmt
db__execute_str
Connection::ExecMpxRPC
sp_iqmpxddlrunas2_internal
RunInternalProcedure
process_ext_int_remote_call
process_call
exec_procedure_stmt
run_procedure
dbi_call_user_function
dfe_FactoryUserFunction::PreBuildValAndArgs
dfe_Builder::DoBuildPrepExprValue
dfe_Builder::BuildPrepExprValueDom
dbi_assignvar
process_assign
exec_procedure_stmt
run_procedure
call_procedure
DB_Exec_event_handler
EventHandler::do_request
Worker::spawn
RQInternalBaseItem::do_work
RequestQueue::worker_body
request_task
run_task_body+0x2d
******************* End of STACKTRACE ******************
Read more...
Environment
- SAP IQ 16.0 SP11.19
- Multiplex Secondary node
Product
Keywords
"blockmap userlocked during flush"; "ev_begintxn"; "s_bufman::PrivateFlush"; "s_bufman::FlushToDisk"; "st_txncb::FlushCoalesce"; "st_txncb::FlushForCommit"; "st_txnMgr::FlushForCommit"; , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , 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.