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.
SAP Knowledge Base Article - Preview