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

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( ...
    ...

SAP IQ 15.4 ESD 5.x

Secondary server, unresponsive, "s_iqstore::LockFL" ; "s_buf:WaitForSignal_DontCareIfBusy" ; , KBA , BC-SYB-IQ , Sybase IQ , Problem