call of stored procedure possibly causing process to hang

[Nancy McDaniel]

We run cloverleaf 5.3 on windows environment.

I recently implemented some tcl code that does a call (from the system level) of an exe that calls a stored procedure in informix.  My code parses out ORU result messages, gets order# and dr# and passes this to the exe which calls an informix stored procedure with these 2 parms.  If it returns successfully, I display a message in the tcl procedure. I have catch logic that displays the returned error message.

this call to the stored procedure was tested extensively from the command line at windows.  Also, I tested it from both tps and route testing before it was implemented.

It will run fine for some time and then it seems like our process gets hung for our production site (we only have the one process with approx 20 threads) on this site.

I get no error messages in my process log files.  I can see maybe one state 14 messages but not a bunch going to the same thread.

I put displays with timestamps in my tcl code to display at the beginning of the tcl code and at the end so I can see how long it takes to return and what the args passed to the call are.

I am attaching my tcl code.

Does anyone have any ideas to troubleshoot what is going on.  It seems to run fine and then we have an issue.  Most of the time there is a problem, the procedure has just completed.  Sometimes, I will get one of my threads that disconnects and connects again (external system) that shows up as pdl error in the process log right after the tcl call and it is the last thing in the process log.

Is there something different that I need to do with my catch logic in the tcl procedure, any other ideas? What happens if a system call gets hung, should it be hanging our process if it is just hung on my thread?

I appreciate any assistance on this.

thanks,

Nancy

Topic

[Anonymous]

We run on AIX so I’m not sure this will help you.

But try looking at the process running on your windows box. See if any processes seem to be hung or are sucking up all you CPU or Network. This may or may not be of use.   I had a similar problem on AIX and looking at system Activity helped. Found out it was hitting unknown conditions when passing certain parabeter to the stored procedure.

Also get with you Database administrator. He should be able to tell what is going on from his stand point and that could help.

[Nancy McDaniel]

John – I checked on the cpu processes, etc. Nothing out of the norm.  I had our dba check out the stored proc and db, nothing jumped out. Also, I did run this by support and Charlie said he didn’t see any issues with the tcl code I had that called the exe that kicks off the stored proc.  There is an issue with windows 2003 and using the exec command but we are on Windows 2000.

Support is having us put full debug on.  We went through a full day yesterday without it getting hung.

Also, another issue (not sure if it is causing this problem or was totally separate). I had some issue with an outbound thread not responding back on acks and backing up. I finally got the latest recover33 files and have put these on the threads. That problem seems to have been resolved.

Going to monitor it and see if we are still getting hung processes.

thanks,

Nancy

[Author]

Replies