2535969 - Trying to restore a SAP IQ server results in zombie process | SAP Knowledge Base Article

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.