SAP Knowledge Base Article - Preview

3267765 - IQ server encountered intermittent hang with forbid mutex - SAP IQ

Symptom

  • IQ server becomes unresponsive intermittently, for example:

    11/06 04:48 - 11/06 05:16
    11/06 06:17 - 11/06 06:50

  • .srvlog reports such error:

    W. 11/06 05:01:13.751383 Task 14c2ca8d0(Request task 190) is trying get forbid mutex held by task 15136acd0(Request task 206) for more than 60000 ms
    I. 11/06 06:48:00.643943 Connection terminated abnormally; client socket shut down

  • Multiple jobs are canceled during the issue occurrence:

    I. 11/06 06:35:25. 0000000000 Cancellation request received

  • Stack trace:

    Threads (20): 106037255 131137757 30672583 65929313 44369513 27656993 59901341 52561507 8914079 59048743 
    .. _event_sleep
    .. _event_wait
    .. UnixTask::wait
    .. CondVar::wait
    .. Worker::yield_to_forbidding
    .. Worker::do_wait
    .. Worker::wait_ex
    .. DbCheckpoint::AcquireGate
    .. DbCheckpoint::suspend
    .. Connection::suspend_checkpoints
    .. DB_Commit_Chgs
    .. ri_commit
    .. Connection::commit_work

    Threads (1): 68092663         

     .. _event_sleep
    .. _event_wait
    .. UnixTask::wait
    .. CondVar::wait
    .. TimedMutex::get
    .. ForbidMutexSet::get
    .. Worker::get_forbid_mutex
    .. Worker::get_forbid_mutex
    .. Worker::prevent_forbid
    .. Connection::PreventForbid
    .. SQLAEngineSupport::AcquireResources
    .. st_SAIQInterface::Execute


Read more...

Environment

SAP IQ 16.1 SP04 PL12

Product

SAP IQ 16.1

Keywords

 Sybase , CR809642 , CR#809642 , deadlock, hang , freeze, bugzilla 154803 , bugzilla 154804, iqpartition, -iqpartition, contention,  , KBA , BC-SYB-IQ , Sybase IQ , 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.