- 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 for Me (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.