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.