SAP Knowledge Base Article - Preview

3354287 - An Insert transaction causes server hang and this message '...trying get forbid mutex...' was logged before the hang - SAP IQ

Symptom

An INSERT transaction causes server writer node to hang completely. The INSERT transaction looks like this,

 => Insert Into Tab_001 ( col_01, col_02, .... col_nnn ) Values ( :?,:?,:?, ...,:?,:?,:?,:? )

Just before the hang below messages were appeared in the server log,

  W. 06/02 11:29:38.701124 Task 0x1532f90(Request task 408) is trying get forbid mutex held by task 0x15317f0 (Request task 402) for more than 60000 ms
  W. 06/02 11:29:38.701240 Task 0x15317f0(Request task 402) state: OS thread id=0x7f6b69141700
  W. 06/02 11:29:38.701301 Task 0x15317f0(Request task 402) state: worker=0x7f6ae00008c0 wakend=1 waiting=40

It seems following 2 threads implicated to the hang ….

Threads (...):
.. pthread_cond_wait ..
.. UnixTask::wait ..
.. CondVar::wait ..
.. TimedMutex::get ..
.. Worker::get_all_forbid_mutexes ..
.. Worker::forbid ..
.. DB_Commit_Chgs ..
.. Connection::commit_work ..
.. DoExecuteStmt ..
.. db__execute ..
.. RequestProcedure::call ..
.. Worker::spawn ..
.. EngStream::handle_ind ..
.. EngStream::execute ..
.. RQConnItem::do_request ..
.. RQBaseItem::do_work ..
.. RequestQueue::worker_body ..
..

Thread (...) ;
.. pthread_cond_wait ..
.. UnixTask::wait ..
.. BaseRWLatch::wait ..
.. BaseRWLatch::get_exclusive ..
.. CacheInfo::Latch ..
.. CacheImpl::Install ..
.. CacheImpl::Lock ..
.. DbTempBlob::release_pages ..
.. DbTempBlob::~DbTempBlob ..
.. DbTempString::~DbTempString ..
.. DbTempString::~DbTempString ..
.. dfv_Value::freeString ..
.. dfv_HostVars::ReadNextRow ..
.. SACursor::GetNextHostVarRow ..
.. SACursorExternalHandle::GetNextHostVarRow ..
.. UICursor_GetNextHostVarRow
.. st_SAIQInterfaceInfo::callFunction ..
.. st_SAIQInterface::Execute ..
.. dfo_ScanHostLeaf::FetchOpus ..
.. dfo_ColumnVectorBase::FetchOpus ..
.. dfo_RowID::FetchOpus ..
.. dfo_IndexInsert::FetchOpus ..
.. dfo_Sequencer::FetchOpus ..
.. dfo_Root::FetchOpus ..
.. dfo::Fetch ..
.. db_dmlcommand::ExecuteDFOTree ..
.. db_InsertRoot::Execute ..
.. st_command::DoCmdThroughResourceGate ..
.. st_iqdml::Insert ..
..


Read more...

Environment

SAP IQ 16.1 SP04 PL11

Product

SAP IQ 16.1

Keywords

unresponsive, get_all_forbid_mutexes , BaseRWLatch::get_exclusive, forbid , , 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.