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

CR813468, CR-813468, CR 813468, IQ , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed

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.