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

Search for additional results

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