Symptom
IQ hang with forbid mutex held by task.
In the srvlog:
======
W. 02/06 03:54:21.109155 Task 0x17b3cb0(Request task 127) is trying get forbid mutex held by task 0x17c1d20(Request task 184) for more than 60000 ms
W. 02/06 03:54:21.109242 Task 0x17c1d20(Request task 184) state: OS thread id=0x7f92ca65d700
W. 02/06 03:54:21.109263 Task 0x17c1d20(Request task 184) state: worker=0x7f92780008c0 wakend=1 waiting=0
W. 02/06 03:54:21.109312 Worker 0x7f92780008c0 state: wakend=0 waiting=0 in_atomic=0 is_dedicated=0 in_critical_section=0 allow_forbid=1
======
In the IQMSGS:
=======
I. 02/06 03:53:21. 0004575787 IQ Checkpoint position: 0
I. 02/06 03:53:21. 0000000657 [20919]:
Delete of 24124 rows completed for table: #tb0001, 1341 seconds.
I. 02/06 03:58:05. 0004575787 Chk
I. 02/06 03:58:05. 0004575787 ChkDone [NumTxnCP: 37]
I. 02/06 03:58:05. 0004575787 IQ Checkpoint block: 629202
I. 02/06 03:58:05. 0004575787 PostChk
Read more...
Environment
SAP IQ 16.1 SP04 PL10
Product
Keywords
Unresponsive, hang, deadlock, hangup, "hang up", forbid mutex , 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.
SAP Knowledge Base Article - Preview