SAP Knowledge Base Article - Preview

2171575 - IQ server got crashed with 'Emergency buffer pool' error - SAP IQ

Symptom

1. SAP IQ server could crash while running sp_iqcheckdb() or any other operation with following error message.
  
     I. 05/19 10:13:18. 0000065127 ***   SAP IQ Abort:
     I. 05/19 10:13:18. 0000065127 ***      From:  slib/s_bufman.cxx:5008
     I. 05/19 10:13:18. 0000065127 ***      PID: 26274
     I. 05/19 10:13:18. 0000065127 ***      Message: Emergency buffer pool has no available clean buffers.

Stack trace:

     _Z13ucstkgentraceii + ...........
     _Z14DumpAllThreadsPKcji + ...........
     _Z9hos_ABORTPKcjS0_PcS1_ + ...........
     _ZN14s_bufpartition12GetCleanPageEP18s_bufman_errorInfoP22...........
     _ZN14s_bufpartition6CreateEP18s_bufman_errorInfoP22s_connectionCacheStats...........
     _ZNK10s_blockmap15GetPageBehaviorEv ...........          
     _ZN10s_blockmap14CreateDontZeroEsi13hos_cmprstypejj ...........
     _ZN13s_scratchPage9CreateBufEv ...........
     _ZN13v2s_bmcontext20bmlev1sgblkselfallocEiii + ...........
     _ZN13v2s_bmcontext11bmselfunionEP4s_bmRKS0_ + ...........
     _ZN4s_bm2OrEPKyj + ...........
     _ZN12s_bmOrCursor5FlushEv + ...........
     _ZN16s_bmRWCursorBase6AddBitEy + ...........
     _ZN9hs_xstats15MarkBlocksInUseEyy + ...........        
     _ZNK5s_buf15MarkBlocksInUseEP9hs_xstats + ...........
     _ZN15s_bArrayLocater15DbccCheckRidMapEP9hs_xstatsPK4s_bmRPyisR12s_bmOrCursor + ...........


Read more...

Environment

SAP IQ 16

Product

SAP IQ 16.0

Keywords

SAP IQ, crash, 784344, DBCC, sp_iqcheckdb, emergency buffer pool, _ZN14s_bufpartition12GetCleanPageEP18s_bufman_errorInfoP22, s_bufpartition, GetCleanPage , 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 for Me (Login required).

Search for additional results

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