SAP Knowledge Base Article - Preview

2262734 - Server hang during DROP INDEX - SAP IQ

Symptom

  • Dropping and HG index on an SAP IQ 16 server that was upgraded  SAP IQ 15.x could hang the server
  • Message in the .iqmsg: Index Rebuild in progress for "DBA"."tab" column "col1" column "col2" column "col3" column "col4" column "col5" column "col6" column "col7" column "col8" column "col9" column "col10" column "col11" column "col12" column "col13" column "col14"
  • Functions in the pstack: hc_dmfrun::SelectInputRun hc_dmfrun::SelectInputRun hc_dmfrun::AdvanceBuffer dfo_Combiner::FetchOpus dfo_Sequencer::FetchOpus dfo_Root::FetchOpus dfo::Fetch db_dmlcommand::ExecuteDFOTree db_RebuildIndex::Execute db_TableDef::RebuildIndex db_Catalog::FindTableByITable db_Catalog::DropIndex st_command::DoCmdThroughResourceGate db_iqddl::DropIndex UIQDDL_DropIndex st_SAIQInterfaceInfo::callFunction st_SAIQInterface::RunIQFunc st_SAIQInterface::Execute saint_iqthresholdddl::DropIndex dbi_dropindex DoExecuteStmt


Read more...

Environment

  • SAP IQ 16.x

Product

SAP IQ 16.0

Keywords

  • "Drop HG index" "Index Rebuild in progress" "IQ server hang" "hc_dmfrun::SelectInputRun" "hc_dmfrun::SelectInputRun" "hc_dmfrun::AdvanceBuffer" "dfo_Combiner::FetchOpus" "dfo_Sequencer::FetchOpus" "dfo_Root::FetchOpus" "dfo::Fetch" "db_dmlcommand::ExecuteDFOTree" "db_RebuildIndex::Execute" "db_TableDef::RebuildIndex" "db_Catalog::FindTableByITable" "db_Catalog::DropIndex" "st_command::DoCmdThroughResourceGate" "db_iqddl::DropIndex" "UIQDDL_DropIndex" "st_SAIQInterfaceInfo::callFunction" "st_SAIQInterface::RunIQFunc" "st_SAIQInterface::Execute" "saint_iqthresholdddl::DropIndex" "dbi_dropindex DoExecuteStmt"
, 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.