<div class="gmail_quote"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Message: 4<br>
Date: Thu, 13 Mar 2008 17:19:06 -0400<br>
From: Nancy Palmquist <<a href="mailto:nlp@vss3.com">nlp@vss3.com</a>><br>
Subject: Re: fpCGI failure<br>
To: Tyler Style <<a href="mailto:tyler@healthyhabitsweb.com">tyler@healthyhabitsweb.com</a>><br>
Cc: <a href="mailto:filepro-list@lists.celestial.com">filepro-list@lists.celestial.com</a><br>
Message-ID: <<a href="mailto:47D99A4A.3050906@vss3.com">47D99A4A.3050906@vss3.com</a>><br>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed<br>
<br>
Tyler Style wrote:<br>> It would be very odd for one report bombing out to block every<br>
> subsequent report from running; if that was the case, it should bring<br>
> our whole system to a halt right away as no one would be able to run<br>
> reports at all. I think this isolates it pretty much to the actual<br>
> fpcgi binary.<br>
<br>
Not odd at all. I see just this behavior when something gets stuck and I hit<br>
the license limit. Then everything gets stuck.<br><br>
<br>
The hung process is waiting for something.</blockquote><div><br>Ah. Licensing is definitely not the issue here, I am certain of that. And the process is not hung; there are no entries in the process table for it. Besides, what would processing like<br>
<br>::html :cr @pw{".htm"
<br>::html :tx "running"
<br>::html :cr-
<br>::exit
<br><br>be waiting on? No, we're pretty sure it's the binary.<br><br></div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Feature of fpcgi - look in those docs. Ask Ray to send you current ones if you<br>
don't have time. This was new to 2.0.</blockquote><div><br>Yah, fptech hasn't put it in the online manual, and our reseller never gave us the dox. We'll have to see about getting some. <br><br></div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Is this 5.6 and if it is, did someone tell you how to check to see if the<br>
licensing was exceeded? I have 5.6 but have not used it enough to remember how<br>
to handle the tools.</blockquote><div><br>5.0.14, and no licensing issues.<br> </div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">I had issues like this with filePro. It would exit with a Seg Violation. The<br>
Return code 0 tells you nothing. These errors were buggers to find. I added<br>
log entries to my processing using LOGTEXT so I could narrow down to where the<br>
crash was happening.</blockquote><div><br>We've definitely had our share of those! :P They are no fun. <br><br></div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
I can honestly say that it could be hundreds of things but here is my check this<br>
list:<br>
<br>
1) make sure you are not using a Declared Variable that matches a Field Heading.<br>
2) make sure you lock and write all records that you change.<br>
3) make sure all variables are defined correctly.<br>
4) check your labels and make sure they do not match declared variables, array<br>
names, commands, or aliases.<br>
<br>
I fussed with stuff for months until I finally found it. I think the<br>
suggestions about writing stdout and errout to files helped. Also running it<br>
outside of fpcgi, in a test mode, pointed out a few issues.<br>
<br>
My tables use many calls, Open(), import/export, all those things, and when<br>
tables are layered like that it is easy to tromp on something.<br>
<br>
Once I got it fixed, it has run flawlessly for months. I know it can work, the<br>
error was mine. It would have been nice if filePro could have helped with<br>
better syntax checking or something but the responsibility is all mine.</blockquote><div><br>As the processing table above shows, it is definitely not a processing table issue. There's nothing there for it to die on. Also, most of our processing doesn't use any HTML in filepro at all. We pump out JSON formatted datagrams to AJAX mostly.<br>
<br></div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
I works exactly as you indicated, when it is broken. You set variables to tell<br>
filePro to continue after x seconds, so it just fails and fpcgi returns nothing<br>
since filePro made nothing. fpCGI is very happy, you are not back at the web<br>
page since nothing is there.</blockquote><div><br>> BROKEN submission:<br>
> ----------------<br>
> 2008-03-06 14:22:26 INFO PID(00008186) SUCCESSFUL return from command designated in Field_cmd<br>
> 2008-03-06 14:22:26 INFO PID(00008186) Command string is
/appl/fp/rreport ajax -fp cWebInvoice -sr 34 -n -u -y automaticCGI -rw
/usr/local/apache/htdocs<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">/rweb2a2<br>
> 2008-03-06 14:22:26 INFO PID(00008186) Return code from command is 0. Errno is 0<br>
> 2008-03-06 14:22:26 INFO PID(00008186) Command as returned by cgival(Field_cmd1) is L<br>
> <snip><br>
> 2008-03-06 14:22:26 DEBUG PID(00008186) fpcgi.c 001553 Checking to see if [/usr/local/apache/htdocs/rweb2a2.htm] exists<br>
> 2008-03-06 14:22:26 DEBUG PID(00008186) fpcgi.c 001573 No. It does not exist. Errno is 2</blockquote><div> <br></div>That's the problem, it IS broken there - there SHOULD be output. If it is returning without an error, then like the 1200 trial runs before it, there should be output. That exact command was run flawlessly hundreds of times before, with exactly the same data. Suddenly, it is not pumping out files anymore, and every subsequent process that runs via fpcgi after that also fails to output anything at all, regardless of the command being run.<br>
<br>Tyler<br></div></div>