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