SAP Knowledge Base Article - Preview

2787689 - Delete query went to pending problem with stack 's_llhtable::hti_lookup_delete' and couldn't be dropped connection -- SAP IQ

Symptom

A DELETE query session goes pending status with spending CPU usage on IQ16.1 SP2.14. But the same delete query has been working well in old version SP02.03 without any symptoms.

  • While repro test, found below status.

  1. It looks the delete query goes infinite loop , spendign CPU.

  2. Repro is available ONLY when Non_Ansi_Null_Varchar ='ON', default is OFF.

    Under Non_Ansi_Null_Varchar ='OFF', any delete is working well. But customer has been using the option to ON from prior versions , and now it's hard to convert the option to OFF due to existing queries.

  • 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, , 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.