SAP Knowledge Base Article - Preview

2757743 - IQ server abort at s_blockmap::DestroyAllMappedPages when the server runs out of temporary buffer pool

Symptom

During peak processing times SQL transactions start to fail with s_nobuffersexception errors because of lack of Temp cache.
This can lead to the IQ process crashing with an abort from s_blockmap.cxx:5051 “Failure on privileged blockmap” and stacktrace.

  • stack trace:
    s_blockmap::DestroyAllMappedPages()
    hs_dp::Destroy
    db_IndexDef::DestroyIndex
    db_destroyTableIter::ExecWork
    workAllocator::DoWork
    hos_thread::Main
  • Many connections throwing these types of errors:
    I. 02/08 13:10:06. 0000491834 temp Bufman: All buffer cache pages are in use, ask your DBA to increase the size of the buffer cache. Current buffer cache is 307200MB. (slib/s_bufman.cxx:2938)
    I. 02/08 13:10:06. 0000491834 Exception Thrown from slib/s_blockmap.cxx:5849, Err# 0, tid 1650 origtid 1650
    I. 02/08 13:10:06. 0000491834    O/S Err#: 0, ErrID: 2097 (s_nobuffersexception); SQLCode: -1009031, SQLState: 'QSA31', Severity: 14
    I. 02/08 13:10:06. 0000491834 [20052]: temp Bufman: All buffer cache pages are in use, ask your DBA to increase the size of the buffer cache. Current buffer cache is 307200MB. 
    -- (slib/s_blockmap.cxx 5849)
  • Then one throws the abort:
    I. 02/08 13:10:06. 0000491209 temp Bufman: All buffer cache pages are in use, ask your DBA to increase the size of the buffer cache. Current buffer cache is 307200MB. (slib/s_bufman.cxx:3710)
    I. 02/08 13:10:06. 0000491209 Failure on privileged blockmap
    I. 02/08 13:10:06. 0000491209 Blockmap Member Variables for 0x7ff17c06aa48
    I. 02/08 13:10:06. 0000491209 From slib/s_dpidx.cxx:591
    ….
    I. 02/08 13:10:06. 0000491209 **************************************************
    I. 02/08 13:10:06. 0000491209 ***   SAP IQ Abort:
    I. 02/08 13:10:06. 0000491209 ***      From:  slib/s_blockmap.cxx:5051
    I. 02/08 13:10:06. 0000491209 ***      PID: 88355
    I. 02/08 13:10:06. 0000491209 ***      Message: Failure on privileged blockmap
    I. 02/08 13:10:06. 0000491209 ***      Thread: 140658298345216  (TID: 2162)
    I. 02/08 13:10:06. 0000491209 **************************************************




Read more...

Environment

SAP IQ 16.1

Product

SAP IQ 16.1

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

Search for additional results

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