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
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.