SAP Knowledge Base Article - Preview

2787689 - A DELETE statement may have caused a server hang on some NBit FP columns. -- SAP IQ

Symptom

  • A DELETE query session goes to infinit loop with pending status and drives up CPU usage on IQ16.1 SP2.14. 
  • The delete connection cannot be dropped.
  • The option Non_Ansi_Null_Varchar is set to 'ON'.
  • When dumps stack during the pending status, it looks incorrectly working at 's_llhtable::hti_lookup_delete'.

         Thread 187 (Thread 0x7fcc0eeb8700 

.. s_llhtable::hti_lookup_delete ..
.. s_llhtable::hti_cas_delete ..
.. s_llhtable::ht_cas_delete ..
.. s_llhtable::deleteToken ..
.. s_dictionary::DeleteKeyFromHash ..
.. s_dictionary::SqueezeStrArray ..
.. s_dpNBit::Delete ..
.. hs_dp::DeleteNBit ..
.. hs_dp::DeleteInternal ..
.. hs_dp::Delete ..
.. hdb_delete_indices::Unit_of_Work ..
.. hdb_delete_indices::hdb_delete_index_iter::ExecWork


Read more...

Environment

SAP IQ16.1 SP02.14

Product

SAP IQ 16.1

Keywords

delete hang, drop connection, hti_lookup_delete , DeleteKeyFromHash , CR819197, CR 818931,CR 816345 , 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.