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
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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.