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