SAP Knowledge Base Article - Preview

2262751 - Server hang during DROP PARTITION - SAP IQ

Symptom

  • During drop partition --'Alter ... Dro pPartition ...', no new connection is allowed to connect to the IQ server.
  • Functions in pstack offending thread : hos_condvar::Wait hdb_delete_indices::Delete_Indices hdb_hdelete::Delete db_alterpartition::Execute st_command::DoCmdThroughResourceGate db_iqddl::AlterPartition UIQDDL_AlterPartition saint_iqthresholdddl::AlterTableCall2 dbi_alter
  • Functions in pstack in some other threads : CondVar::wait Worker::yield_to_forbidding Context_switch dfo_MaterializePack::PopulateFully dfo_Materialize::DoFirstFetch dfo_Base::Fetch dfo_Root::DoFetch dfo_Root::DoFirstFetch dfo_Base::Fetch  dfo_Root::DoFetchRelative


Read more...

Environment

  • SAP IQ 15.4 esd5.x

Product

SAP IQ 16.0

Keywords

  • "IQ server hung" "alter table" "drop partition" "hos_condvar::Wait" "hdb_delete_indices::Delete_Indices" "hdb_hdelete::Delete" "db_alterpartition::Execute" "st_command::DoCmdThroughResourceGate" "db_iqddl::AlterPartition" "UIQDDL_AlterPartition" "saint_iqthresholdddl::AlterTableCall2" "dbi_alter"
  • "CondVar::wait" "Worker::yield_to_forbidding" "Context_switch" "dfo_MaterializePack::PopulateFully" "dfo_Materialize::DoFirstFetch" "dfo_Base::Fetch" "dfo_Root::DoFetch" "dfo_Root::DoFirstFetch" "dfo_Base::Fetch"  "dfo_Root::DoFetchRelative"
, 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.