SAP Knowledge Base Article - Preview

3580794 - IQ server is not responsive seems hang - IQ 16.1 SP05.11

Symptom

IQ simplex server is not responsive for 1 hour, during the time, no one can connect to the server and the all applications seem hang, restart the IQ server is requested.

Messages in iqmsg file:
I. 03/03 05:45:45. 0000000000 139957033727744 s_buf::WaitForSignal_DontCareIfBusy- Timed out on _condvar, timeout value= 10 secondssbuf= 0x7f496a6c35d0 btype= 7
I. 03/03 05:45:55. 0000000000 139957033727744 s_buf::WaitForSignal_DontCareIfBusy- Timed out on _condvar, timeout value= 20 secondssbuf= 0x7f496a6c35d0 btype= 7
I. 03/03 05:46:05. 0000000000 139957033727744 s_buf::WaitForSignal_DontCareIfBusy- Timed out on _condvar, timeout value= 40 secondssbuf= 0x7f496a6c35d0 btype= 7
I. 03/03 05:46:15. 0000000000 139957033727744 s_buf::WaitForSignal_DontCareIfBusy- Timed out on _condvar, timeout value= 80 secondssbuf= 0x7f496a6c35d0 btype= 7
I. 03/03 05:46:25. 0000000000 139957033727744 s_buf::WaitForSignal_DontCareIfBusy- Timed out on _condvar, timeout value= 160 secondssbuf= 0x7f496a6c35d0 btype= 7
I. 03/03 05:46:35. 0000000000 139957033727744 s_buf::WaitForSignal_DontCareIfBusy- Timed out on _condvar, timeout value= 320 secondssbuf= 0x7f496a6c35d0 btype= 7

Messages in srvlog file:
W. 03/03 05:46:35.718146 Task 0x25fb590(Request task 347) is trying get forbid mutex held by task 0x2600e60(Request task 376) for more than 60000 ms
W. 03/03 05:46:35.718249 Task 0x2600e60(Request task 376) state: OS thread id=0x7f60d2f69700
W. 03/03 05:46:35.718289 Task 0x2600e60(Request task 376) state: worker=0x7f6098000bb0 wakend=1 waiting=0
W. 03/03 05:46:35.718326 Worker 0x7f6098000bb0 state: wakend=0 waiting=0 in_atomic=0 is_dedicated=0 in_critical_section=0 allow_forbid=1
I. 03/03 05:47:35.973287 Connection terminated abnormally
I. 03/03 05:47:35.973384 Disconnected TCPIP client's AppInfo: HOST=0d9d6b6c-beb4-47eb-63f2-f9a2;PID=25;EXE=java.lang.Thread
I. 03/03 05:47:36.392803 Connection terminated abnormally
I. 03/03 05:47:36.392878 Disconnected TCPIP client's AppInfo: HOST=7f19485b-013a-401b-40d6-7ad3;PID=19;EXE=java.lang.Thread
I. 03/03 05:47:38.455007 Connection terminated abnormally
I. 03/03 05:47:38.455087 Disconnected TCPIP client's AppInfo: HOST=64579972-8d1b-4316-5d8b-e599;PID=20;EXE=java.lang.Thread
I. 03/03 05:47:39.358415 Connection terminated abnormally

OS thread id=0x7f60d2f69700 was running checkpoint and hold the mutex lock:-

Thread 388 (Thread 0x7f60d2f69700 (LWP 316731)):
...__lll_lock_wait
...pthread_mutex_lock
...s_blockmap::Unlock
...st_txncb_rfrbInfo::__Destruct
...st_txncb::CheckpointDeallocate
...st_txnMgr::Checkpoint
...db_Checkpoint::Execute
...st_command::DoCmdThroughResourceGate
...st_iqtxn::Checkpoint
...UIQTxn_Checkpoint
...st_SAIQInterfaceInfo::callFunction
...st_SAIQInterface::RunIQFunc
...st_SAIQInterface::Execute
...saint_iqthresholdtxn::Checkpoint
...CheckpointBegind int
...DB_Do_Checkpoint
...DB_Checkpoint
...DbAutoCkpt::force_checkpoint 
...DbAutoCkpt::sample
...DbAutoCkpt::do_request 
 


Read more...

Environment

SAP IQ 16.1 SP05 PL11

Product

SAP IQ 16.1

Keywords

KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , 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.