Operating System - HP-UX
1748185 Members
4422 Online
108759 Solutions
New Discussion юеВ

program is hanging intermittently on HP

 
Sup
Advisor

program is hanging intermittently on HP

Hi,

My program is hanging intermittently on HP. I have killed the process using kill -11 to get a core file. The core file tells that it was haning at ociexe and last call in stack trace is _read_sys.

First core file..

(gdb) where
#0 0x1fe010 in _read_sys ()
#1 0xc0090930 in cma_read () from /usr/lib/libcma.1
#2 0x17682c in nttoread ()
#3 0x1658e8 in nttrd ()
#4 0x13c2d0 in nsprecv ()
#5 0x1403d0 in nsrdr ()
#6 0x103010 in nsdo ()
#7 0xd157c in osnqrc ()
#8 0x925d0 in ttcdrv ()
#9 0x11dff4 in osnqwa ()
#10 0x8a4f4 in upirtrc ()
#11 0x8be20 in kpuexe ()
#12 0x8211c in upiex0 ()
#13 0x81a00 in upiexn ()
#14 0x7687c in ociexe ()
#15 0x3e784 in send_sql (buffer=0x4009a978 "BEGIN :retVal := event_state('SS1002ivql01', 2, 5645695); END;")
at /utils/home/Manager.c:4032

The second core file has following stack trace

#0 0x1fe010 in _read_sys ()
(gdb) where
#0 0x1fe010 in _read_sys ()
#1 0xc17cf554 in cma__hp_fd_reserve () from /usr/lib/libcma.1
(gdb)

CPU utilization is 0% and stream is 100%.

Is it a know problem on HP? Do we have any patches?

Thanx in Advance.
Raj
9 REPLIES 9
Bill Hassell
Honored Contributor

Re: program is hanging intermittently on HP

Without the source code and more information about what the program is trying to do, it will be impossible to give a useful answer. Start by patching your system to the current level (March 2002 or perhaps Dec 2001) using your Support Plus CDROM. If you don't have that CD, you can download it from:

http://www.software.hp.com/SUPPORT_PLUS/


Bill Hassell, sysadmin
Sup
Advisor

Re: program is hanging intermittently on HP

Hi,

It is a OCI (Oracle call interface ) program.
It runs oracle stored procedure using oexec (Orcal OCI call )call. We have this problem only on HP 11. We don't have problem on other Unix flavors.

Thanx
Jeff Schussele
Honored Contributor

Re: program is hanging intermittently on HP

Have you checked /var/adm/syslog/syslog for any logged errors happening at the core dump times?
Could be you're running out of a resource.
Also have the Oracle logs been checked by the DBAs?

Rgds,
Jeff
PERSEVERANCE -- Remember, whatever does not kill you only makes you stronger!
Ceesjan van Hattum
Esteemed Contributor

Re: program is hanging intermittently on HP

My idea: do not update your system up unto a certain patchlevel until you know what the actual problem is. Upgrading without knowing what you do might introduce more problems and not solve your problem.
So.. have a look at http://www.usg.edu/OIIT/eas/ts/techdoc/hp1132_80521inst.html
It is about Oracle on HP11; search for "hang" and you will find some known bugs and their fixes.
Success,
Ceesjan
harry d brown jr
Honored Contributor

Re: program is hanging intermittently on HP

Raj,

What version of Oracle are you running? What version of HPux 11.00 are you running, 32 bit or 64 bit? What did you use to recompile your C program?

live free or die
harry
Live Free or Die
Sup
Advisor

Re: program is hanging intermittently on HP

Thanx lot to all..
.
Sup
Advisor

Re: program is hanging intermittently on HP

Thanx lot to all..
.
I am running on HP11 32-bit. Oracle version is 8.1.6.2. I worked with Oracle Support, Didn't get any workaround/Solution. I can't even time-out these OCI calls. OCI calls igonoring ALARM signals. Compiled on HP10.20 and HP11, same results.

---------------------------

Wait States PID: 9502,
autooper
Event %
----------------------------
----
IPC : 0.0
Job Control: 0.0
Message : 0.0
Pipe : 0.0
RPC : 0.0
Semaphore : 0.0
Sleep : 0.0
Socket : 0.0
Stream : 100.0
Terminal : 0.0
Other : 0.0

CPU Util : 0.0
Wait Reason: STRMS

Thanx
Raj

Nguyen_7
New Member

Re: program is hanging intermittently on HP

there is a bug related to nttrd known as bug #1293269 : Client/Server can hang/spin (nttrd) over an SSL connection, which is fixed in 8.1.6.3.0.
Olav Baadsvik
Esteemed Contributor

Re: program is hanging intermittently on HP


Hi,

I suggest you check if your executable is
using libpthread. If it is this will give
you problems as libcma is on your call-stack
Mixing libpthread and libcma in an application is not supported and will give
you problems.

The reason I want you to check this is that
you mention Oracle and Oracle is using
libpthread

One way to check if your application is using
libpthread is to use the chatr command:
chatr executable
will show you what shared-libs it is using.

Regards
Olav