3554197 - Large query caused IQ hang for a while then crash

• When received a very large query, IQ server went in hang state then crashed
  
  
• Query has 20,000 Substring/Convert OR conditions.
  
  
• Stacktrace looks like
  
  ***   SAP IQ Abort:
  ***      From:  stcxtlib/st_server.cxx:nn
  ***      Message: caught signal 11, program abort
  ***      Thread: mm
  **************************************************
   Stacktrace requested from stcxtlib/st_server.cxx:nn on thread mm  start stacktrace
      **  Command status when error occurred:  NO COMMAND OR CURSOR ACTIVE
  
      **  Parser command text:
  select xxx from xxx where(("SUBSTRING"("SUBSTRING"(convert(varchar,"col"),1,35),1,35) = :?)
  or ("SUBSTRING"("SUBSTRING"(convert(varchar,col"),1,35),1,35) = :?)
  or ...
  
  **  Dump all thread stacks at stcxtlib/st_server.cxx:nn  
  ***************** This is the STACKTRACE ***************
   
   hos_ABORT 
   SigHndlr 
   _ZN7OMNICTL10GetNewTreeEP13IParseSupport 
   GetNewTree 
   MakeExternalCursor 
   MakeVolcanoOptimizerCursor 
   dbi_openselect
   a_plan_cache::Open
  
  
  
• In IQ srvlog file, warning message below are logged
  
   W. nnn Task xxx(Request task xx) is trying get forbid mutex held by task xxx(Request task xx) for more than xxx ms
   W. nnn Task xxx(Request task xx) is trying get forbid mutex held by task xxx(Request task xx) for more than xxx ms 

SAP IQ

CR830149, CR#830149, 830149, sybase , KBA , BC-SYB-IQ , Sybase IQ , Product Enhancement