- 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 ..
SAP IQ16.1 SP02.14
delete hang, drop connection, hti_lookup_delete , DeleteKeyFromHash , CR819197, CR 818931,CR 816345 , KBA , BC-SYB-IQ , Sybase IQ , Problem
About this pageThis 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.