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 for Me (Login required).

Search for additional results

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