Symptom
IQ server becomes unresponsive intermittently with following message in .srvlog/.stderr. logs:
- Task 0x1dd4bf0(Request task xxx) is trying get forbid mutex held by task xxxxxxx(Request task xxx) for more than xxxxxx ms
- Task xxxxxxx(Request task xxx) state: OS thread id=xxxxxxxx
- System crashes after launching the query and no functions in UI (User Interface) can be used to cancel query.
- The SQL query, which has 35 nested "JOINs" and "GROUP BYs" and is growing exponentially, is responsible for infinite runtimes.
Read more...
Environment
SAP IQ 16.1 SP05
Product
SAP IQ 16.1
Keywords
hang, deadlock, hangup, "hang up", hung, CR828894, CR#828894, 828894, "forbid mutex", CR829015, CR#829015 , 829015 , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , Known Error
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.