SAP Knowledge Base Article - Preview

3322564 - A query with "... LIKE '%...' " pattern matching encounters a session hang or goes to defunct mode.

Symptom

A query with "... LIKE '%...' " pattern matching encounters a session hang or goes to defunct mode. Finally IQ must be killed, because 'stop_iq' doesn't work.

While problem session is in pending mode, stack dump shows like this,

===== Thread Number ... =====
..
.. <unknown>
.. hos_basic_mbtext<unsigned char*, int, int>::regexp_match( ..
.. hos_basic_mbtext<unsigned char*, int, int>::Like( ..
.. s_dpNBitFetch::Find( ..
.. hs_dp::ConstructLookupFind( ..
.. vpp::ExecuteParallelFind( ..
.. vpp_Like::ExecutePartialMatch( ..
.. vpp_Like::ExecuteOpus( ..
..


Read more...

Environment

SAP IQ16.1 SP05 PL06

Product

SAP IQ 16.1

Keywords

Like , defunct, unresponsive, zombie , , 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.