SAP Knowledge Base Article - Preview

2535969 - Trying to restore a SAP IQ server results in zombie process

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.