Symptom
-
SAP IQ 15.4 hang when running a query with very large nested SQL expressions.
-
We can see lots of threads like below when IQ becomes non-responsive for a period of 20 minutes to few hours:
----------------- lwp# 287 / thread# 287 -------------------- lwp_park cond_wait_queue cond_wait pthread_cond_wait __1cIUnixTaskEwait6MH_H_ __1cHCondVarEwait6MrnFMutex__v_ __1cGWorkerTyield_to_forbidding6M_v_ __1cOContext_switch6FI_I_ __1cIdfo_ScanHDoFetch6MnUa_cursor_orientation__nDdfoGStatus__ __1cIdfo_BaseFFetch6MnUa_cursor_orientation__nDdfoGStatus__ __1cIdfo_RootHDoFetch6MnUa_cursor_orientation__nDdfoGStatus__ __1cIdfo_BaseFFetch6MnUa_cursor_orientation__nDdfoGStatus__ __1cIdfo_RootPDoFetchRelative6Mipi_nPa_search_status__ __1cIdfo_RootNFetchRelative6Mipi_nPa_search_status__ __1cJdbi_fetch6FpnLa_db_cursor_iHIIIII_I_ __1cRdo_cursor_execute6FpnKConnection_pnGa_stmt__v_ __1cTdb__execute_any_imm6FpnKConnection_pnSan_sqlpres_receive__v_ __1cQRequestProcedureEcall6M_v_ __1cHContextEcall6MpnJProcedure_pp0_v_
Read more...
Environment
-
SAP IQ 15.4
-
SAP IQ 16.0
-
SAP IQ 16.1
Product
SAP IQ 16.0 ; SAP IQ 16.1 ; SAP Sybase IQ 15.4
Keywords
CR814135, CR-814135, CASE statement, crash, SQLParser::pa_add_to_inlist
, KBA , BC-SYB-IQ , Sybase IQ , Bug FiledAbout 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.