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 for Me (Login required).

Search for additional results

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