3728887 - IQ Server nonresponsive

• IQ server non-responsive
  
  
• No users can connect
  
  
• In Srvlog, messages logged during the issue
  I. *** <,451,CONNECT
  W. **** Task 0x1302420(Request task 124) is trying get forbid mutex held by task 0x131d040(Request task 224) for more than 60000 ms
  W. **** Task 0x131d040(Request task 224) state: OS thread id=0x7f6808081700
  W. **** Task 0x131d040(Request task 224) state: worker=0x7f691c011550 wakend=0 waiting=0
  W. **** Worker 0x7f691c011550 state: wakend=0 waiting=0 in_atomic=0 is_dedicated=0 in_critical_section=0 allow_forbid=1
  I. *** <,452,CONNECT
  
  
• Pstack contains one thread with

 
 Worker::yield_to_forbidding()
 Worker::do_wait
 WorkerCondVar::do_waitsig
 CircularBuffer::get_next_object
 CircularBuffer::read_next
 StmtPerfCacheThread::do_work(
ExternalCallThread::worker
run_task_body () 

and other threads like

pthread_cond_wait 
UnixTask::wait 
CondVar::wait
WorkerPool::join
Worker::access_db
EngStream::handle_ind
EngStream::execute
RQConnItem::do_request
RQBaseItem::do_work
RequestQueue::worker_body
request_task

hos_condvar::Wait()  
st_txnMgr::AssignDeferredVersionID 
db_Catalog::FindTableByITable 
db_Catalog::Create1Index
db_Catalog::CreateIndex
db_sqlcreateindex::Execute
st_command::DoCmdThroughResourceGate
db_iqddl::CreateIndex
UIQDDL_CreateIndex
st_SAIQInterfaceInfo::callFunction
st_SAIQInterface::RunIQFunc
st_SAIQInterface::Execute
saint_iqthresholdddl::CreateIndex
dbi_createindex
DoExecuteBodyLocal
DoExecuteStmt

• SAP IQ 16.1 SP05 PL15
• SAP IQ 16.1 SP05 PL16

sybase, CR831877, CR#831877, 831877 , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , Problem