SAP Knowledge Base Article - Preview

2726119 - SAP IQ secondary node aborts with 'blockmap userlocked during flush' message from ev_begintxn event session

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

SAP IQ 16.0

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.