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
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.
SAP Knowledge Base Article - Preview