SAP Knowledge Base Article - Preview

2243269 - SAP IQ15.4 ESD5.x, New server hang issue comes.

Symptom

A secondary server became unresponsive status and re-started later.
 Among MPX nodes, only this CNT server appeared that sttaus. But oter nodes and Coordi-servers were
 in normal running status.
 This server faced the problem suddenly and there was not important error or symptoms before the hang.
 
     .. I. 11/12 17:52:09. 0000284768 ev_begintxn started
     .. I. 11/12 17:52:09. 0000284767 Cmt 391160431
     .. I. 11/12 17:52:09. 0000284767 PostCmt 0
     .. I. 11/12 17:52:09. 0000284768 Cmt 391160432
     ..
     .. I. 11/12 17:52:09. 0000284768 PostCmt 365198570
     .. I. 11/12 17:52:09. 0000284768 TxnWt 391160439 0 365198570
     .. I. 11/12 17:52:34. 0000284770 Collation UTF8, Case Respect, Blank Padding On, Comparisons are Conditioned
     .. I. 11/12 17:52:34. 0000284771 Collation UTF8, Case Respect, Blank Padding On, Comparisons are Conditioned
     .. I. 11/12 17:52:38. 0000284772 Collation UTF8, Case Respect, Blank Padding On, Comparisons are Conditioned
     .. I. 11/12 17:52:38. 0000284773 Collation UTF8, Case Respect, Blank Padding On, Comparisons are Conditioned

 From dumped stack, i saw key symbol 'DestroyAllMappedPages', but it looks not match with a fixed issue (CR 791092) ,in ESD5.8.
 
 Following threads are looked strange. 
 Thread 1049329 seems to call 'DestroyAllMappedPages' while cursor closing and csort was running.

      ---------- tid# 1049329  ------
       ..  _global_lock_common ...
       ..  _mutex_lock ...
       ..  s_dbmvbio::DeAllocate ...
       ..  s_blockmap::Deallocate ...
       ..  s_bufpartition::Destroy ...
       ..  s_blockmap::DestroyAllMappedPages ...

      ---------- tid# 1769991 -------
       ..  _global_lock_common
       ..  _mutex_lock
       ..  hos_mutex::Lock
       ..  hos_condvar::Lock
       ..  s_dbmvbio::Allocate
       ..  s_blockmap::Allocate
       ..  s_blockmap::CreateLink
       ..  s_blockmap::AllocateLogicalBlockId


Read more...

Environment

SAP IQ 15.4

Product

SAP IQ 16.0 ; SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4 ; Sybase IQ 12.7

Keywords

CreateLink ; DestroyAllMappedPages ; , 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.