SAP Knowledge Base Article - Preview

2825208 - IQ server terminated when IQ_SYSTEM_TEMP is full - SAP IQ

Symptom

  • SAP IQ could crash when IQ_SYSTEM_TEMP dbspace is full. For MPX, when IQ_SYSTEM_TEMP dbspace is full on a MPX node, this node could crash.
  • The following messages can be seen in iqmsg file:

    • Allocation failed. Dbspace IQ_SYSTEM_TEMP is OUT OF SPACE
      Allocation successful. Dbspace IQ_SYSTEM_TEMP

    • Non-Fatal IQ Internal Error Detected
      at slib/s_blockmap.cxx:7290 on thread 140350221338368 (TID 1561)
      with Query_Name: distinct_count
      Stack at point where server ran out of unprivileged space

    • Stack trace includes the following functions:
      s_blockmap::ThrowIfOutOfSpace
      s_blockmap::FindAndMakeDirtiable
      s_pageListCursor::PositionPage
      v2s_bmcontext::LoadPage
      v2s_bmcontext::bmlev1sgblkselfget
      v2s_bmcontext::bmselfsetrng
      s_bm::SetBits
      s_mergeFINALWriter::TokenizeNulls
      s_mergeFINALWriter::TokenizeNullableRows
      s_mergeFINALWriter::ProcessToken
      s_mergeFINALWriter::WriteLHSToken
      s_mergeFINALWriter::DoInsert
      hs_dpInsert::Insert(s_ColumnVector const*)


Read more...

Environment

  • SAP IQ 16.0
  • SAP IQ 16.1

Product

SAP IQ 16.0 ; SAP IQ 16.1

Keywords

CR819840 ; CR#819840 ; 819840; ThrowIfOutOfSpace ; s_bt::BTFFindEQPREV ; , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , HAN-DYT , SAP HANA Dynamic Tiering , 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.