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

  • IQ 16.1 SP02 PL15+
  • IQ 16.0

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

Search for additional results

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