SAP Knowledge Base Article - Preview

3791369 - MPX server secondary node Emergency shutdown with error SQLSTATE:54W19 — SAP IQ

Symptom

  • Further to application upgrade and Coordinator restart, MPX server performance decreased
  • Transactions Version store grew continuously.
  • One secondary node abruptly stopped further to error SQLSTATE:54W19and Emergency shutdown messages :
     I. xxx. yyy TxnT 3889943853 3881342966 3881342966
     I. xxx. yyy Cmt 3889943854 Txn 3889943853
    ....
     I. xxx. yyy Disposition: SQLSTATE:54W19  [ No recovery!! ]
     I. xxx. yyy ***Emergency Shutdown***

  • 2 hours later, another secondary node crashed on "Assertion failed: 109516 (Memory exhausted)”.


Read more...

Environment

  • SAP IQ
  • Multiplex System

Product

SAP IQ all versions

Keywords

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.