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 ONE Support launchpad (Login required).

Search for additional results

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