SAP Knowledge Base Article - Preview

2262831 - A secondary server got hung while concurrent DML sessions were running.

Symptom

1. A secondary IQ server got hung while replaying tlvlog.
   The other IQ servers including the coordinator server were working fine at that time.
   
   I. 12/31 15:18:26. 0000745281 Connect:  SA connHandle: 1000713709  SA connID: 62  IQ connID: 0000745281  User: dbo
   I. 12/31 15:18:26. 0000745281 ev_begintxn started
   I. 12/31 15:18:26. 0000745281 Cmt 429025692
   I. 12/31 15:18:26. 0000745281 PostCmt 377613965
   I. 12/31 15:18:26. 0000745281 Txn 429025693 0 377613965
   I. 12/31 15:18:26. 0000745281 Cmt 429025694
   I. 12/31 15:18:26. 0000745281 PostCmt 0
   I. 12/31 15:18:26. 0000745281 TxnWt 429025695 0 377613965
   I. 12/31 15:18:26. 0000745281 Cmt 429025696
   I. 12/31 15:18:26. 0000745281 PostCmt 0
   I. 12/31 15:18:26. 0000745281 Txn 429025697 0 377613965
   I. 12/31 15:18:26. 0000745281 Cmt 429025698
   I. 12/31 15:18:26. 0000745281 PostCmt 377613965
   I. 12/31 15:18:26. 0000745281 TxnWt 429025699 0 377613965
   I. 12/31 15:28:51. 0000000000 Cancellation request received:  SA connHandle: 31159  SA connID: 58  IQ connID: 0000745144  User: user001
   I. 12/31 15:37:26. 0000000000 Cancellation request received:  SA connHandle: 31129  SA connID: 38  IQ connID: 0000744193  User: user002
   I. 12/31 15:37:26. 0000000000 Cancellation request received:  SA connHandle: 31132  SA connID: 6  IQ connID: 0000744245  User: user003
   I. 12/31 15:42:05. 0000000000 Cancellation request received:  SA connHandle: 31167  SA connID: 11  IQ connID: 0000745253  User: user004

2. There were no keywords, such as GetPageFrame, GetCleanPage or DestroyAllMappedPages, to suspect the EBP hang issue in the procstack dumps.
   In case of procstack dumps from the coordinator, it was normal because it had no problematic situation at that times.

3. Notable thread stacks from the secondary server
  1) --------- tid# 16581193 (pthread ID:  54485) ----------
    _global_lock_common( ...
    _mutex_lock( ...
    s_iqstore::LockFL()( ...
    st_txncb::PrepareToCommit2()( ...
    st_txnMgr::PrepareToCommit( ...
    db_PrepareToCommit::Execute()( ...
    st_command::DoCmdThroughResourceGate()( ...
    st_iqtxn::PrepareToCommit( ...
    UIQTxn_PrepareToCommit( ...
    st_SAIQInterfaceInfo::callFunction()( ...
    st_SAIQInterface::RunIQFunc(st_SAIQInterfaceInfo*)( ...
    st_SAIQInterface::Execute(int,void*,unsigned int(*)( ...
    saint_iqthresholdtxn::PrepareToCommit(IConnection*)( ...
    DB_Commit_Chgs(Connection*)( ...
    ri_commit(Connection*)( ...
    ...
    
  2) ---------- tid# 42270829 (pthread ID:  52943) ----------
    _global_lock_common( ...
    _mutex_lock( ...
    s_VersioningBlockmap::Allocate(s_bufman_errorInfo*, ...
    s_blockmap::AllocOrReallocPhysicalBlocks(s_bufman_errorInfo*, ...
    s_buf::Write(s_bufman_errorInfo*,hos_bio::allocPrivilege,int)( ...
    s_blockmap::Flush(s_bufman_errorInfo*)( ...
    s_bufman::PrivateFlush(unsigned long)( ...
    s_bufman::ReleaseSavepoint( ...
    st_txncb::ReleaseSavepoint( ...
    st_txnMgr::ReleaseSavepoint( ...
    db_ReleaseSavepoint::Execute()( ...
    st_command::DoCmdThroughResourceGate()( ...
    st_iqtxn::ReleaseSavepoint(UIConnection*, ...
    UIQTxn_ReleaseSavepoint( ...
    ...


Read more...

Environment

SAP IQ 15.4 ESD 5.x

Product

SAP Sybase IQ 15.4

Keywords

Secondary server, unresponsive, "s_iqstore::LockFL" ; "s_buf:WaitForSignal_DontCareIfBusy" ; , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.