Symptom
Trying to restore a SAP IQ server results in zombie process. Restore does not complete, no database or related files get created indicating nothing is happening.
- Executing ps shows
[iq@XXX DEVIQ1]$ ps -ef | grep iqsrv
iq 10637 43742 0 05:58 pts/2 00:00:00 grep iqsrv
iq 51941 1 0 03:41 ? 00:00:03 [iqsrv16] <defunct>
iq 61675 1 87 Jul19 ? 4-16:54:57 [iqsrv16] <defunct>
iq 64090 1 0 Jul24 ? 00:00:00 [iqsrv16] <defunct>
iq 64713 1 0 Jul24 ? 00:00:10 [iqsrv16] <defunct> - netstat shows IQ PID in CLOSE_WAIT state
[iq@XXX DEVIQ1]$ netstat -n | grep 2638
tcp 0 0 127.0.0.1:2638 127.0.0.1:4651 CLOSE_WAIT
tcp 9 0 10.16.16.108:2638 10.16.16.101:35523 CLOSE_WAIT
tcp 0 0 127.0.0.1:2638 127.0.0.1:40410 CLOSE_WAIT
tcp 0 0 127.0.0.1:2638 127.0.0.1:1265 CLOSE_WAIT - pstack on a running IQUtility process shows all threads are waiting on operating system tasks to complete
Threads (1): 2
UnixTask::wait(unsigned short)
CondVar::wait(Mutex&)
CountingSemaphore::wait()
c_engine_env_notifier::listener(void*)
run_task_body
UnixTask::pre_body(void*)
Threads (1): 10
semop
sysv_waiton_semaphore
c_strm_shm_port::listen(ShmThreadLauncher*)
run_task_body
UnixTask::pre_body(void*)
Read more...
Environment
- SAP IQ16.0
- SAP IQ16.1
- Linux
Product
SAP IQ 16.0 ; SAP IQ 16.1
Keywords
hung , timeout , dblocate, utility_db , util , database , OS , 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.