SAP Knowledge Base Article - Preview

2826663 - "Warning, s_bufpartition::GetCleanPage is retrying to avert a potential deadlock" reported in SAP IQ message log

Symptom

  • sp_iqcheckdb report no error.
  • IQ message log report the following messages when modifying objects:

    • [bmp-trace-tout][rpbid] tid:140695968622336 bmp:0x7f53c265e3c8 lbn:784284 next-lbn:784288 pbn:201589250 nb: compr?1 updateNext?0

    • Warning, s_bufpartition::GetCleanPage is retrying to avert a potential deadlock, retry=1, tid=140695989229312

    • Warning: s_blockmap is throwing while user locked. bmp:0x7f53c2624dc8 lockRefCount:1 created from:slib/s_csort.cxx:3249 locked from:slib/s_blockmap.cxx:1341
      ** Informational stack trace from Diagnostic Stacktrace in s_blockmap::ThrowError for user locked blockmap
      ** at slib/s_blockmap.cxx:13295 on thread 140696013534976 (TID 2327)
      **
      ** Error from IQ connection: SA connHandle: 1885 SA connID: 19 IQ connID: 0000028782 User: report_user
      ** IQ Version: SAP IQ/16.1.020/12537/P/sp02.15
      s_blockmap::ThrowError
      s_blockmap::Create
      hc_run::NewBuffer
      hc_frun::NextLoc
      hs_csortInsertPkg::NextLoc
      hs_csort::Insert
      dfo_cOrderByParaIn::ExecWork
      workAllocator::DoWork 


Read more...

Environment

  • SAP 16.0 
  • SAPIQ 16.1 SP02 PL15 and above

Product

SAP IQ 16.0 ; SAP IQ 16.1

Keywords

bmp-trace-tout , s_bufpartition::GetCleanPage , deadlock , s_blockmap::Create , 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.