2356855 - sp_iqrebuildindex s_bufman abort ERROR: Destroying Locked Logical Buffer - SAP IQ | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2356855 - sp_iqrebuildindex s_bufman abort ERROR: Destroying Locked Logical Buffer - SAP IQ

Symptom

  • Post upgrade to SAP IQ 16.0 SP11 from Sybase IQ 15.4  rebuilding tables  to convert FP indexes to NBit.

  • While executing sp_iqrebuildindex of an IQ table, it caused a server crash at s_bufman.cxx while "Destroying Locked Logical Buffer" 
    **************************************************
    *** SAP IQ Abort:
    *** From: slib/s_bufman.cxx:5313
    *** PID: 2583
    *** Message: Destroying Locked Logical Buffer
    *** Thread: 588 (TID: 579)
    **************************************************
  • stack trace cotains this method call sequence
    s_bufpartition::DestroyLogicalBuffer
    s_blockmap::DestroyIfExists
    s_mergeFINALWriter::CompletePage()
    s_mergeFINALWriter::DoInsert()
    hs_dpInsert::Insert(s_ColumnVector const*)
    dfiio_FP::FetchOpus()
    dfo_IndexInsert::FetchOpus()
    df_CombinerFetchContext::Fetch()
    hc_dfrun::FillRun
    hc_dmfrun::InitNextWorkUnit
  • running a sp_iqcheckdb  DBCC consistency check may report  'No Errors Detected' on affected table.

Read more...

Environment

  • SAP IQ16 SP11.01 on any platform
  • SAP IQ16 SP11.06 upwards , including SP11.09,  on  any platform

Product

SAP IQ 16.0 ; SAP Sybase IQ 15.4

Keywords

"s_mergeFINALWriter::RolloverNBits",  "s_bufman.cxx:5318",  "s_bufman.cxx:5357", "DestroyLogicalBuffer" , CR#809036, 809036, CR809036, sybase, fails, crash, bufman, "Buffer in main bufman", dump, pcstkwalk, ucstkgentrace, DumpAllThreads, hos_ABORT, , 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 ONE Support launchpad (Login required).

Search for additional results

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